what is the process of precompiler?2 7496
what is REORG? what is the use?4 6765
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 2994
How do you filter out the rows retrieved from a Db2 table ?1 4404
What is a clustered index?1 7715
When will you chose to run RUNSTATS?1 5027
What does DML stand for and what are some examples of it?3 3658
What is meant by a unit of recovery?1 2515
What is CHECK PENDING ?4 9412
What is a thread?3 3092
What is filter factor?2 6518
What's the maximum number of volumes that can be added to a STOGROUP?1 5133
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
can we view the access paths created by dbrm ? how ? thx
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
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?
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.
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.
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 ?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
what is utility for parm lib
How do we specify index to include or not during bind process.
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?
what is the sqlcode -501
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