RE: SQL Timestamp

Alan,

if you're using *SYS notation, the file is sysibm/sysdummy1 .

HTH,


Peter Colpaert
Software Engineer, Consumer Luminaires

Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel. +32/ 3 450 74 09, Fax +32/ 3 450 74 33, Internal 1317
peter.colpaert@xxxxxxxxxxx, www.philips.com

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: woensdag 13 augustus 2008 14:53
To: Midrange Systems Technical Discussion
Subject: Re: SQL Timestamp

Hi Chuck
looks like I spoke too soon
I tried your suggestion
select current timestamp from sysibm.sysdummy1
and heres the response
Qualified object name SYSDUMMY1 not valid.
so I tried the following
select current timestamp from sysdummy1
and heres that response
SYSDUMMY1 in *LIBL type *FILE not found.



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxxxxx
P:(631) 244-2000 ext. 5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/12/2008 05:28:09 PM:

Alan Shore wrote:

<<SNIP>>
Within an STRSQL session, how do you display the current timestamp?

To see what the value of the timestamp that was current at the

start

of the execution of the statement, the following statement:

select current timestamp from sysibm.sysdummy1

Regards, Chuck
--

The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.