How to see the structure of db2 table??

Answer Posted / ram prajapati

select * from SYSIBM.SYCOLUMNS where tbname='tablename';
run this querry... or
go to dclgen .... option m.11.2 in the ispf command prompt n
see the structure directly in any mentioned ps file

Is This Answer Correct ?    11 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning concurrency in the db2 database?

647


What is db2 connect?

616


How can you count the number of rows from a table tab?

647


What is check constraint in db2?

624


What is ibm db2 connect?

585






What is load replace in db2?

566


Which components manage deadlocks in db2?

619


Define buffer pool.

638


What is the max length of sqlca?

778


What is a bind in db2?

604


How to get the ddl of a table in db2?

687


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1833


What does db2 plan contain?

580


What is cascading rollback?

629


Which is faster delete or truncate?

688