Transformer Compilation Error

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
nagarjuna900
Participant
Posts: 35
Joined: Mon Dec 29, 2008 2:22 am
Location: chennai

Transformer Compilation Error

Post by nagarjuna900 »

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 , 8);
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,
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

The "Parameter specified but not used in flow: DSPXWorkingDir..." message is just a warning and not the cause of the failed transform compile. What other messages do you get?
Top
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Try to compile after closing and reopening client.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Have you set the PWD environment variable?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
nagarjuna
Premium Member
Premium Member
Posts: 533
Joined: Fri Jun 27, 2008 9:11 pm
Location: Chicago

Post by nagarjuna »

Is it the first time you are compiling a job with transformer in the project ?
Nag
Top
Post Reply

Return to “General”