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
2071by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
4 9220the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
2 6186
How to execute stored procedure in db2 command editor?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Define db2.
What are the contents of dclgen?
What is the purpose of rollback and commit?
Which component is responsible for processing sql statements and selecting access paths?
What is a db2 table?
Why db2 is called db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
what is the responsibility of the construction superintendent
How do I copy a table in db2?
i want to maintain uniqueness on pdf without make lf??????????
What is access path in db2?
What is query_cache_limit?
How and when does the db2 enforces the unique key?