How to view db2 table structure?


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

Post New Answer

More DB2 Interview Questions

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  


What is null value in db2?

0 Answers  


Can there be more than one cursor open for any program?

0 Answers  


How do you filter out the rows retrieved from a Db2 table ?

1 Answers  


Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,






select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,


What happens in bind step in a db2 program?

0 Answers  


What is a cursor in programming?

0 Answers  


What is the picture clause of the null indicator variable?

6 Answers  


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?

1 Answers   RBS,


What is cursor with hold option in db2?

0 Answers  


What will the DB2 optimizer do?

2 Answers  


Categories