DB2 Universal Database

What are the possible situations where DB2 server FORCES to close the applications connected to it?

Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !

How to limit the number of application connections in DB2?

I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?

DB2 update query giving error STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.

The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate='01-JAN-07' WHERE username='XYZ' Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and...

DB2 and talend

I do get the error below when i try to load table in DB2 iseries through ETL tool Talend [IBM][iSeries Access ODBC Driver]Column 6: CWB0111 - A buffer passed to a system call is too small to hold return data can anyone guide me what could be the error

OLE DB using Library List

Hi, Do any one use OLE DB to connect to iSeries? Is OLE DB capable of using Library List provided by Job Description? Because when I used it, I have to specify the library name / schema and object name. Please advice... Thank you

Cannot end RGZPFM on V5R4 (Journaled file)

Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I...

bi-directional data synchronization on System i for db2 databases

I would like to know what would be the best ways to have bi-directional data synchronization on System i between db2 databases . What are the best ways to synchronize data between DDS and SQL-defined files that belong to different applications?

Backward compatibility on OS level V4R4 to V4R3

Have a question on backward compatability. Currently we moved some historical JD Edwards data that was on an AS/400 running OS400 V4R5 to a machine running V4R4. Now, we want to move this to another AS/400 that is running V4R3. Now, from V4R5 to V4R4 we havd no problems. I'm not sure if we can take...

Source Modified User

Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy

AS400

hi, i want to know about the answers of these questions.. 1.) If any data has been deleted from the PF then how can we recover that and what are the limitiations for that. 2.) If in run time user want to choose the Access Path of a PF then how can it be possible.

Excel Data Transfer Add In

I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the...

Client Access Data Transfer

I am trying to export a demand report to excel using Client Access Data Transfer. The demand report has been saved in the outque (see below). From what I understand the data to and from the iSeries must be either a database table or source physical file. How do I convert the saved report to a...

Converting from System 36 to iSeries V5R4

I've been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4. I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could'nt find anything. Does anyone have something I can use - something like the...

Select last 3 transactions

Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

URGENT!!! file field decoder generated on AS/400

REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA ...

Tracking Changes to Files

Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. 2. If Any...

Question on LoadAll Subfile.

Hi, How to load more than 9999 records in the case of loadall subfile??? And i don't want delete previously loaded records. Thanks, Rama Krishna

Error in a Group of Called Programs

Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC.......so on...10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this??? ...

V5R3 to V5R4

my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting...

Optimizing/Indexing to find last transaction

I'm hoping someone can help me out with this. I'm trying to write a query that will return the last transaction for each item in our warehouse. To do this, I'm using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 records,...