Explain how can you do the explain of a dynamic sql statement?
Q3. How will you fetch duplicate values from a DB2 table?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What are the 2 sqlcodes that are returned?
What is UNION,UNION ALL?
How to run db2 command in windows?
What are common abends
how can we find nth max salary from A table
What is DCLGEN ?
Explain how can you do the explain of a dynamic sql statement?
What is rebind in db2?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.