Once you create a view, where would information about the
view be stored?
What is dynamic SQL?
What is a view? Why use it?
Where can you declare a cursor in a cobol-db2 program?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
what is difference between Static call and Dynamic call? How does it function?
How do we specify index to include or not during bind process.
In a DB2-CICS program which is acts as co-ordinator and which is participant?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
how to take the back up of the DB2 table.
Which is faster delete or truncate?
What are the contents of dclgen?