How to see the structure of db2 table??
- 4 Answers
- 32162 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 is filter factor?
What does the CHECK Utility do ?
Normalization in DB2 – first normal form, second normal form
What is an access path?
How and when does the db2 enforces the unique key?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
how to unload different table data into different gdg files/ vsam files.
What does db2 mean?
What is package in db2 mainframe?
Explain about cursor stability?
What is reorg in database?
What is meant by concurrency?
COBOL 
