View previous topic :: View next topic
|
Author |
Message |
harikiran.mc
New User
Joined: 18 Jan 2007 Posts: 17 Location: CHENNAI
|
|
|
|
Can anyone please give an update query for TIMESTAMP like this:
PLease suggest on this query/rectify?
Code: |
EXEC SQL
SET :WS-TS = CURRENT_TIMESTAMP
ENS-EXEC. |
|
|
Back to top |
|
|
harikiran.mc
New User
Joined: 18 Jan 2007 Posts: 17 Location: CHENNAI
|
|
|
|
Please tell whether this is correct?
harikiran.mc wrote: |
Can anyone please give an update query for TIMESTAMP like this:
PLease suggest on this query/rectify?
Code: |
EXEC SQL
SET :WS-TS = CURRENT_TIMESTAMP
ENS-EXEC. |
|
|
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Yes. And it is very easy to test it and find out. |
|
Back to top |
|
|
harikiran.mc
New User
Joined: 18 Jan 2007 Posts: 17 Location: CHENNAI
|
|
|
|
How can I test it?
Compile+Execute+DISPLAY statements? |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Yes. Write a cobol program, compile and run it. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
Can anyone please give an update query for TIMESTAMP like this:
|
you are not updating anything. You are populating a host-variable.
you can accomplish the same with a select from sysibm.sysdummy1 |
|
Back to top |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 Location: banglore
|
|
|
|
And correct it to END-EXEC |
|
Back to top |
|
|
|