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.  Override Database Output card Using -OD in RUN Function

    Posted 10/31/08 07:56 AM

    Originally posted by: karthikpc


    Hi,

    Can anyone suggest me how to use/write -OD cmd line for the below case?

    I have Main Map called MAIN and have secondary map called ZEN0. ZEN0 has total 1 input card(select data from Databade) and 4 outPut cards. Out of 4, 2nd and 4th output cards related to Database inserts.

    ZEN0 - Output card 1: Data1 with Sink
    ZEN0 - Output card 2: MDQ file - Database
    ZEN0 - Output card 3: Data2 with Sink
    ZEN0 - Output card 4: MDQ file - Database

    Now i have written rule in MAIN map like this:

    =IF(VALID(RUN("MAPLIB(" +BOS_Map_Name Fields:In1 +")","-ID1 '-PLAN " +Creator_ID Fields:In1 +" -SUBSYSTEM " +Sub_System Fields:In1 +" -VAR SUBSYSTEM="LEFT(Creator_ID Fields:In1,7)" -VAR COID="+Co_Id Fields:In1 +" -VAR DEPTID="+Dept_Id Fields:In1 + " -VAR BATCHNUMBER="+TRSM_Sub_Batch_Number Fields:In1 + " -VAR DBNAME="+Sub_System Fields:In1 + "-OD2 '-PLAN " +Creator_ID Fields:In1 +" -SUBSYSTEM " +Sub_System Fields:In1 +" -UPDATE OFF -TABLE "LEFT(Creator_ID Fields:In1,7)".CDE_CUST_OGNG_DATA -CCARD - T' " + "-OD4 '-PLAN " +Creator_ID Fields:In1 +" -SUBSYSTEM " +Sub_System Fields:In1 +" -UPDATE OFF -TABLE "LEFT(Creator_ID Fields:In1,7)".CDE_CUST_OGNG_DATA -CCARD - T' "), LASTERRORCODE()) = "3" , VALID(RUN(BOS_Map_Name Fields:In1,"-ID1 '-PLAN " +Creator_ID Fields:In1 +" -SUBSYSTEM " +Sub_System Fields:In1 +" -VAR SUBSYSTEM="LEFT(Creator_ID Fields:In1,7)" -VAR COID="+Co_Id Fields:In1 +" -VAR DEPTID="+Dept_Id Fields:In1 + " -VAR BATCHNUMBER="+TRSM_Sub_Batch_Number Fields:In1 + " -VAR DBNAME="+Sub_System Fields:In1 + "-OD2 '-PLAN " +Creator_ID Fields:In1 +" -SUBSYSTEM " +Sub_System Fields:In1 +" -UPDATE OFF -TABLE "LEFT(Creator_ID Fields:In1,7)".CDE_CUST_OGNG_DATA -CCARD -T' " + "-OD4 '-PLAN " +Creator_ID Fields:In1 +" -SUBSYSTEM " +Sub_System Fields:In1 +" -UPDATE OFF -TABLE "LEFT(Creator_ID Fields:In1,7)".CDE_CUST_OGNG_DATA -CCARD -T' " ), LASTERRORCODE()) , "Map Completed ok")
    While executing MAIN map, I am gettnig Execution error 61. Can anyone please let me know if the above SYNTAX is correct or not? If not correct, can you please let me know what is wrong in it?

    Thanks&Regards,
    P C
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Override Database Output card Using -OD in RUN Function

    Posted 10/31/08 09:23 AM

    Originally posted by: Kepa_Screen


    It seems that -PLAIN it's being interpreted as -P ( paging set up ).
    Try to put quotes around -PLAIN, may be the it is well interpreted as a user parameter instead of paging setup.

    ( look at execution error 61 --> Functions -> Execution error's )
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: Override Database Output card Using -OD in RUN Function

    Posted 10/31/08 09:24 AM

    Originally posted by: Kepa_Screen


    It seems that -PLAIN it's being interpreted as -P ( paging set up ).
    Try to put quotes around -PLAIN, may be the it is well interpreted as a user parameter instead of paging setup.

    ( look at execution error 61 --> Functions -> Execution error's )

    Hope can help
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


Related Content