Count No. Of columns

nileshyp · New User Joined: 22 Jun 2005 Posts: 65 Location: Mumbai

Hi,

Could someone tell the query to find count of columns in a table.
Like in ORACLE there is something call DESC <table_name>

For Ex.
SELECT * FROM SYSIBM.SYSPLAN;
How can we find out as to how many columns above query will fetch?

Regards,
N

Gnanas N · Posted: Thu Sep 22, 2011 2:03 pm

cmsmoon · New User Joined: 17 Jun 2010 Posts: 75 Location: Chennai

Hi ,

You can use the below query to get no of columns in a table.

SELECT COUNT(NAME)
FROM SYSIBM.SYSCOLUMNS
WHERE TBNAME = 'table name'
AND TBCREATOR = 'table qualifier';

dbzTHEdinosauer · Posted: Tue Nov 15, 2011 7:56 pm

though the link was bad for Gnana Sekaan Nallathambi's post
the systables route seems to be a better piece of sql than
yours cmsmoon.

his is a one row, one column fetch,
yours is a multirow fetch with a scalar function.

by the way, the term fetch is used as is by ibm when referring to row retrieval,
not a cursor.

GuyC · Posted: Tue Nov 15, 2011 9:21 pm

DESCRIBE

Including dynamic SQL for varying-list SELECT statements in your program