Interested to Buy Any Domain ? << Click Here >> for more details...
How to see the structure of db2 table??
- 4 Answers
- 32880 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 meant by union and union all?
What is the result of open cursor statement?
What is dclgen in db2?
what is a corelated subquerry?
What is a clustered index?
Give some example of statistics collected during RUNSTATS?
How would you find out the total number of rows in a db2 table?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
How to know the primary key of a table without defining the primary key in the table?
What is an intent lock?
Explain about rct in db2?
COBOL 
