Hi

Try

SELECT REPLACE(CHAR(DATE(CURRENT TIMESTAMP),EUR),'.','/')
FROM SYSIBM.SYSDUMMY1

Or you can use the Current Date special register

SELECT REPLACE(CHAR(CURRENT DATE ,EUR),'.','/')
FROM SYSIBM.SYSDUMMY1

Isabel




"McClendon Rick "
<db2udbdba-ezmlmshield-x15760638.[Email address protected]
17-04-2005 16:03

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: traceing a DB2 Table







If someone reports a better way to track data changes, I'd sure like to
know...

We track column level updates through update triggers - The trigger
writes pertinent data to an audit table capturing the 'old' data value,
the timestamp of the change and the person who changed it.

Rick

-----Original Message-----
From: badri
[mailto:db2udbdba-ezmlmshield-x42490106.[Email address protected]
Sent: Sunday, April 17, 2005 4:28 AM
To: LazyDBA Discussion
Subject: traceing a DB2 Table









Hi experts,



We have a table in DB2 that gut changed for some fields noticed by the
user

who has access to it.

I want a way to trace the table to see who changed it OR any work
around.



This table updated from a cobol program. Three users were having access
to

this program. And we have restrected the access to it to one user two

months ago.



Thank you in advance.

Awaiting your fast response.

Disclaimer

* ---------------------------------------------------------------- *

This email and any files transmitted with it are confidential

and intended solely for the use of the individual or entity to

whom they are addressed. If you have received this email in error

please notify the sender. Please note that any views or opinions

presented in this email are solely those of the author and do not

necessarily represent those of King Faisal Specialist Hospital&

Research Centre (KFSH&RC). Finally, the recipient should check

this email and any attachments for the presence of viruses.

KFSH&RC accepts no liability for any damage caused by any virus

transmitted by this email.

*------------------------------------------------------------------ *

---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page