How to see the structure of db2 table??

Answer Posted / kc

SELECT colName,TypeName FROM SYSCAT.COLUMNS WHERE TABSCHEMA = <database> AND TABNAME =<tablename>

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between alias and synonym in db2?

644


How to execute stored procedures?

622


What is coalesce in db2?

682


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3792


Mention the definition of cobol in varchar field.

700






Why do we use cursor?

599


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

1674


Explain about rct in db2?

640


How can record locking be achieved in those DB2 versions which do not support it?

627


what are bind concepts in db2 cobol?

651


What is the physical storage length of the data types date, time, and timestamp?

610


What is innodb buffer pool?

564


What is meant by union and union all?

589


Explain db2.

618


Which components manage deadlocks in db2?

615