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


Please Help Members By Posting Answers For Below Questions

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 .....

1884


Define declaration generator (dclgen).

658


Can you use max on a char column?

632


What is the maximum No of rows per page?

620


Differentiate between cs and rr isolation levels? Where do you specify them?

570






is it compulsory commitment control in journal?

2003


What is bind in db2?

597


How would you find out the total number of rows in a db2 table?

570


What does db2 plan contain?

567


What's The Error Code For Unique Index Voilation?

644


What is isolation level in db2?

571


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.

2316


What is cursor with hold option in db2?

606


What is the latest version of ibm db2?

728


Why select is not preferred in embedded sql programs?

702