How to update more then one record using update?
Answer Posted / k
Don't give where command in update query
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is dbrm? What it contains?
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 .....
How can you find out the # of rows updated after an update statement?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is dbrm library?
How to find the number of rows in a db2 table?
What happens in bind step in a db2 program?
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
is it compulsory commitment control in journal?
Explain the benefits you can get from mainframe connect?
What is bufferpool in db2?
What is cobol db2?
What is db2 command?
Define predicate?
Which component is responsible for processing sql statements and selecting access paths?