Need a query to retrieve the structure of a DB2 table

prabhucs01 · New User Joined: 07 Mar 2005 Posts: 40

what is the query that could be used to get the structure of DB2 table.

priya · Posted: Thu Apr 28, 2005 7:46 am Post subject:

Use SPUFI - DCLGEN or Try EXPLAIN Statement.

T-REXDB2 · New User Joined: 28 Apr 2005 Posts: 11 Location: USA

Basic Catalog tables:

SYSIBM.SYSDATABASE, SYSIBM.SYSTABLESPACE,SYSIBM.SYSTABLES, SYSIBM.SYSCOLUMNS, SYSIBM.SYSINDEXES,SYSIBM.SYSKEYS.

Link to IBM V8 manuals:

http://www-306.ibm.com/software/data/db2/zos/v8books.html

Link to V7 manuals:

http://www-306.ibm.com/software/data/db2/zos/v7books.html

You figure it out - it is not too difficult and you should be willing to work it out yourself. Don't wait around to be spoon fed! If you want that, go work on a Microsoft system - they have "wizards"!

T-REXDB2er

T-REXDB2 · New User Joined: 28 Apr 2005 Posts: 11 Location: USA

Basic SQL SELECT structure:

SELECT *
FROM TABLENAME1 A, TABLENAME2 B, TABLENAME3 C
WHERE
[ PREDICATE LIST GOES HERE ]
ORDER BY [SORT ORDER COLUMN LIST GOES HERE]

That is the basic SQL structure.

shymalasridevi · New User Joined: 03 May 2005 Posts: 16

to retreive the structure we have aquery

DESC TABLE TABLENAME
OR
DESC TABLENAME
SO THAT IT WILL DISPLAY THE STRUCTURE

gokuldass · New User Joined: 18 Mar 2005 Posts: 45 Location: india

hai prabhucs01..
i think this query will help u..

select * from sysibm.syscolumns where tbcreator='yourid' and tbname='tbname';

i am using the same query.. try this and reply me..