Interested to Buy Any Domain ? << Click Here >> for more details...
How to see the structure of db2 table??
- 4 Answers
- 33079 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kc
SELECT colName,TypeName FROM SYSCAT.COLUMNS WHERE TABSCHEMA = <database> AND TABNAME =<tablename>
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / s
Select the catalog table SYSIBM.SYCOLUMNS for a particular
table.
| Is This Answer Correct ? | 21 Yes | 26 No |
Answer / prem
Use the Describe command
eg: Describe table <tablename>
| Is This Answer Correct ? | 38 Yes | 47 No |
Answer / 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 |
What's The Error Code For Unique Index Voilation?
How can you classify the locks in db2?
What is the purpose of the DSNC transaction ?
What is the difference between base table and view?
What is the reason behind not using select * in embedded sql programs?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is dpf in db2?
What is dynamic SQL?
How do I delete a column in db2?
Which one allows duplicate values Union or Union All ?
how do you resolve -805?
What is copy book?
COBOL 
