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

specifying column names using insert query to DB2 database

  • 1.  specifying column names using insert query to DB2 database

    Posted 01/12/10 12:53 PM

    Originally posted by: raksud


    Hi,

    Currently i have map where iam trying to insert data to DB2 using type tree, and overide setting to database from run map.

    this is the databse trace that is created

    <4200-4556>: The columns are of the following types:
    <4200-4556>: Column 1 (FILE_XMITSN_ID) type is DECIMAL, precision is 12.
    <4200-4556>: Column 2 (RCVD_TS) type is TIMESTAMP, precision is 26.
    <4200-4556>: Column 3 (CLM_CNT) type is DECIMAL, precision is 10.
    <4200-4556>: Column 4 (HSH_CD) type is CHAR, precision is 32.
    <4200-4556>: Column 5 (CLM_SRC_CD) type is CHAR, precision is 10.
    <4200-4556>: Column 6 (MOD_NM) type is CHAR, precision is 25.
    <4200-4556>: Column 7 (PROCG_BEG_TS) type is TIMESTAMP, precision is 26.
    <4200-4556>: Column 8 (PROCG_END_TS) type is TIMESTAMP, precision is 26.
    <4200-4556>: Column 9 (RTRN_CD) type is CHAR, precision is 4.
    <4200-4556>: Column 10 (ERR_MSG_TXT) type is VARCHAR, precision is 80.
    <4200-4556>: Column 11 (OTS_FILE_LOC) type is VARCHAR, precision is 256.
    <4200-4556>: Column 12 (INPUT_FILE_NM) type is VARCHAR, precision is 256.
    <4200-4556>: The insert statement to be executed is:
    <4200-4556>: INSERT INTO TBCDB05.FILE_CTL VALUES (?,?,?,?,?,?,?,?,?,?,?,?) ( column names are not specified during inserts)

    the complaint that i have from DBA guys is that whenever wtx does inserts to database , column names are not specified in the insert qeuery , which is against their database standards.

    iam looking for option where i can acheive this using typetrees for doing inserts and column names shd be specified during inserts

    ataching the map which iam using
    Appreciate , if somebody can give me any advise.

    Thanks for the support
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender