TechTip: Simplify Your Development with DB2 Automatic Timestamp Support

[TheQuigs]

** This thread discusses the article: TechTip: Simplify Your Development with DB2 Automatic Timestamp Support **
** This thread discusses the Content article: TechTip: Simplify Your Development with DB2 Automatic Timestamp Support **

If a logical is used which eliminates the timestamp columns, is there still a performance penalty? i.e., Does the use of a logical still force the statement to be handled by the CQE rather than SQE?

[phil.seay2305]

** This thread discusses the article: TechTip: Simplify Your Development with DB2 Automatic Timestamp Support **
Hi Kent,
I created the example file using your DDL on both 6.1 and 7.1 systems and did not see the automatic updating to the ordLChg field when using DFU. I DID see this behavior when using an SQL update statement. Also, using DFU, I was able to change the ordLChg field to any time stamp value I wanted.

[K.Milligan]

** This thread discusses the article: TechTip: Simplify Your Development with DB2 Automatic Timestamp Support **
DFU allows the update of the OrdLChg field to occur, but on my systems DB2 always ignores the values passed on DFU and instead places the current timestamp value into the OrdLChg column.

If you're seeing a different behavior on your system, then you should make sure your system is current with the latest Database Group PTFs.

[K.Milligan]

** This thread discusses the article: TechTip: Simplify Your Development with DB2 Automatic Timestamp Support **
In my article, I was advocating the usage of logical files for the native, non-SQL interfaces - so there would be no performance penalty in that case.

With the 7.1 release, SQE now supports SQL Statements that reference a Logical file on the FROM clause. If you're not at 7.1 and are interested in the logical file approach for SQL interfaces, then just create an SQL view and then you will be ensured that SQE can be used instead of CQE because SQL View references on the FROM clause have been supported by SQE for a long time.

[RhondaT]

UserId?

** This thread discusses the article: TechTip: Simplify Your Development with DB2 Automatic Timestamp Support **
I was wondering if there is something similar for a userid? would like to auto-populate user as well as timestamp, for audit trail purposes....