what is the process of precompiler?2 9646
what is REORG? what is the use?4 8423
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 3874
How do you filter out the rows retrieved from a Db2 table ?1 5617
What is a clustered index?1 8911
When will you chose to run RUNSTATS?1 5949
What does DML stand for and what are some examples of it?3 4690
What is meant by a unit of recovery?1 3279
What is CHECK PENDING ?4 10919
What is a thread?3 3889
What is filter factor?2 7266
What's the maximum number of volumes that can be added to a STOGROUP?1 5944
is it compulsory commitment control in journal?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
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
How to resolve deadlock issue
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
what is the sqlcode -501
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.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
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 ?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
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?
i want to maintain uniqueness on pdf without make lf??????????
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?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.