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
with SYSIBM.SYSTABLES You can find all the other "SYSIBM dictionary
"Talbot Katz" <TopKatz@MSN.COM> wrote in message
> 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
> etc.? I tried using the SAS dictionary.tables, but that came up empty.
> always, I appreciate any suggestions (even a friendly flame:-). Thanks!
> -- TMK --