SQL to get column types of a table?

danielbrowne · #1 (**permalink**) 09-10-04, 07:25

Hi,

I have looked through various posts as well as hunted for a DB2 data dictionary but still can' t find the solution in basic SQL. Can someone even point me at
the data dictionary as I couldn't find it on the IBM site.

I can do this in Oracle, Teradata, Sybase and SQL Server but I'm fairly new to DB2.

Thanks in advance.

Cheers,
Daniel.

danielbrowne · #2 (**permalink**) 09-10-04, 07:38

I think I'm getting close with:

select name, tbname, coltype, length, scale from sysibm.syscolumns where tbname = <mytable>

I also should have said earlier that I'm running DB2 8.1 on Windows 2003 and connecting from solaris.

Romeo · #3 (**permalink**) 09-10-04, 07:47

how about:

DESCRIBE TABLE <tablename>

is that what you need?

Romeo · #4 (**permalink**) 09-10-04, 08:03

Quote:

Originally Posted by danielbrowne

I think I'm getting close with:

select name, tbname, coltype, length, scale from sysibm.syscolumns where tbname = <mytable>

I also should have said earlier that I'm running DB2 8.1 on Windows 2003 and connecting from solaris.

yup... using a select statement, that should be what you