Answer Posted / lu
Before to insert, it's better to select(retrieve),test
sqlcode when 100 insert when 00 update whenever send
message and abend...You don't have an heache....
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
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
How to compare data between two tables in db2?
How to create db2 table in mainframe?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is consistency token in db2?
Mention the different locking levels that are available in db2.
What is the difference between using bind () and rebind () methods of naming class?
What is with ur in db2?
How to resolve deadlock issue
What is the use of with ur in db2?
Which component is used to execute the sql statements?
What is the physical storage length of date data type?
What is dbrm? What it contains?
Are views updateable?
How to create backup table in db2?