How to see the structure of db2 table??

Answers were Sorted based on User's Feedback



How to see the structure of db2 table??..

Answer / kc

SELECT colName,TypeName FROM SYSCAT.COLUMNS WHERE TABSCHEMA = <database> AND TABNAME =<tablename>

Is This Answer Correct ?    0 Yes 0 No

How to see the structure of db2 table??..

Answer / s

Select the catalog table SYSIBM.SYCOLUMNS for a particular
table.

Is This Answer Correct ?    21 Yes 26 No

How to see the structure of db2 table??..

Answer / prem

Use the Describe command

eg: Describe table <tablename>

Is This Answer Correct ?    38 Yes 47 No

How to see the structure of db2 table??..

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

Post New Answer

More DB2 Interview Questions

What is the use of db2?

0 Answers  


What is collection in db2 bind?

0 Answers  


How many types of page locks can be held in db2?

0 Answers  


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 ?...

0 Answers   IBM,


What is a view? Why use it?

2 Answers  






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?

2 Answers  


What is an alias?

3 Answers  


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?

3 Answers  


How do I add a column to an existing table in db2?

0 Answers  


What language is db2 written in?

0 Answers  


What is cursor stability?

1 Answers  


Categories