How can you compare table column after update and before
update?
Answer Posted / harsha
Based on the situation, one can use Union/Inner Join.
Is This Answer Correct ? | 0 Yes | 9 No |
Post New Answer View All Answers
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 .....
Define declaration generator (dclgen).
Can you use max on a char column?
What is the maximum No of rows per page?
Differentiate between cs and rr isolation levels? Where do you specify them?
is it compulsory commitment control in journal?
What is bind in db2?
How would you find out the total number of rows in a db2 table?
What does db2 plan contain?
What's The Error Code For Unique Index Voilation?
What is isolation level in db2?
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 is cursor with hold option in db2?
What is the latest version of ibm db2?
Why select is not preferred in embedded sql programs?