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.