Explain how can you do the explain of a dynamic sql statement?

Question Posted / chandrapal singh

No Answer is Posted For this Question
Be the First to Post Answer

More DB2 Interview Questions

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

Is db2 a database?

how do you resolve -805?

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

What are the disadvantages of using VARCHAR?

What is EXPLAIN?

Where can you declare a cursor in a cobol-db2 program?

How to find last record before record through SQLRPGLE?

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

can any one give the list of some important sql abend codes which r frequently asked in interviews?

How do you concatenate the firstname and lastname from emp table to give a complete name?

What is a DB2 access path?

For more DB2 Interview Questions Click Here