What does CURRENTDATA option in bind indicate
Answer / s
CURRENTDATA tells DB2 whether data upon which the cursor is
positioned should remain current with the data in the base
table.
Is This Answer Correct ? | 8 Yes | 0 No |
Could anyone clearly explain the diference between sub query and correlated sub query?
How do I change the column size in db2?
why we create view.
can any one expalin check point with an example?
What is a LIKE table and how is it created?
What is the SQL Communications Area and what are some of its key fields?
Name the lockable units in DB2?
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 .....
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
what is load and unload in db2