IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
Back to discussions
Expand all | Collapse all

how do i can using DBMS reversed word in DBTABLE Statement?

  • 1.  how do i can using DBMS reversed word in DBTABLE Statement?

    Posted 02/22/06 03:10 AM

    Originally posted by: SystemAdmin


    IN DataStage TX 8.0, i want to insert DBMS timestamp in db table.

    At Database interface designer to use insert/update function. i Created MTT. in Map, How Can i using DBMS special reserved word(ex, current timstamp).
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: how do i can using DBMS reversed word in DBTABLE Stateme

    Posted 02/22/06 03:30 AM

    Originally posted by: SystemAdmin


    Not exactly sure what you are trying to do. If you have a tree created from DID with a date/time element, and you want to insert the correct current time when the map runs, use the CURRENTDATETIME function.

    See the Functions & Expressions reference guide for more info.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


Related Content