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
Is db2 free?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to find primary key of a table in db2?
What does db2 blu stand for?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is explain plan in db2?
Can there be more than one cursor open for any program?
What is difference between alias and synonym in db2?
Which components manage deadlocks in db2?
Describe major components of db2?
Why cursor is used in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the maximum size of varchar data type in db2?
What is db2 and what is the use of db2 optimizer?