How to see the structure of db2 table??
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 the use of db2?
What is collection in db2 bind?
How many types of page locks can be held in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is a view? Why use it?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
How do you do the EXPLAIN of a dynamic SQL statement?
What is an alias?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How do I add a column to an existing table in db2?
What language is db2 written in?
What is cursor stability?