Jeannie,
Current_date, Current_timestamp, and Current_time are not part of any table,
they are SQL variables that can be derived as needed by referencing them in an
SQL statement. The STATUS table in TSM is useful as it only contains 1 record,
other tables will work, but may return many lines and process more slowly.
Bob.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jeannie Bruno
Sent: Tuesday, December 18, 2012 11:37 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] tsm scripts time of day
Thanks.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Sims, Richard B
Sent: Tuesday, December 18, 2012 12:04 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] tsm scripts time of day
Do SELECT * FROM SYSCAT.TABLES WHERE TABNAME='___'
on a given table name to see what columns it has.
(Table schema can change over time.)
Richard Sims
On Dec 18, 2012, at 11:32 AM, Jeannie Bruno <jbruno AT CENHUD DOT COM> wrote:
> Is there a 'current_day' column on the status table? just curious, it's
> giving me invalid column name, so I thought I had the wrong name.
>
> When I do select * from status, I don't even see column current_time. (I'm
> wearing my glasses too!)
This electronic transmission and any documents accompanying this electronic
transmission contain confidential information belonging to the sender. This
information may be legally privileged. The information is intended only for the
use of the individual or entity named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or the taking of any action in reliance on or regarding the contents of this
electronically transmitted information is strictly prohibited.
|