How to get the ddl of a table in db2?


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

Post New Answer

More DB2 Interview Questions

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  


Why select is not preferred in embedded sql programs?

0 Answers  


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


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  


Explain an outer join?

1 Answers  






What is the difference between group by and order by?

2 Answers   IBM, TCS,


What are the functions of Bind?

2 Answers   Amdocs, IBM,


can we drop column from a table

7 Answers   INDUS,


Mention the location where the output received from explain statement is stored.

0 Answers  


How would one remove old reorg information from the DB2 catalog?

2 Answers  


I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,


What is a base table?

2 Answers  


Categories