Transformer Compilation Error
Posted: Tue Jun 15, 2010 7:41 am
Hi,
Output from transformer compilation follows:
##I TFCN 000001 09:38:29(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 09:38:29(001) <main_program> The open files limit is 100; raising to 65536.
##I TOSH 000002 09:38:29(002) <main_program> orchgeneral: loaded
##I TOSH 000002 09:38:29(003) <main_program> orchsort: loaded
##I TOSH 000002 09:38:29(004) <main_program> orchstats: loaded
##I TFSC 000001 09:38:29(007) <main_program> APT configuration file: /app/ascential/Ascential/DataStage/Configurations/tss.apt
##I TFSC 000000 09:38:29(008) <main_program>
This step has no datasets.
It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##I TFPM 000201 09:38:30(000) <APT_CombinedOperatorController,0> APT_PMPlayer: new Player running, PID = 3444
##I TFOP 000094 09:38:30(001) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 09:38:30(002) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 09:38:30(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (backup11.xfm_validate)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_repos_xfm_validate transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 FileLink;
0007: outputname 0 DSLink4;
0008:
0009: global {
0010: // Job parameter declaration
0011: string PROCESS_DATE;
0012: }
0013:
0014: initialize {
0015: // define our row rejected variable
0016: int8 RowRejected0;
0017:
0018: // define our null set variable
0019: int8 NullSetVar0;
0020:
0021: // declare our intermediate variables for this section
0022: string InterVar0_0;
0023: string InterVar0_1;
0024: string InterVar0_2;
0025: string InterVar0_3;
0026: string InterVar0_4;
0027: string InterVar0_5;
0028: string InterVar0_6;
0029: string InterVar0_7;
0030: string InterVar0_8;
0031: string InterVar0_9;
0032: string InterVar0_10;
0033: string InterVar0_11;
0034: string InterVar0_12;
0035: string InterVar0_13;
0036: string InterVar0_14;
0037: string InterVar0_15;
0038: string InterVar0_16;
0039: string InterVar0_17;
0040: string InterVar0_18;
0041: string InterVar0_19;
0042: string InterVar0_20;
0043: string InterVar0_21;
0044: string InterVar0_22;
0045: string InterVar0_23;
0046: string InterVar0_24;
0047: uint16 InterVar0_25;
0048: string InterVar0_26;
0049: uint16 InterVar0_27;
0050: string InterVar0_28;
0051: string InterVar0_29;
0052: string InterVar0_30;
0053: string InterVar0_31;
0054: string InterVar0_32;
0055: string InterVar0_33;
0056: string InterVar0_34;
0057: string InterVar0_35;
0058: string InterVar0_36;
0059: string InterVar0_37;
0060: string InterVar0_38;
0061: string InterVar0_39;
0062: string InterVar0_40;
0063: string InterVar0_41;
0064: string InterVar0_43;
0065: string InterVar0_44;
0066: string InterVar0_45;
0067: string InterVar0_46;
0068: string InterVar0_47;
0069: string InterVar0_48;
0070: string InterVar0_49;
0071: string InterVar0_50;
0072:
0073: // initialise constant values which require conversion
0074: InterVar0_0 = "-";
0075: InterVar0_1 = "00:00:00";
0076: InterVar0_2 = 60;
0077: InterVar0_3 = 19;
0078: InterVar0_4 = 20;
0079: InterVar0_5 = "SEO";
0080: InterVar0_6 = "SET";
0081: InterVar0_7 = "SEF";
0082: InterVar0_8 = "SES";
0083: InterVar0_9 = "SEV";
0084: InterVar0_10 = "SEM";
0085: InterVar0_11 = "ORD";
0086: InterVar0_12 = "CXL";
0087: InterVar0_13 = "CXA";
0088: InterVar0_14 = "CXR";
0089: InterVar0_15 = "USD";
0090: InterVar0_16 = "I";
0091: InterVar0_17 = "P";
0092: InterVar0_18 = "A";
0093: InterVar0_19 = "B";
0094: InterVar0_20 = "S";
0095: InterVar0_21 = "SS";
0096: InterVar0_22 = "SX";
0097: InterVar0_23 = "Order Instruction Not Found";
0098: InterVar0_24 = "1";
0099: InterVar0_25 = "0";
0100: InterVar0_26 = "Y";
0101: InterVar0_27 = "1";
0102: InterVar0_28 = "N";
0103: InterVar0_29 = "ORR";
0104: InterVar0_30 = "";
0105: InterVar0_31 = "DAY";
0106: InterVar0_32 = "GTC";
0107: InterVar0_33 = "GTW";
0108: InterVar0_34 = "GTX";
0109: InterVar0_35 = "FOK";
0110: InterVar0_36 = "OPG";
0111: InterVar0_37 = "MKT";
0112: InterVar0_38 = "M";
0113: InterVar0_39 = "STP";
0114: InterVar0_40 = "LMT";
0115: InterVar0_41 = "L";
0116: InterVar0_43 = "2";
0117: InterVar0_44 = "4";
0118: InterVar0_45 = "6";
0119: InterVar0_46 = "AOMUS";
0120: InterVar0_47 = "260";
0121: InterVar0_48 = "261";
0122: InterVar0_49 = "263";
0123: InterVar0_50 = "America/New York";
0124: // Stage variable declaration and initialisation
0125: string StageVar0_vBusinessDateYYYY;
0126: StageVar0_vBusinessDateYYYY = "";
0127: string StageVar0_vBusDateYYYYMMDD;
0128: StageVar0_vBusDateYYYYMMDD = "";
0129: string StageVar0_vBusinessDateTime;
0130: StageVar0_vBusinessDateTime = "";
0131: string StageVar0_vOrderdate;
0132: StageVar0_vOrderdate = "";
0133: string StageVar0_vOrderdate1;
0134: StageVar0_vOrderdate1 = "";
0135: string StageVar0_vOrderdate2;
0136: StageVar0_vOrderdate2 = "";
0137: string StageVar0_vOrdertime1;
0138: StageVar0_vOrdertime1 = "";
0139: string StageVar0_vOrderdatetime;
0140: StageVar0_vOrderdatetime = "";
0141: string StageVar0_vRegIdentifier;
0142: StageVar0_vRegIdentifier = "";
0143: string StageVar0_vAcctIdentifier;
0144: StageVar0_vAcctIdentifier = "";
0145: }
0146:
0147: mainloop {
0148: // initialise our row rejected variable
0149: RowRejected0 = 1;
0150:
0151: // declare our intermediate variables for this section
0152: sfloat InterVar0_42;
0153:
0154: // evaluate the stage variables first
0155: StageVar0_vBusinessDateYYYY = substring_1(PROCESS_DATE , 1 , 4);
0156: StageVar0_vBusDateYYYYMMDD = ((StageVar0_vBusinessDateYYYY + substring_1(PROCESS_DATE , 7 , 2)) + substring_1(PROCESS_DATE , 5 , 2));
0157: StageVar0_vBusinessDateTime = ((((((substring_1(StageVar0_vBusDateYYYYMMDD , 1 , 4) + InterVar0_0) + substring_1(StageVar0_vBusDateYYYYMMDD , 5 , 2)) + InterVar0_0) + substring_1(StageVar0_vBusDateYYYYMMDD , 7 , 2)) + InterVar0_0) + InterVar0_1);
0158: if ((substring_1(FileLink.rowdata , 5 , 2) > InterVar0_2)) {
0159: StageVar0_vOrderdate = (InterVar0_3 + substring_1(FileLink.rowdata , 5 , 2));
0160: } else {
0161: StageVar0_vOrderdate = (InterVar0_4 + substring_1(FileLink.rowdata , 5 , 2));
0162: }
0163: //;
0164: StageVar0_vOrderdate1 = ((StageVar0_vOrderdate + substring_1(FileLink.rowdata , 7 , 2)) + substring_1(FileLink.rowdata , 9 , 2));
0165: StageVar0_vOrderdate2 = ((((substring_1(StageVar0_vOrderdate1 , 1 , 4) + InterVar0_0) + substring_1(StageVar0_vOrderdate1 , 5 , 2)) + InterVar0_0) + substring_1(StageVar0_vOrderdate , 7 , 2));
0166: StageVar0_vOrdertime1 = (substring_1(FileLink.rowdata , 11 , 2) + substring_1(FileLink.rowdata , 13 , 2));
0167: StageVar0_vOrderdatetime = (StageVar0_vOrderdate2 + StageVar0_vOrdertime1);
0168: StageVar0_vRegIdentifier = (substring_1(FileLink.rowdata , 45 , 3) + substring_1(FileLink.rowdata , 49 , 5));
0169: StageVar0_vAcctIdentifier = (substring_1(FileLink.rowdata , 45 , 3) + substring_1(FileLink.rowdata , 49 , 5));
0170:
0171: // evaluate columns (no constraints) for link: DSLink4
0172: DSLink4.OATS_ORDER_DATE = substring_1(FileLink.rowdata , 5 , 6);
0173: DSLink4.OATS_ORDER_TIME = substring_1(FileLink.rowdata , 11 , 4);
0174: DSLink4.OATS_ORDER_ISR_NBR = substring_1(FileLink.rowdata , 276 , 6);
0175: DSLink4.OATS_TRAN_TYPE = substring_1(FileLink.rowdata , 32 , 3);
0176: DSLink4.OATS_BRANCH_CD = substring_1(FileLink.rowdata , 45 , 3);
0177: DSLink4.OATS_ACCOUNT_CD = substring_1(FileLink.rowdata , 49 , 5);
0178: DSLink4.OATS_RR_CD = substring_1(FileLink.rowdata , 59 , 3);
0179: DSLink4.OATS_PRINCIPAL_CODE = substring_1(FileLink.rowdata , 94 , 1);
0180: DSLink4.OATS_T1_SYMBOL = substring_1(FileLink.rowdata , 108 , 25);
0181: DSLink4.OATS_T1_ORDER_INSTRUCTIONS = substring_1(FileLink.rowdata , 293 , 2);
0182: DSLink4.OATS_T1_ORDER_QUANTITY = substring_1(FileLink.rowdata , 139 , 10);
0183: DSLink4.OATS_T1_FIRST_PRICE = substring_1(FileLink.rowdata , 312 , 15);
0184: DSLink4.OATS_T1_GOOD_TILL_DATE = substring_1(FileLink.rowdata , 200 , 6);
0185: DSLink4.OATS_T1_ORDER_PRICE = substring_1(FileLink.rowdata , 159 , 7);
0186: DSLink4.OATS_T1_TIME_IN_FORCE = substring_1(FileLink.rowdata , 345 , 1);
0187: DSLink4.OATS_T1_INST_ORDER = substring_1(FileLink.rowdata , 208 , 1);
0188: DSLink4.Product_Key = substring_1(FileLink.rowdata , 108 , 25);
0189: DSLink4.Business_Date = timestamp_from_string(StageVar0_vBusinessDateTime);
0190: NullSetVar0 = 0;
0191: if (((((((substring_1(FileLink.rowdata , 32 , 3) == InterVar0_5) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_6)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_7)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_8)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_9)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_10))) {
0192: NullSetVar0 = 1;
0193: } else {
0194: if (((((substring_1(FileLink.rowdata , 32 , 3) == InterVar0_11) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_12)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_13)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_14))) {
0195: DSLink4.Order_Close_Expire_Date_Time = timestamp_from_string(StageVar0_vBusinessDateTime);
0196: } else {
0197: NullSetVar0 = 1;
0198: }
0199: //;
0200: }
0201: DSLink4.Order_Close_Expire_Date_Time = (NullSetVar0 == 1) ? set_null() : DSLink4.Order_Close_Expire_Date_Time;
0202: DSLink4.Order_Date_Time = timestamp_from_string(StageVar0_vOrderdatetime);
0203: DSLink4.Order_Entry_Date_Time = timestamp_from_string(StageVar0_vOrderdatetime);
0204: DSLink4.Original_Currency_Cd = InterVar0_15;
0205: NullSetVar0 = 0;
0206: if (notnull(substring_1(FileLink.rowdata , 94 , 1))) {
0207: if ((trimc_string(substring_1(FileLink.rowdata , 94 , 1)) == InterVar0_16)) {
0208: DSLink4.Capacity_Cd1 = InterVar0_17;
0209: } else {
0210: if ((trimc_string(substring_1(FileLink.rowdata , 94 , 1)) == InterVar0_18)) {
0211: DSLink4.Capacity_Cd1 = InterVar0_18;
0212: } else {
0213: if ((trimc_string(substring_1(FileLink.rowdata , 94 , 1)) == InterVar0_17)) {
0214: DSLink4.Capacity_Cd1 = InterVar0_17;
0215: } else {
0216: NullSetVar0 = 1;
0217: }
0218: //;
0219: }
0220: //;
0221: }
0222: //;
0223: } else {
0224: NullSetVar0 = 1;
0225: }
0226: DSLink4.Capacity_Cd1 = (NullSetVar0 == 1) ? set_null() : DSLink4.Capacity_Cd1;
0227: DSLink4.Channel_Cd = set_null();
0228: DSLink4.Desk = set_null();
0229: NullSetVar0 = 0;
0230: if ((null(substring_1(FileLink.rowdata , 137 , 2)) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0231: NullSetVar0 = 1;
0232: } else {
0233: if (((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_19) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0234: DSLink4.Direction_Cd = InterVar0_19;
0235: } else {
0236: if (((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_20) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0237: DSLink4.Direction_Cd = InterVar0_20;
0238: } else {
0239: if (((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_21) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0240: DSLink4.Direction_Cd = InterVar0_20;
0241: } else {
0242: if (((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_22) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0243: DSLink4.Direction_Cd = InterVar0_20;
0244: } else {
0245: DSLink4.Direction_Cd = InterVar0_23;
0246: }
0247: //;
0248: }
0249: //;
0250: }
0251: //;
0252: }
0253: //;
0254: }
0255: DSLink4.Direction_Cd = (NullSetVar0 == 1) ? set_null() : DSLink4.Direction_Cd;
0256: DSLink4.Is_Continuous = InterVar0_24;
0257: DSLink4.is_DMA = InterVar0_25;
0258: NullSetVar0 = 0;
0259: if ((trimc_string(substring_1(FileLink.rowdata , 208 , 1)) == InterVar0_26)) {
0260: DSLink4.is_Held = InterVar0_27;
0261: } else {
0262: if ((trimc_string(substring_1(FileLink.rowdata , 208 , 1)) == InterVar0_28)) {
0263: DSLink4.is_Held = InterVar0_25;
0264: } else {
0265: NullSetVar0 = 1;
0266: }
0267: //;
0268: }
0269: DSLink4.is_Held = (NullSetVar0 == 1) ? set_null() : DSLink4.is_Held;
0270: DSLink4.Is_Side_By_Side = set_null();
0271: DSLink4.Is_Venue_Override = set_null();
0272: DSLink4.Leaves_Quantity = trimc_string(substring_1(FileLink.rowdata , 139 , 10));
0273: DSLink4.Order_Id = (trimc_string(substring_1(FileLink.rowdata , 5 , 6)) + trimc_string(substring_1(FileLink.rowdata , 15 , 6)));
0274: DSLink4.Order_Quantity = decimal_from_string(substring_1(FileLink.rowdata , 139 , 10));
0275: NullSetVar0 = 0;
0276: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10))) {
0277: NullSetVar0 = 1;
0278: } else {
0279: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_30))) {
0280: NullSetVar0 = 1;
0281: } else {
0282: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_31))) {
0283: DSLink4.Order_Term_Cd = InterVar0_31;
0284: } else {
0285: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_32))) {
0286: DSLink4.Order_Term_Cd = InterVar0_32;
0287: } else {
0288: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_33))) {
0289: DSLink4.Order_Term_Cd = InterVar0_33;
0290: } else {
0291: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_34))) {
0292: DSLink4.Order_Term_Cd = InterVar0_34;
0293: } else {
0294: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_35))) {
0295: DSLink4.Order_Term_Cd = InterVar0_35;
0296: } else {
0297: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_36))) {
0298: DSLink4.Order_Term_Cd = InterVar0_36;
0299: } else {
0300: DSLink4.Order_Term_Cd = InterVar0_32;
0301: }
0302: //;
0303: }
0304: //;
0305: }
0306: //;
0307: }
0308: //;
0309: }
0310: //;
0311: }
0312: //;
0313: }
0314: //;
0315: }
0316: DSLink4.Order_Term_Cd = (NullSetVar0 == 1) ? set_null() : DSLink4.Order_Term_Cd;
0317: NullSetVar0 = 0;
0318: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_30))) {
0319: NullSetVar0 = 1;
0320: } else {
0321: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_37))) {
0322: DSLink4.Order_Type_Cd = InterVar0_38;
0323: } else {
0324: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_39))) {
0325: DSLink4.Order_Type_Cd = InterVar0_20;
0326: } else {
0327: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_40))) {
0328: DSLink4.Order_Type_Cd = InterVar0_41;
0329: } else {
0330: if ((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_37))) {
0331: DSLink4.Order_Type_Cd = InterVar0_38;
0332: } else {
0333: DSLink4.Order_Type_Cd = InterVar0_38;
0334: }
0335: //;
0336: }
0337: //;
0338: }
0339: //;
0340: }
0341: //;
0342: }
0343: DSLink4.Order_Type_Cd = (NullSetVar0 == 1) ? set_null() : DSLink4.Order_Type_Cd;
0344: DSLink4.Order_Version = set_null();
0345: NullSetVar0 = 0;
0346: if (((trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_30) && ((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)))) {
0347: InterVar0_42 = decimal_from_string(trimc_string(substring_1(FileLink.rowdata , 166 , 15)));
0348: DSLink4.Orig_Curr_Limit_Price = InterVar0_42;
0349: } else {
0350: NullSetVar0 = 1;
0351: }
0352: DSLink4.Orig_Curr_Limit_Price = (NullSetVar0 == 1) ? set_null() : DSLink4.Orig_Curr_Limit_Price;
0353: NullSetVar0 = 0;
0354: if (((trimc_string(substring_1(FileLink.rowdata , 159 , 7)) != InterVar0_37) && ((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)))) {
0355: InterVar0_42 = decimal_from_string(trimc_string(substring_1(FileLink.rowdata , 166 , 15))) * decimal_from_string(trimc_string(substring_1(FileLink.rowdata , 139 , 10)));
0356: DSLink4.Orig_Curr_Order_Principal_Amt = InterVar0_42;
0357: } else {
0358: NullSetVar0 = 1;
0359: }
0360: DSLink4.Orig_Curr_Order_Principal_Amt = (NullSetVar0 == 1) ? set_null() : DSLink4.Orig_Curr_Order_Principal_Amt;
0361: NullSetVar0 = 0;
0362: if ((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_30)) {
0363: NullSetVar0 = 1;
0364: } else {
0365: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9))) {
0366: DSLink4.Record_Type_Cd1 = InterVar0_43;
0367: } else {
0368: if (((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14))) {
0369: DSLink4.Record_Type_Cd1 = InterVar0_44;
0370: } else {
0371: if ((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) {
0372: DSLink4.Record_Type_Cd1 = InterVar0_45;
0373: } else {
0374: NullSetVar0 = 1;
0375: }
0376: //;
0377: }
0378: //;
0379: }
0380: //;
0381: }
0382: DSLink4.Record_Type_Cd1 = (NullSetVar0 == 1) ? set_null() : DSLink4.Record_Type_Cd1;
0383: DSLink4.Source_System_Cd = InterVar0_46;
0384: DSLink4.Trading_Service_Cd = set_null();
0385: NullSetVar0 = 0;
0386: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_30)) {
0387: NullSetVar0 = 1;
0388: } else {
0389: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_19)) {
0390: DSLink4.Trans_Type_Cd1 = InterVar0_47;
0391: } else {
0392: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_20)) {
0393: DSLink4.Trans_Type_Cd1 = InterVar0_48;
0394: } else {
0395: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_21)) {
0396: DSLink4.Trans_Type_Cd1 = InterVar0_49;
0397: } else {
0398: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_22)) {
0399: DSLink4.Trans_Type_Cd1 = InterVar0_49;
0400: } else {
0401: NullSetVar0 = 1;
0402: }
0403: //;
0404: }
0405: //;
0406: }
0407: //;
0408: }
0409: //;
0410: }
0411: DSLink4.Trans_Type_Cd1 = (NullSetVar0 == 1) ? set_null() : DSLink4.Trans_Type_Cd1;
0412: NullSetVar0 = 0;
0413: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10))) {
0414: NullSetVar0 = 1;
0415: } else {
0416: if (((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14))) {
0417: DSLink4.rb_OrderCloseExpireDateTimeOriginal = timestamp_from_string(StageVar0_vBusinessDateTime);
0418: } else {
0419: NullSetVar0 = 1;
0420: }
0421: //;
0422: }
0423: DSLink4.rb_OrderCloseExpireDateTimeOriginal = (NullSetVar0 == 1) ? set_null() : DSLink4.rb_OrderCloseExpireDateTimeOriginal;
0424: NullSetVar0 = 0;
0425: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10))) {
0426: NullSetVar0 = 1;
0427: } else {
0428: if (((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14))) {
0429: DSLink4.rb_OrderCloseExpireDateTimeGlobal = timestamp_from_string(StageVar0_vBusinessDateTime);
0430: } else {
0431: NullSetVar0 = 1;
0432: }
0433: //;
0434: }
0435: DSLink4.rb_OrderCloseExpireDateTimeGlobal = (NullSetVar0 == 1) ? set_null() : DSLink4.rb_OrderCloseExpireDateTimeGlobal;
0436: DSLink4.rb_OrderDateTimeOriginal = timestamp_from_string(StageVar0_vOrderdatetime);
0437: DSLink4.rb_OrderDateTimeGlobal = timestamp_from_string(StageVar0_vOrderdatetime);
0438: DSLink4.rb_OrderEntryDateTimeOriginal = timestamp_from_string(StageVar0_vOrderdatetime);
0439: DSLink4.rb_OrderEntryDateTimeGlobal = timestamp_from_string(StageVar0_vOrderdatetime);
0440: DSLink4.rb_TimeZoneOriginal = InterVar0_50;
0441: NullSetVar0 = 0;
0442: if (((trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_30) && ((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)))) {
0443: InterVar0_42 = decimal_from_string(substring_1(FileLink.rowdata , 166 , 15));
0444: DSLink4.Base_Curr_Limit_Price = InterVar0_42;
0445: } else {
0446: NullSetVar0 = 1;
0447: }
0448: DSLink4.Base_Curr_Limit_Price = (NullSetVar0 == 1) ? set_null() : DSLink4.Base_Curr_Limit_Price;
0449: NullSetVar0 = 0;
0450: if (((trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_39) && ((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)))) {
0451: InterVar0_42 = decimal_from_string(substring_1(FileLink.rowdata , 166 , 15));
0452: DSLink4.Base_Curr_Stop_Price = InterVar0_42;
0453: } else {
0454: NullSetVar0 = 1;
0455: }
0456: DSLink4.Base_Curr_Stop_Price = (NullSetVar0 == 1) ? set_null() : DSLink4.Base_Curr_Stop_Price;
0457: DSLink4.Order_Key = (((trimc_string(substring_1(FileLink.rowdata , 5 , 6)) + trimc_string(substring_1(FileLink.rowdata , 15 , 6))) + InterVar0_30) + InterVar0_46);
0458: DSLink4.RegIdentifier = substring_1(StageVar0_vRegIdentifier , 1 ,
;
0459: DSLink4.Agg_Unit_Cd = set_null();
0460: DSLink4.BAse_Currency_Cd = InterVar0_15;
0461: writerecord 0;
0462: RowRejected0 = 0;
0463: }
0464:
0465: finish {
0466: }
0467:
*** End of Internal Generated Transformer Code
while compiling the job am getting the compilation error:
Parameter specified but not used in flow: DSPXWorkingDir (backup11.xfm_validate)
Pl give the solution ,
Thanks,
Output from transformer compilation follows:
##I TFCN 000001 09:38:29(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 09:38:29(001) <main_program> The open files limit is 100; raising to 65536.
##I TOSH 000002 09:38:29(002) <main_program> orchgeneral: loaded
##I TOSH 000002 09:38:29(003) <main_program> orchsort: loaded
##I TOSH 000002 09:38:29(004) <main_program> orchstats: loaded
##I TFSC 000001 09:38:29(007) <main_program> APT configuration file: /app/ascential/Ascential/DataStage/Configurations/tss.apt
##I TFSC 000000 09:38:29(008) <main_program>
This step has no datasets.
It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##I TFPM 000201 09:38:30(000) <APT_CombinedOperatorController,0> APT_PMPlayer: new Player running, PID = 3444
##I TFOP 000094 09:38:30(001) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 09:38:30(002) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 09:38:30(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (backup11.xfm_validate)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_repos_xfm_validate transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 FileLink;
0007: outputname 0 DSLink4;
0008:
0009: global {
0010: // Job parameter declaration
0011: string PROCESS_DATE;
0012: }
0013:
0014: initialize {
0015: // define our row rejected variable
0016: int8 RowRejected0;
0017:
0018: // define our null set variable
0019: int8 NullSetVar0;
0020:
0021: // declare our intermediate variables for this section
0022: string InterVar0_0;
0023: string InterVar0_1;
0024: string InterVar0_2;
0025: string InterVar0_3;
0026: string InterVar0_4;
0027: string InterVar0_5;
0028: string InterVar0_6;
0029: string InterVar0_7;
0030: string InterVar0_8;
0031: string InterVar0_9;
0032: string InterVar0_10;
0033: string InterVar0_11;
0034: string InterVar0_12;
0035: string InterVar0_13;
0036: string InterVar0_14;
0037: string InterVar0_15;
0038: string InterVar0_16;
0039: string InterVar0_17;
0040: string InterVar0_18;
0041: string InterVar0_19;
0042: string InterVar0_20;
0043: string InterVar0_21;
0044: string InterVar0_22;
0045: string InterVar0_23;
0046: string InterVar0_24;
0047: uint16 InterVar0_25;
0048: string InterVar0_26;
0049: uint16 InterVar0_27;
0050: string InterVar0_28;
0051: string InterVar0_29;
0052: string InterVar0_30;
0053: string InterVar0_31;
0054: string InterVar0_32;
0055: string InterVar0_33;
0056: string InterVar0_34;
0057: string InterVar0_35;
0058: string InterVar0_36;
0059: string InterVar0_37;
0060: string InterVar0_38;
0061: string InterVar0_39;
0062: string InterVar0_40;
0063: string InterVar0_41;
0064: string InterVar0_43;
0065: string InterVar0_44;
0066: string InterVar0_45;
0067: string InterVar0_46;
0068: string InterVar0_47;
0069: string InterVar0_48;
0070: string InterVar0_49;
0071: string InterVar0_50;
0072:
0073: // initialise constant values which require conversion
0074: InterVar0_0 = "-";
0075: InterVar0_1 = "00:00:00";
0076: InterVar0_2 = 60;
0077: InterVar0_3 = 19;
0078: InterVar0_4 = 20;
0079: InterVar0_5 = "SEO";
0080: InterVar0_6 = "SET";
0081: InterVar0_7 = "SEF";
0082: InterVar0_8 = "SES";
0083: InterVar0_9 = "SEV";
0084: InterVar0_10 = "SEM";
0085: InterVar0_11 = "ORD";
0086: InterVar0_12 = "CXL";
0087: InterVar0_13 = "CXA";
0088: InterVar0_14 = "CXR";
0089: InterVar0_15 = "USD";
0090: InterVar0_16 = "I";
0091: InterVar0_17 = "P";
0092: InterVar0_18 = "A";
0093: InterVar0_19 = "B";
0094: InterVar0_20 = "S";
0095: InterVar0_21 = "SS";
0096: InterVar0_22 = "SX";
0097: InterVar0_23 = "Order Instruction Not Found";
0098: InterVar0_24 = "1";
0099: InterVar0_25 = "0";
0100: InterVar0_26 = "Y";
0101: InterVar0_27 = "1";
0102: InterVar0_28 = "N";
0103: InterVar0_29 = "ORR";
0104: InterVar0_30 = "";
0105: InterVar0_31 = "DAY";
0106: InterVar0_32 = "GTC";
0107: InterVar0_33 = "GTW";
0108: InterVar0_34 = "GTX";
0109: InterVar0_35 = "FOK";
0110: InterVar0_36 = "OPG";
0111: InterVar0_37 = "MKT";
0112: InterVar0_38 = "M";
0113: InterVar0_39 = "STP";
0114: InterVar0_40 = "LMT";
0115: InterVar0_41 = "L";
0116: InterVar0_43 = "2";
0117: InterVar0_44 = "4";
0118: InterVar0_45 = "6";
0119: InterVar0_46 = "AOMUS";
0120: InterVar0_47 = "260";
0121: InterVar0_48 = "261";
0122: InterVar0_49 = "263";
0123: InterVar0_50 = "America/New York";
0124: // Stage variable declaration and initialisation
0125: string StageVar0_vBusinessDateYYYY;
0126: StageVar0_vBusinessDateYYYY = "";
0127: string StageVar0_vBusDateYYYYMMDD;
0128: StageVar0_vBusDateYYYYMMDD = "";
0129: string StageVar0_vBusinessDateTime;
0130: StageVar0_vBusinessDateTime = "";
0131: string StageVar0_vOrderdate;
0132: StageVar0_vOrderdate = "";
0133: string StageVar0_vOrderdate1;
0134: StageVar0_vOrderdate1 = "";
0135: string StageVar0_vOrderdate2;
0136: StageVar0_vOrderdate2 = "";
0137: string StageVar0_vOrdertime1;
0138: StageVar0_vOrdertime1 = "";
0139: string StageVar0_vOrderdatetime;
0140: StageVar0_vOrderdatetime = "";
0141: string StageVar0_vRegIdentifier;
0142: StageVar0_vRegIdentifier = "";
0143: string StageVar0_vAcctIdentifier;
0144: StageVar0_vAcctIdentifier = "";
0145: }
0146:
0147: mainloop {
0148: // initialise our row rejected variable
0149: RowRejected0 = 1;
0150:
0151: // declare our intermediate variables for this section
0152: sfloat InterVar0_42;
0153:
0154: // evaluate the stage variables first
0155: StageVar0_vBusinessDateYYYY = substring_1(PROCESS_DATE , 1 , 4);
0156: StageVar0_vBusDateYYYYMMDD = ((StageVar0_vBusinessDateYYYY + substring_1(PROCESS_DATE , 7 , 2)) + substring_1(PROCESS_DATE , 5 , 2));
0157: StageVar0_vBusinessDateTime = ((((((substring_1(StageVar0_vBusDateYYYYMMDD , 1 , 4) + InterVar0_0) + substring_1(StageVar0_vBusDateYYYYMMDD , 5 , 2)) + InterVar0_0) + substring_1(StageVar0_vBusDateYYYYMMDD , 7 , 2)) + InterVar0_0) + InterVar0_1);
0158: if ((substring_1(FileLink.rowdata , 5 , 2) > InterVar0_2)) {
0159: StageVar0_vOrderdate = (InterVar0_3 + substring_1(FileLink.rowdata , 5 , 2));
0160: } else {
0161: StageVar0_vOrderdate = (InterVar0_4 + substring_1(FileLink.rowdata , 5 , 2));
0162: }
0163: //;
0164: StageVar0_vOrderdate1 = ((StageVar0_vOrderdate + substring_1(FileLink.rowdata , 7 , 2)) + substring_1(FileLink.rowdata , 9 , 2));
0165: StageVar0_vOrderdate2 = ((((substring_1(StageVar0_vOrderdate1 , 1 , 4) + InterVar0_0) + substring_1(StageVar0_vOrderdate1 , 5 , 2)) + InterVar0_0) + substring_1(StageVar0_vOrderdate , 7 , 2));
0166: StageVar0_vOrdertime1 = (substring_1(FileLink.rowdata , 11 , 2) + substring_1(FileLink.rowdata , 13 , 2));
0167: StageVar0_vOrderdatetime = (StageVar0_vOrderdate2 + StageVar0_vOrdertime1);
0168: StageVar0_vRegIdentifier = (substring_1(FileLink.rowdata , 45 , 3) + substring_1(FileLink.rowdata , 49 , 5));
0169: StageVar0_vAcctIdentifier = (substring_1(FileLink.rowdata , 45 , 3) + substring_1(FileLink.rowdata , 49 , 5));
0170:
0171: // evaluate columns (no constraints) for link: DSLink4
0172: DSLink4.OATS_ORDER_DATE = substring_1(FileLink.rowdata , 5 , 6);
0173: DSLink4.OATS_ORDER_TIME = substring_1(FileLink.rowdata , 11 , 4);
0174: DSLink4.OATS_ORDER_ISR_NBR = substring_1(FileLink.rowdata , 276 , 6);
0175: DSLink4.OATS_TRAN_TYPE = substring_1(FileLink.rowdata , 32 , 3);
0176: DSLink4.OATS_BRANCH_CD = substring_1(FileLink.rowdata , 45 , 3);
0177: DSLink4.OATS_ACCOUNT_CD = substring_1(FileLink.rowdata , 49 , 5);
0178: DSLink4.OATS_RR_CD = substring_1(FileLink.rowdata , 59 , 3);
0179: DSLink4.OATS_PRINCIPAL_CODE = substring_1(FileLink.rowdata , 94 , 1);
0180: DSLink4.OATS_T1_SYMBOL = substring_1(FileLink.rowdata , 108 , 25);
0181: DSLink4.OATS_T1_ORDER_INSTRUCTIONS = substring_1(FileLink.rowdata , 293 , 2);
0182: DSLink4.OATS_T1_ORDER_QUANTITY = substring_1(FileLink.rowdata , 139 , 10);
0183: DSLink4.OATS_T1_FIRST_PRICE = substring_1(FileLink.rowdata , 312 , 15);
0184: DSLink4.OATS_T1_GOOD_TILL_DATE = substring_1(FileLink.rowdata , 200 , 6);
0185: DSLink4.OATS_T1_ORDER_PRICE = substring_1(FileLink.rowdata , 159 , 7);
0186: DSLink4.OATS_T1_TIME_IN_FORCE = substring_1(FileLink.rowdata , 345 , 1);
0187: DSLink4.OATS_T1_INST_ORDER = substring_1(FileLink.rowdata , 208 , 1);
0188: DSLink4.Product_Key = substring_1(FileLink.rowdata , 108 , 25);
0189: DSLink4.Business_Date = timestamp_from_string(StageVar0_vBusinessDateTime);
0190: NullSetVar0 = 0;
0191: if (((((((substring_1(FileLink.rowdata , 32 , 3) == InterVar0_5) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_6)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_7)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_8)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_9)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_10))) {
0192: NullSetVar0 = 1;
0193: } else {
0194: if (((((substring_1(FileLink.rowdata , 32 , 3) == InterVar0_11) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_12)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_13)) || (substring_1(FileLink.rowdata , 32 , 3) == InterVar0_14))) {
0195: DSLink4.Order_Close_Expire_Date_Time = timestamp_from_string(StageVar0_vBusinessDateTime);
0196: } else {
0197: NullSetVar0 = 1;
0198: }
0199: //;
0200: }
0201: DSLink4.Order_Close_Expire_Date_Time = (NullSetVar0 == 1) ? set_null() : DSLink4.Order_Close_Expire_Date_Time;
0202: DSLink4.Order_Date_Time = timestamp_from_string(StageVar0_vOrderdatetime);
0203: DSLink4.Order_Entry_Date_Time = timestamp_from_string(StageVar0_vOrderdatetime);
0204: DSLink4.Original_Currency_Cd = InterVar0_15;
0205: NullSetVar0 = 0;
0206: if (notnull(substring_1(FileLink.rowdata , 94 , 1))) {
0207: if ((trimc_string(substring_1(FileLink.rowdata , 94 , 1)) == InterVar0_16)) {
0208: DSLink4.Capacity_Cd1 = InterVar0_17;
0209: } else {
0210: if ((trimc_string(substring_1(FileLink.rowdata , 94 , 1)) == InterVar0_18)) {
0211: DSLink4.Capacity_Cd1 = InterVar0_18;
0212: } else {
0213: if ((trimc_string(substring_1(FileLink.rowdata , 94 , 1)) == InterVar0_17)) {
0214: DSLink4.Capacity_Cd1 = InterVar0_17;
0215: } else {
0216: NullSetVar0 = 1;
0217: }
0218: //;
0219: }
0220: //;
0221: }
0222: //;
0223: } else {
0224: NullSetVar0 = 1;
0225: }
0226: DSLink4.Capacity_Cd1 = (NullSetVar0 == 1) ? set_null() : DSLink4.Capacity_Cd1;
0227: DSLink4.Channel_Cd = set_null();
0228: DSLink4.Desk = set_null();
0229: NullSetVar0 = 0;
0230: if ((null(substring_1(FileLink.rowdata , 137 , 2)) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0231: NullSetVar0 = 1;
0232: } else {
0233: if (((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_19) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0234: DSLink4.Direction_Cd = InterVar0_19;
0235: } else {
0236: if (((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_20) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0237: DSLink4.Direction_Cd = InterVar0_20;
0238: } else {
0239: if (((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_21) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0240: DSLink4.Direction_Cd = InterVar0_20;
0241: } else {
0242: if (((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_22) && ((((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)))) {
0243: DSLink4.Direction_Cd = InterVar0_20;
0244: } else {
0245: DSLink4.Direction_Cd = InterVar0_23;
0246: }
0247: //;
0248: }
0249: //;
0250: }
0251: //;
0252: }
0253: //;
0254: }
0255: DSLink4.Direction_Cd = (NullSetVar0 == 1) ? set_null() : DSLink4.Direction_Cd;
0256: DSLink4.Is_Continuous = InterVar0_24;
0257: DSLink4.is_DMA = InterVar0_25;
0258: NullSetVar0 = 0;
0259: if ((trimc_string(substring_1(FileLink.rowdata , 208 , 1)) == InterVar0_26)) {
0260: DSLink4.is_Held = InterVar0_27;
0261: } else {
0262: if ((trimc_string(substring_1(FileLink.rowdata , 208 , 1)) == InterVar0_28)) {
0263: DSLink4.is_Held = InterVar0_25;
0264: } else {
0265: NullSetVar0 = 1;
0266: }
0267: //;
0268: }
0269: DSLink4.is_Held = (NullSetVar0 == 1) ? set_null() : DSLink4.is_Held;
0270: DSLink4.Is_Side_By_Side = set_null();
0271: DSLink4.Is_Venue_Override = set_null();
0272: DSLink4.Leaves_Quantity = trimc_string(substring_1(FileLink.rowdata , 139 , 10));
0273: DSLink4.Order_Id = (trimc_string(substring_1(FileLink.rowdata , 5 , 6)) + trimc_string(substring_1(FileLink.rowdata , 15 , 6)));
0274: DSLink4.Order_Quantity = decimal_from_string(substring_1(FileLink.rowdata , 139 , 10));
0275: NullSetVar0 = 0;
0276: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10))) {
0277: NullSetVar0 = 1;
0278: } else {
0279: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_30))) {
0280: NullSetVar0 = 1;
0281: } else {
0282: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_31))) {
0283: DSLink4.Order_Term_Cd = InterVar0_31;
0284: } else {
0285: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_32))) {
0286: DSLink4.Order_Term_Cd = InterVar0_32;
0287: } else {
0288: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_33))) {
0289: DSLink4.Order_Term_Cd = InterVar0_33;
0290: } else {
0291: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_34))) {
0292: DSLink4.Order_Term_Cd = InterVar0_34;
0293: } else {
0294: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_35))) {
0295: DSLink4.Order_Term_Cd = InterVar0_35;
0296: } else {
0297: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 197 , 3)) == InterVar0_36))) {
0298: DSLink4.Order_Term_Cd = InterVar0_36;
0299: } else {
0300: DSLink4.Order_Term_Cd = InterVar0_32;
0301: }
0302: //;
0303: }
0304: //;
0305: }
0306: //;
0307: }
0308: //;
0309: }
0310: //;
0311: }
0312: //;
0313: }
0314: //;
0315: }
0316: DSLink4.Order_Term_Cd = (NullSetVar0 == 1) ? set_null() : DSLink4.Order_Term_Cd;
0317: NullSetVar0 = 0;
0318: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_30))) {
0319: NullSetVar0 = 1;
0320: } else {
0321: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_37))) {
0322: DSLink4.Order_Type_Cd = InterVar0_38;
0323: } else {
0324: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_39))) {
0325: DSLink4.Order_Type_Cd = InterVar0_20;
0326: } else {
0327: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_29)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_40))) {
0328: DSLink4.Order_Type_Cd = InterVar0_41;
0329: } else {
0330: if ((((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10)) && (trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_37))) {
0331: DSLink4.Order_Type_Cd = InterVar0_38;
0332: } else {
0333: DSLink4.Order_Type_Cd = InterVar0_38;
0334: }
0335: //;
0336: }
0337: //;
0338: }
0339: //;
0340: }
0341: //;
0342: }
0343: DSLink4.Order_Type_Cd = (NullSetVar0 == 1) ? set_null() : DSLink4.Order_Type_Cd;
0344: DSLink4.Order_Version = set_null();
0345: NullSetVar0 = 0;
0346: if (((trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_30) && ((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)))) {
0347: InterVar0_42 = decimal_from_string(trimc_string(substring_1(FileLink.rowdata , 166 , 15)));
0348: DSLink4.Orig_Curr_Limit_Price = InterVar0_42;
0349: } else {
0350: NullSetVar0 = 1;
0351: }
0352: DSLink4.Orig_Curr_Limit_Price = (NullSetVar0 == 1) ? set_null() : DSLink4.Orig_Curr_Limit_Price;
0353: NullSetVar0 = 0;
0354: if (((trimc_string(substring_1(FileLink.rowdata , 159 , 7)) != InterVar0_37) && ((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)))) {
0355: InterVar0_42 = decimal_from_string(trimc_string(substring_1(FileLink.rowdata , 166 , 15))) * decimal_from_string(trimc_string(substring_1(FileLink.rowdata , 139 , 10)));
0356: DSLink4.Orig_Curr_Order_Principal_Amt = InterVar0_42;
0357: } else {
0358: NullSetVar0 = 1;
0359: }
0360: DSLink4.Orig_Curr_Order_Principal_Amt = (NullSetVar0 == 1) ? set_null() : DSLink4.Orig_Curr_Order_Principal_Amt;
0361: NullSetVar0 = 0;
0362: if ((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_30)) {
0363: NullSetVar0 = 1;
0364: } else {
0365: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9))) {
0366: DSLink4.Record_Type_Cd1 = InterVar0_43;
0367: } else {
0368: if (((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14))) {
0369: DSLink4.Record_Type_Cd1 = InterVar0_44;
0370: } else {
0371: if ((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) {
0372: DSLink4.Record_Type_Cd1 = InterVar0_45;
0373: } else {
0374: NullSetVar0 = 1;
0375: }
0376: //;
0377: }
0378: //;
0379: }
0380: //;
0381: }
0382: DSLink4.Record_Type_Cd1 = (NullSetVar0 == 1) ? set_null() : DSLink4.Record_Type_Cd1;
0383: DSLink4.Source_System_Cd = InterVar0_46;
0384: DSLink4.Trading_Service_Cd = set_null();
0385: NullSetVar0 = 0;
0386: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_30)) {
0387: NullSetVar0 = 1;
0388: } else {
0389: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_19)) {
0390: DSLink4.Trans_Type_Cd1 = InterVar0_47;
0391: } else {
0392: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_20)) {
0393: DSLink4.Trans_Type_Cd1 = InterVar0_48;
0394: } else {
0395: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_21)) {
0396: DSLink4.Trans_Type_Cd1 = InterVar0_49;
0397: } else {
0398: if ((trimc_string(substring_1(FileLink.rowdata , 137 , 2)) == InterVar0_22)) {
0399: DSLink4.Trans_Type_Cd1 = InterVar0_49;
0400: } else {
0401: NullSetVar0 = 1;
0402: }
0403: //;
0404: }
0405: //;
0406: }
0407: //;
0408: }
0409: //;
0410: }
0411: DSLink4.Trans_Type_Cd1 = (NullSetVar0 == 1) ? set_null() : DSLink4.Trans_Type_Cd1;
0412: NullSetVar0 = 0;
0413: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10))) {
0414: NullSetVar0 = 1;
0415: } else {
0416: if (((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14))) {
0417: DSLink4.rb_OrderCloseExpireDateTimeOriginal = timestamp_from_string(StageVar0_vBusinessDateTime);
0418: } else {
0419: NullSetVar0 = 1;
0420: }
0421: //;
0422: }
0423: DSLink4.rb_OrderCloseExpireDateTimeOriginal = (NullSetVar0 == 1) ? set_null() : DSLink4.rb_OrderCloseExpireDateTimeOriginal;
0424: NullSetVar0 = 0;
0425: if (((((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_5) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_6)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_7)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_8)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_9)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_10))) {
0426: NullSetVar0 = 1;
0427: } else {
0428: if (((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14))) {
0429: DSLink4.rb_OrderCloseExpireDateTimeGlobal = timestamp_from_string(StageVar0_vBusinessDateTime);
0430: } else {
0431: NullSetVar0 = 1;
0432: }
0433: //;
0434: }
0435: DSLink4.rb_OrderCloseExpireDateTimeGlobal = (NullSetVar0 == 1) ? set_null() : DSLink4.rb_OrderCloseExpireDateTimeGlobal;
0436: DSLink4.rb_OrderDateTimeOriginal = timestamp_from_string(StageVar0_vOrderdatetime);
0437: DSLink4.rb_OrderDateTimeGlobal = timestamp_from_string(StageVar0_vOrderdatetime);
0438: DSLink4.rb_OrderEntryDateTimeOriginal = timestamp_from_string(StageVar0_vOrderdatetime);
0439: DSLink4.rb_OrderEntryDateTimeGlobal = timestamp_from_string(StageVar0_vOrderdatetime);
0440: DSLink4.rb_TimeZoneOriginal = InterVar0_50;
0441: NullSetVar0 = 0;
0442: if (((trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_30) && ((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)))) {
0443: InterVar0_42 = decimal_from_string(substring_1(FileLink.rowdata , 166 , 15));
0444: DSLink4.Base_Curr_Limit_Price = InterVar0_42;
0445: } else {
0446: NullSetVar0 = 1;
0447: }
0448: DSLink4.Base_Curr_Limit_Price = (NullSetVar0 == 1) ? set_null() : DSLink4.Base_Curr_Limit_Price;
0449: NullSetVar0 = 0;
0450: if (((trimc_string(substring_1(FileLink.rowdata , 159 , 7)) == InterVar0_39) && ((((trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_11) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_14)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_12)) || (trimc_string(substring_1(FileLink.rowdata , 32 , 3)) == InterVar0_13)))) {
0451: InterVar0_42 = decimal_from_string(substring_1(FileLink.rowdata , 166 , 15));
0452: DSLink4.Base_Curr_Stop_Price = InterVar0_42;
0453: } else {
0454: NullSetVar0 = 1;
0455: }
0456: DSLink4.Base_Curr_Stop_Price = (NullSetVar0 == 1) ? set_null() : DSLink4.Base_Curr_Stop_Price;
0457: DSLink4.Order_Key = (((trimc_string(substring_1(FileLink.rowdata , 5 , 6)) + trimc_string(substring_1(FileLink.rowdata , 15 , 6))) + InterVar0_30) + InterVar0_46);
0458: DSLink4.RegIdentifier = substring_1(StageVar0_vRegIdentifier , 1 ,
;0459: DSLink4.Agg_Unit_Cd = set_null();
0460: DSLink4.BAse_Currency_Cd = InterVar0_15;
0461: writerecord 0;
0462: RowRejected0 = 0;
0463: }
0464:
0465: finish {
0466: }
0467:
*** End of Internal Generated Transformer Code
while compiling the job am getting the compilation error:
Parameter specified but not used in flow: DSPXWorkingDir (backup11.xfm_validate)
Pl give the solution ,
Thanks,