View previous topic :: View next topic
|
Author |
Message |
vimalprabhakaran
New User
Joined: 13 Feb 2006 Posts: 13
|
|
|
|
Hi,
I need to update a timestamp field in DB2 table using SPUFI. Can any one help me out. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Hi vimalprabhakaran,
Did you try to update that field?or what kind of problem your are facing in that? |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Hi Vimalprabhakaran,
You can use UPDATE function, No problem in doing so in SPUFI, Please post your SQL and error. |
|
Back to top |
|
|
vimalprabhakaran
New User
Joined: 13 Feb 2006 Posts: 13
|
|
|
|
HI I need to get system time stamp. I am updating the timestamp using SPUFI only. How to get the SYSTEM TIMESTAMP IN SPUFI? |
|
Back to top |
|
|
vimalprabhakaran
New User
Joined: 13 Feb 2006 Posts: 13
|
|
|
|
Hi,
I want to update the timestamp field in a DB2 table. I need to get system time stamp. I am updating the timestamp using SPUFI only. How to get the SYSTEM TIMESTAMP IN SPUFI? |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Hi,
Please give this,
Code: |
UPDATE TABLE
SET FIELD = CURRENT TIMESTAMP;
WHERE <Condition> |
|
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
My Bad,
I have wrongly given Semicolon, excuse for my mistake.
Code: |
UPDATE TABLE
SET FIELD = CURRENT TIMESTAMP
WHERE <Condition> ; |
|
|
Back to top |
|
|
|