How to view db2 table structure?
No Answer is Posted For this Question
Be the First to Post Answer
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 null value in db2?
Can there be more than one cursor open for any program?
How do you filter out the rows retrieved from a Db2 table ?
Plan has the optimized access path in it. But is that optimized access path is attained or known
select distinct(empid),distinct(dept),name from EMP will the above query work?
What happens in bind step in a db2 program?
What is a cursor in programming?
What is the picture clause of the null indicator variable?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is cursor with hold option in db2?
What will the DB2 optimizer do?