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@VM.MARIST.EDU] On Behalf Of Jeannie Bruno Sent: Tuesday, December 18, 2012 11:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] tsm scripts time of day Thanks. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Sims, Richard B Sent: Tuesday, December 18, 2012 12:04 PM To: ADSM-L@VM.MARIST.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 <jbr...@cenhud.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.
