what is the process of precompiler?2 8964
what is REORG? what is the use?4 7812
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?2 3510
How do you filter out the rows retrieved from a Db2 table ?1 5170
What is a clustered index?1 8479
When will you chose to run RUNSTATS?1 5625
What does DML stand for and what are some examples of it?3 4265
What is meant by a unit of recovery?1 2959
What is CHECK PENDING ?4 10350
What is a thread?3 3566
What is filter factor?2 6979
What's the maximum number of volumes that can be added to a STOGROUP?1 5626
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
is it compulsory commitment control in journal?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How to test SQL -911 error while developing COB-DB2 program
How do we specify index to include or not during bind process.
what is the sqlcode -501
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
what is the responsibility of the construction superintendent
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What r the comman abends in db2, jcl and cobol???????