IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only

  • 1.  truncate table with database adapter?

    Posted 01/29/07 11:27 AM

    Originally posted by: thorstenhirsch


    Hi,

    I want to put a large amount of data into a table (oracle database) without all the transaction stuff, because this takes too long. So actually I need to truncate my table before inserting data. Is this possible? I haven't found any option to truncate a table before inserting the data. "-UPDATE" takes too long.

    Thorsten
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: truncate table with database adapter?

    Posted 01/29/07 11:37 AM

    Originally posted by: janhess


    just use DBLOOKUP with the SQL for truncate.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


Related Content