What is cursor stability?
what are the bind parameters?
What is the use of runstats in db2?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
What is a plan and package in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is DB2 (IBM Database 2)?
How to find primary key of a table in db2?
how can we find nth max salary from A table
How can you find out the # of rows updated after an update statement?
Q4. How will you get the count of record without using COUNT verb in query?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)