SQL CODE -107 This error occurs when the name of the object used in the sql statement exceeds the maximum allowable length for the object name. You can check by reducing name of the object used in the sql statement or refer db2 guide for the exact details on limits for object names. Click the […]
Wed, 07/13/2011 – 16:01 #1 What changes required for changing Static calling to dynamic calling In our system we are using static calling, if I were to change this to dynamic calling what all changes would I need? I can think of the following… 1. Calling subprograms program using identifier instead of literals 2. Compiling
What changes required for changing Static calling to dynamic calling Read More »
Wed, 12/28/2011 – 10:36 #1 What is file status code of 02 in COBOL Why do we get a file status code 02 in COBOL I could find the following information on internet but is not clear to me, please help 02  Indexed files only. For a READ statement, the key value for the current
What is file status code of 02 in COBOL Read More »
What is DB2 DB2 is the short name used for DATABASE 2. It is relational database product developed by IBM. This relational database management system was released by IBM in 1983 for MVS operating system. A RDBMS system represents all information in the form of tables. A table is a two dimensional array with horizontal
Mon, 01/30/2012 – 10:07 #1 Conversion from Character to Binary Please help on the below requirement: I have an input file of LRECL=300.it is having some ‘n’ records. Split the file into 10 fields each field of length 30 bytes.Get the binary counts of 10 fields. Finally add  all the binary counts. Click the +1
Conversion from Character to Binary Read More »
Mon, 11/14/2011 – 11:08 #1 Compiler option for getting statement of abended line Can any one tell me which is the compiler option in COBOL to get the line number instead of offset of the point where the cobol program has abended? I know in my earlier organization we used to change the compiler option
Compiler option for getting statement of abended line Read More »
Tue, 07/26/2011 – 07:29 #1 CICS program does not need to open a file explicitly I noticed this while debugging a CICS program recently that CICS does not need to open a file explicitly if the file has a FCT entry. I am not sure if my conclusion is correct, but as per my observation
CICS program does not need to open a file explicitly Read More »
Tue, 02/19/2013 – 13:58 #1 -CAUTION- Profile changed to NUMBER ON STD (from NUMBER OFF) I have encountered a strange issues in PS files. The file is LRECL 8 and has the following data in it 12345678 But when I save it and reopen it, the number col has 345678 and i get a caution
Mon, 11/14/2011 – 06:17 #1 Basics of XPEDITOR Can anyone share a basic tutorial on xpeditor? I am new to this tool and would love if I can get a tutorial which would give me a hands on the tool. “; ; ; ; Click the +1 button  below to share it with your friends
Basics of XPEDITOR Read More »
Mon, 11/14/2011 – 08:24 #1 What is uncommitted read and when it is used One of the isolation level is uncommitted read or dirty read, where the application programs can access the uncommitted data before it is committed or rolled back. I need to know what could be a practical example of an application trying
What is uncommitted read and when it is used Read More »
