what is the process of precompiler?2 6312
what is REORG? what is the use?4 5885
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 2579
How do you filter out the rows retrieved from a Db2 table ?1 3852
What is a clustered index?1 7021
When will you chose to run RUNSTATS?1 4547
What does DML stand for and what are some examples of it?3 3226
What is meant by a unit of recovery?1 2136
What is CHECK PENDING ?4 8509
What is a thread?3 2723
What is filter factor?2 6086
What's the maximum number of volumes that can be added to a STOGROUP?1 4587
How to test SQL -911 error while developing COB-DB2 program
How can you get the number of rows impacted by the last executed query?
what is the sqlcode -501
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How to fetch the uncommited data from table ?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
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.
What will happen, while trying to close the closed cursor.
what is utility for parm lib
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
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?
what is diffrence b/w file-aid tool and file-aid utility???
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 .....