What is the syntax for seeing the columns and data types of a table in the db2 database?


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

Post New Answer

More DB2 Interview Questions

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,


Is there any advantage to denormalizing DB2 tables?

1 Answers  






what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,


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

2 Answers  


Which components manage deadlocks in db2?

0 Answers  


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,


What are the benefits of using the db2 database?

0 Answers  


How do we specify index to include or not during bind process.

0 Answers   Satyam,


Categories