Date:         Tue, 22 Oct 2002 21:50:22 +0200
Reply-To:     JSHansen <jan@*SELCHAU-HANSEN.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         JSHansen <jan@*SELCHAU-HANSEN.DK>
Organization: TDC Internet
Subject:      Re: Yet another basic SQL question

There is a lot of dictionary-tables in DB2.

I do not here remember them all, - but try these
 SYSIBM.SYSTABLES
 SYSIBM.SYSCOLUMNS

with SYSIBM.SYSTABLES You can find all the other "SYSIBM dictionary
tables/views"

Jan Selchau-Hansen


"Talbot Katz" <TopKatz@MSN.COM> wrote in message
news:200210211852.g9LIqe012020@listserv.cc.uga.edu...
> Ahoy mates!
>
> I am using proc sql to query a permanent db2 database.  Is there a way to
> find out metadata type stuff, like the names of tables, their creation /
> update dates, number of columns, names and data types / formats of
columns,
> etc.?  I tried using the SAS dictionary.tables, but that came up empty.
As
> always, I appreciate any suggestions (even a friendly flame:-).  Thanks!
>
> --  TMK  --