1.  Sequential files: S.NO. File Status 1 Attempt to read from a file after reaching EOF. 10 2 Attempt to open a file that was earlier closed with LOCK option. 38 3 Attempt to open a file, which is already open. 41 4 Attempt to close a file that was not opened. 42 5 Attempt […]

Static linking change made to called program not calling program We have static linking in our project. I have a COBDB2 program “B”  which is called by another COBOL DB2 program “A”. Program “A”  Now if I make changes to program B, what all steps should I do in order to get the changes picked

db2 plan used by CICS region Say suppose you are logged on to a CICS region, how would you determine the db2 plan used by the CICS region? is they any direct command for getting the plan name used by a CICS region? “; ; ; ;

USE OF ARRAYS IN CLIST   Arrays are not supported by CLIST, but REXX has this option. In case you still want to use arrays in CLIST, find below the work around. SET NUM=1                               SET &ARRAY = &STR(&&ARRAY)              DO WHILE &NUM

Adding Primary Key on exisitng DB2 Table How to defina a primary key on an existing DB2 table? To define a primary key on a table which exists you will need to use the ALTER command, the following example query will give  ALTER TABLE Table_Name ADD PRIMARY KEY (Column_one, Column_two) Where Table_Name is the name

When we are developing a program or application we always have the apprehension that what will happen if the data or application is lost due to a problem (like disk error). We take backups to avoid such situations. This is a kind of recovery plan that we have for our application. The large organizations have