How to see the structure of db2 table??
- 4 Answers
- 32054 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 PRIME TABLE and what are the uses of it
How would the varchar column remarks defined?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What if we fail to give values in columns declared as NOT NULL ?
Which are the db2 tools to protect integrity of the database?
what is the role of the cursor in db2?
What is a page in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How to resolve -504 sql code in DB2?
What is ibm db2 client?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
COBOL 
