+ Reply to Thread
Results 1 to 5 of 5

Thread: TechTip: Simplify Your Development with DB2 Automatic Timestamp Support

  1. 12-31-1969 06:33 PM #1
    TheQuigs
    TheQuigs is offline Junior Member
    Join Date
    Apr 2012
    Posts
    27

    Default TechTip: Simplify Your Development with DB2 Automatic Timestamp Support

    ** 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?
    Reply With Quote Reply With Quote
  2. 12-31-1969 06:33 PM #2
    phil.seay2305 Guest

    Default

    ** 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.
    Reply With Quote Reply With Quote
  3. 12-31-1969 06:33 PM #3
    K.Milligan
    K.Milligan is offline Junior Member
    Join Date
    Dec 1969
    Posts
    11

    Default

    ** 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.
    Reply With Quote Reply With Quote
  4. 12-31-1969 06:33 PM #4
    K.Milligan
    K.Milligan is offline Junior Member
    Join Date
    Dec 1969
    Posts
    11

    Default

    ** 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.
    Reply With Quote Reply With Quote
  5. 12-31-1969 06:33 PM #5
    RhondaT
    RhondaT is offline Junior Member
    Join Date
    Feb 2012
    Location
    USA
    Posts
    1

    Question 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....
    Reply With Quote Reply With Quote
+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules