DSXchange

Hello,

We have a variable declared as VarChar and we are convering it to an Integer using the following function
where In.Column is the VarChar variable.

We get the following error when we compile:

##I TUTL 000031 18:42:05(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 18:42:05(002) <main_program> orchgeneral: loaded
##I TOSH 000002 18:42:05(003) <main_program> orchsort: loaded
##I TOSH 000002 18:42:05(004) <main_program> orchstats: loaded
##I TFSC 000001 18:42:05(007) <main_program> APT configuration file: /dvl/etl12/Ascential/DataStage/Configurations/etld2.apt
##W TCOS 000049 18:42:06(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E TBLD 000000 18:42:09(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256.
##E TFSR 000019 18:42:09(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 18:42:09(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W TFCP 000048 18:42:09(003) <transform> Error when checking composite operator: Function decimal_from_string, [line 142, character 18], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(004) <transform> Error when checking composite operator: Function decimal_from_string, [line 144, character 18], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(005) <transform> Error when checking composite operator: Function decimal_from_string, [line 166, character 17], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(006) <transform> Error when checking composite operator: Function decimal_from_string, [line 168, character 17], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(007) <transform> Error when checking composite operator: Function decimal_from_string, [line 171, character 18], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(008) <transform> Error when checking composite operator: Function decimal_from_string, [line 173, character 20], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(009) <transform> Error when checking composite operator: Function decimal_from_string, [line 190, character 17], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(010) <transform> Error when checking composite operator: Function decimal_from_string, [line 193, character 19], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(011) <transform> Error when checking composite operator: Function decimal_from_string, [line 210, character 17], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(012) <transform> Error when checking composite operator: Function decimal_from_string, [line 212, character 17], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(013) <transform> Error when checking composite operator: Function decimal_from_string, [line 299, character 17], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(014) <transform> Error when checking composite operator: Function decimal_from_string, [line 302, character 19], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(015) <transform> Error when checking composite operator: Function decimal_from_string, [line 319, character 17], returns a decimal; default precision is used.
##W TFCP 000048 18:42:09(016) <transform> Error when checking composite operator: Function decimal_from_string, [line 321, character 17], returns a decimal; default precision is used.
##W TFCP 000000 18:42:09(017) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000000 18:42:09(018) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000000 18:42:09(019) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000000 18:42:09(020) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000025 18:42:09(021) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 18:42:09(022) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000000 18:42:09(023) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000000 18:42:09(024) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000025 18:42:09(025) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 18:42:09(026) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000000 18:42:09(027) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000000 18:42:09(028) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000000 18:42:09(029) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000025 18:42:09(030) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 18:42:09(031) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000000 18:42:09(032) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TFCP 000000 18:42:09(033) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "DFloat".
##W TBLD 000000 18:42:09(034) <main_program> Error when checking composite operator: Output from subprocess: "/dvl/etlmas/projects/masdvl/RT_BP490.O/V0S28_IntFrRlMtch_Wldstr_FS_Transformer_28.C", line 1599.1: 1540-0184 (S) The "{" has no matching "}".

##I TFCP 000000 18:42:09(035) <transform> Error when checking composite operator: /usr/vacpp/bin/xlC_r -O -I/dvl/etl12/Ascential/DataStage/PXEngine/include -O -c -qspill=32704 /dvl/etlmas/projects/masdvl/RT_BP490.O/V0S28_IntFrRlMtch_Wldstr_FS_Transformer_28.C -o /dvl/etlmas/projects/masdvl/RT_BP490.O/V0S28_IntFrRlMtch_Wldstr_FS_Transformer_28.tmp.o.
##E TCOS 000029 18:42:09(036) <main_program> Creation of a step finished with status = FAILED. (IntFrRlMtch_Wldstr_FS.Transformer_28)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S28_repos_Transformer_28 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink24;
0007: outputname 0 DSLink29;
0008:
0009: initialize {
0010: // define our row rejected variable
0011: int8 RowRejected0;
0012:
0013: // define our null set variable
0014: int8 NullSetVar0;
0015:
0016: // declare our intermediate variables for this section
0017: string InterVar0_0;
0018: string InterVar0_1;
0019: string InterVar0_2;
0020: string InterVar0_3;
0021: string InterVar0_4;
0022: string InterVar0_5;
0023: string InterVar0_14;
0024: string InterVar0_15;
0025: string InterVar0_16;
0026:
0027: // initialise constant values which require conversion
0028: InterVar0_0 = "Y";
0029: InterVar0_1 = "S";
0030: InterVar0_2 = "Z";
0031: InterVar0_3 = "N";
0032: InterVar0_4 = "C";
0033: InterVar0_5 = "A";
0034: InterVar0_14 = "RU";
0035: InterVar0_15 = "XU";
0036: InterVar0_16 = "-";
0037: // Stage variable declaration and initialisation
0038: string StageVar0_StageVar;
0039: StageVar0_StageVar = "";
0040: string StageVar0_StageVar1;
0041: StageVar0_StageVar1 = "";
0042: string StageVar0_StageVar2;
0043: StageVar0_StageVar2 = "";
0044: string StageVar0_StageVar3;
0045: StageVar0_StageVar3 = "";
0046: string StageVar0_StageVar4;
0047: StageVar0_StageVar4 = "";
0048: string StageVar0_StageVar5;
0049: StageVar0_StageVar5 = "";
0050: string StageVar0_StageVar6;
0051: StageVar0_StageVar6 = "";
0052: string StageVar0_StageVar7;
0053: StageVar0_StageVar7 = "";
0054: string StageVar0_StageVar8;
0055: StageVar0_StageVar8 = "";
0056: string StageVar0_StageVar9;
0057: StageVar0_StageVar9 = "";
0058: string StageVar0_StageVar10;
0059: StageVar0_StageVar10 = "";
0060: string StageVar0_StageVar11;
0061: StageVar0_StageVar11 = "";
0062: string StageVar0_StageVar12;
0063: StageVar0_StageVar12 = "";
0064: string StageVar0_StageVar13;
0065: StageVar0_StageVar13 = "";
0066: string StageVar0_StageVar14;
0067: StageVar0_StageVar14 = "";
0068: string StageVar0_StageVar15;
0069: StageVar0_StageVar15 = "";
0070: string StageVar0_StageVar16;
0071: StageVar0_StageVar16 = "";
0072: string StageVar0_StageVar17;
0073: StageVar0_StageVar17 = "";
0074: }
0075:
0076: mainloop {
0077: // initialise our row rejected variable
0078: RowRejected0 = 1;
0079:
0080: // declare our intermediate variables for this section
0081: dfloat InterVar0_6;
0082: int64 InterVar0_7;
0083: dfloat InterVar0_8;
0084: int64 InterVar0_9;
0085: decimal InterVar0_10;
0086: dfloat InterVar0_11;
0087: int64 InterVar0_12;
0088: int64 InterVar0_13;
0089:
0090: // evaluate the stage variables first
0091: if (null(DSLink24.Location1_Type_Code)) {
0092: StageVar0_StageVar = InterVar0_0;
0093: } else {
0094: if (((DSLink24.Location1_Type_Code == InterVar0_1) || (DSLink24.Location1_Type_Code == InterVar0_2))) {
0095: StageVar0_StageVar = InterVar0_0;
0096: } else {
0097: StageVar0_StageVar = InterVar0_3;
0098: }
0099: //;
0100: }
0101: //;
0102: if ((StageVar0_StageVar == InterVar0_3)) {
0103: if ((DSLink24.Location1_Type_Code == InterVar0_4)) {
0104: if (null(DSLink24.LOCATION2_TYPE_CODE)) {
0105: if (((DSLink24.LOCATION1_CODE == DSLink24.Orig_Ap_Cty_Cde) || (DSLink24.LOCATION1_CODE == DSLink24.Dest_Ap_Cty_Cde))) {
0106: StageVar0_StageVar1 = InterVar0_0;
0107: } else {
0108: StageVar0_StageVar1 = InterVar0_3;
0109: }
0110: //;
0111: } else {
0112: StageVar0_StageVar1 = InterVar0_3;
0113: }
0114: //;
0115: } else {
0116: StageVar0_StageVar1 = InterVar0_3;
0117: }
0118: //;
0119: } else {
0120: StageVar0_StageVar1 = InterVar0_3;
0121: }
0122: //;
0123: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0124: if (((DSLink24.Location1_Type_Code == InterVar0_4) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_4))) {
0125: if ((((DSLink24.LOCATION1_CODE == DSLink24.Orig_Ap_Cty_Cde) && (DSLink24.LOCATION2_CODE == DSLink24.Dest_Ap_Cty_Cde)) || ((DSLink24.LOCATION2_CODE == DSLink24.Orig_Ap_Cty_Cde) && (DSLink24.LOCATION2_CODE == DSLink24.Dest_Ap_Cty_Cde)))) {
0126: StageVar0_StageVar2 = InterVar0_0;
0127: } else {
0128: StageVar0_StageVar2 = InterVar0_3;
0129: }
0130: //;
0131: } else {
0132: StageVar0_StageVar2 = InterVar0_3;
0133: }
0134: //;
0135: } else {
0136: StageVar0_StageVar2 = InterVar0_3;
0137: }
0138: //;
0139: if ((StageVar0_StageVar == InterVar0_3)) {
0140: if ((DSLink24.Location1_Type_Code == InterVar0_5)) {
0141: if (null(DSLink24.LOCATION2_TYPE_CODE)) {
0142: InterVar0_6 = decimal_from_string(DSLink24.LOCATION1_CODE);
0143: InterVar0_7 = InterVar0_6;
0144: InterVar0_8 = decimal_from_string(DSLink24.LOCATION1_CODE);
0145: InterVar0_9 = InterVar0_8;
0146: if (((InterVar0_7 == DSLink24.Orig_World_Area_Number) || (InterVar0_9 == DSLink24.Dest_World_Area_Number))) {
0147: StageVar0_StageVar3 = InterVar0_0;
0148: } else {
0149: StageVar0_StageVar3 = InterVar0_3;
0150: }
0151: //;
0152: } else {
0153: StageVar0_StageVar3 = InterVar0_3;
0154: }
0155: //;
0156: } else {
0157: StageVar0_StageVar3 = InterVar0_3;
0158: }
0159: //;
0160: } else {
0161: StageVar0_StageVar3 = InterVar0_3;
0162: }
0163: //;
0164: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0165: if (((DSLink24.Location1_Type_Code == InterVar0_5) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_5))) {
0166: InterVar0_6 = decimal_from_string(DSLink24.LOCATION1_CODE);
0167: InterVar0_7 = InterVar0_6;
0168: InterVar0_8 = decimal_from_string(DSLink24.LOCATION2_CODE);
0169: InterVar0_9 = InterVar0_8;
0170: InterVar0_10 = DSLink24.Orig_World_Area_Number;
0171: InterVar0_11 = decimal_from_string(DSLink24.LOCATION1_CODE);
0172: InterVar0_12 = InterVar0_11;
0173: InterVar0_13 = ((decimal_from_string(DSLink24.LOCATION2_CODE) == InterVar0_10) && (InterVar0_12 == DSLink24.Dest_World_Area_Number));
0174: if ((((InterVar0_7 == DSLink24.Orig_World_Area_Number) && (InterVar0_9 == DSLink24.Dest_World_Area_Number)) || InterVar0_13)) {
0175: StageVar0_StageVar4 = InterVar0_0;
0176: } else {
0177: StageVar0_StageVar4 = InterVar0_3;
0178: }
0179: //;
0180: } else {
0181: StageVar0_StageVar4 = InterVar0_3;
0182: }
0183: //;
0184: } else {
0185: StageVar0_StageVar4 = InterVar0_3;
0186: }
0187: //;
0188: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0189: if (((DSLink24.Location1_Type_Code == InterVar0_4) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_5))) {
0190: InterVar0_6 = decimal_from_string(DSLink24.LOCATION2_CODE);
0191: InterVar0_7 = InterVar0_6;
0192: InterVar0_10 = DSLink24.Orig_World_Area_Number;
0193: InterVar0_9 = ((decimal_from_string(DSLink24.LOCATION2_CODE) == InterVar0_10) && (DSLink24.LOCATION1_CODE == DSLink24.Dest_Ap_Cty_Cde));
0194: if ((((DSLink24.LOCATION1_CODE == DSLink24.Orig_Ap_Cty_Cde) && (InterVar0_7 == DSLink24.Dest_World_Area_Number)) || InterVar0_9)) {
0195: StageVar0_StageVar5 = InterVar0_0;
0196: } else {
0197: StageVar0_StageVar5 = InterVar0_3;
0198: }
0199: //;
0200: } else {
0201: StageVar0_StageVar5 = InterVar0_3;
0202: }
0203: //;
0204: } else {
0205: StageVar0_StageVar5 = InterVar0_3;
0206: }
0207: //;
0208: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0209: if (((DSLink24.Location1_Type_Code == InterVar0_5) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_4))) {
0210: InterVar0_6 = decimal_from_string(DSLink24.LOCATION1_CODE);
0211: InterVar0_7 = InterVar0_6;
0212: InterVar0_8 = decimal_from_string(DSLink24.LOCATION1_CODE);
0213: InterVar0_9 = InterVar0_8;
0214: if ((((InterVar0_7 == DSLink24.Orig_World_Area_Number) && (DSLink24.LOCATION2_CODE == DSLink24.Dest_Ap_Cty_Cde)) || ((DSLink24.LOCATION2_CODE == DSLink24.Orig_Ap_Cty_Cde) && (InterVar0_9 == DSLink24.Dest_World_Area_Number)))) {
0215: StageVar0_StageVar6 = InterVar0_0;
0216: } else {
0217: StageVar0_StageVar6 = InterVar0_3;
0218: }
0219: //;
0220: } else {
0221: StageVar0_StageVar6 = InterVar0_3;
0222: }
0223: //;
0224: } else {
0225: StageVar0_StageVar6 = InterVar0_3;
0226: }
0227: //;
0228: if ((StageVar0_StageVar == InterVar0_3)) {
0229: if ((DSLink24.Location1_Type_Code == InterVar0_3)) {
0230: if (null(DSLink24.LOCATION2_TYPE_CODE)) {
0231: if (((substring_1(DSLink24.LOCATION1_CODE , 1 , 2) == DSLink24.Orig_Country_Code) || (substring_1(DSLink24.LOCATION1_CODE , 1 , 2) == DSLink24.Dest_Country_Code))) {
0232: StageVar0_StageVar7 = InterVar0_0;
0233: } else {
0234: StageVar0_StageVar7 = InterVar0_3;
0235: }
0236: //;
0237: } else {
0238: StageVar0_StageVar7 = InterVar0_3;
0239: }
0240: //;
0241: } else {
0242: StageVar0_StageVar7 = InterVar0_3;
0243: }
0244: //;
0245: } else {
0246: StageVar0_StageVar7 = InterVar0_3;
0247: }
0248: //;
0249: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0250: if (((DSLink24.Location1_Type_Code == InterVar0_3) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_3))) {
0251: if ((((substring_1(DSLink24.LOCATION1_CODE , 1 , 2) == DSLink24.Orig_Country_Code) && (substring_1(DSLink24.LOCATION2_CODE , 1 , 2) == DSLink24.Dest_Country_Code)) || ((substring_1(DSLink24.LOCATION2_CODE , 1 , 2) == DSLink24.Orig_Country_Code) && (substring_1(DSLink24.LOCATION1_CODE , 1 , 2) == DSLink24.Dest_Country_Code)))) {
0252: StageVar0_StageVar8 = InterVar0_0;
0253: } else {
0254: StageVar0_StageVar8 = InterVar0_3;
0255: }
0256: //;
0257: } else {
0258: StageVar0_StageVar8 = InterVar0_3;
0259: }
0260: //;
0261: } else {
0262: StageVar0_StageVar8 = InterVar0_3;
0263: }
0264: //;
0265: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0266: if (((DSLink24.Location1_Type_Code == InterVar0_4) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_3))) {
0267: if ((((DSLink24.LOCATION1_CODE == DSLink24.Orig_Ap_Cty_Cde) && (substring_1(DSLink24.LOCATION2_CODE , 1 , 2) == DSLink24.Dest_Country_Code)) || ((substring_1(DSLink24.LOCATION2_CODE , 1 , 2) == DSLink24.Orig_Country_Code) && (DSLink24.LOCATION1_CODE == DSLink24.Dest_Ap_Cty_Cde)))) {
0268: StageVar0_StageVar9 = InterVar0_0;
0269: } else {
0270: StageVar0_StageVar9 = InterVar0_3;
0271: }
0272: //;
0273: } else {
0274: StageVar0_StageVar9 = InterVar0_3;
0275: }
0276: //;
0277: } else {
0278: StageVar0_StageVar9 = InterVar0_3;
0279: }
0280: //;
0281: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0282: if (((DSLink24.Location1_Type_Code == InterVar0_3) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_4))) {
0283: if ((((substring_1(DSLink24.LOCATION1_CODE , 1 , 2) == DSLink24.Orig_Country_Code) && (DSLink24.LOCATION2_CODE == DSLink24.Dest_Ap_Cty_Cde)) || ((DSLink24.LOCATION2_CODE == DSLink24.Orig_Ap_Cty_Cde) && (substring_1(DSLink24.LOCATION1_CODE , 1 , 2) == DSLink24.Dest_Country_Code)))) {
0284: StageVar0_StageVar10 = InterVar0_0;
0285: } else {
0286: StageVar0_StageVar10 = InterVar0_3;
0287: }
0288: //;
0289: } else {
0290: StageVar0_StageVar10 = InterVar0_3;
0291: }
0292: //;
0293: } else {
0294: StageVar0_StageVar10 = InterVar0_3;
0295: }
0296: //;
0297: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0298: if (((DSLink24.Location1_Type_Code == InterVar0_3) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_5))) {
0299: InterVar0_6 = decimal_from_string(DSLink24.LOCATION2_CODE);
0300: InterVar0_7 = InterVar0_6;
0301: InterVar0_10 = DSLink24.Orig_World_Area_Number;
0302: InterVar0_9 = ((decimal_from_string(DSLink24.LOCATION2_CODE) == InterVar0_10) && (substring_1(DSLink24.LOCATION1_CODE , 1 , 2) == DSLink24.Dest_Country_Code));
0303: if ((((substring_1(DSLink24.LOCATION1_CODE , 1 , 2) == DSLink24.Orig_Country_Code) && (InterVar0_7 == DSLink24.Dest_World_Area_Number)) || InterVar0_9)) {
0304: StageVar0_StageVar11 = InterVar0_0;
0305: } else {
0306: StageVar0_StageVar11 = InterVar0_3;
0307: }
0308: //;
0309: } else {
0310: StageVar0_StageVar11 = InterVar0_3;
0311: }
0312: //;
0313: } else {
0314: StageVar0_StageVar11 = InterVar0_3;
0315: }
0316: //;
0317: if ((notnull(DSLink24.Location1_Type_Code) && notnull(DSLink24.LOCATION2_TYPE_CODE))) {
0318: if (((DSLink24.Location1_Type_Code == InterVar0_5) && (DSLink24.LOCATION2_TYPE_CODE == InterVar0_3))) {
0319: InterVar0_6 = decimal_from_string(DSLink24.LOCATION1_CODE);
0320: InterVar0_7 = InterVar0_6;
0321: InterVar0_8 = decimal_from_string(DSLink24.LOCATION1_CODE);
0322: InterVar0_9 = InterVar0_8;
0323: if ((((InterVar0_7 == DSLink24.Orig_World_Area_Number) && (substring_1(DSLink24.LOCATION2_CODE , 1 , 2) == DSLink24.Dest_Country_Code)) || ((substring_1(DSLink24.LOCATION2_CODE , 1 , 2) == DSLink24.Orig_Country_Code) && (InterVar0_9 == DSLink24.Dest_World_Area_Number)))) {
0324: StageVar0_StageVar12 = InterVar0_0;
0325: } else {
0326: StageVar0_StageVar12 = InterVar0_3;
0327: }
0328: //;
0329: } else {
0330: StageVar0_StageVar12 = InterVar0_3;
0331: }
0332: //;
0333: } else {
0334: StageVar0_StageVar12 = InterVar0_3;
0335: }
0336: //;
0337: if (null(DSLink24.LOCATION2_TYPE_CODE)) {
0338: StageVar0_StageVar13 = InterVar0_3;
0339: } else {
0340: if (((DSLink24.LOCATION2_TYPE_CODE == InterVar0_1) || (DSLink24.LOCATION2_TYPE_CODE == InterVar0_2))) {
0341: StageVar0_StageVar13 = InterVar0_0;
0342: } else {
0343: StageVar0_StageVar13 = InterVar0_3;
0344: }
0345: //;
0346: }
0347: //;
0348: if (notnull(DSLink24.Orig_Country_Code)) {
0349: if (((DSLink24.Spec_Origin_Country_Code == InterVar0_14) && (DSLink24.Orig_Country_Code == InterVar0_15))) {
0350: StageVar0_StageVar14 = InterVar0_0;
0351: } else {
0352: StageVar0_StageVar14 = InterVar0_3;
0353: }
0354: //;
0355: } else {
0356: StageVar0_StageVar14 = InterVar0_3;
0357: }
0358: //;
0359: if (notnull(DSLink24.Dest_Country_Code)) {
0360: if (((DSLink24.Spec_Destination_Country_Code == InterVar0_14) && (DSLink24.Dest_Country_Code == InterVar0_15))) {
0361: StageVar0_StageVar15 = InterVar0_0;
0362: } else {
0363: StageVar0_StageVar15 = InterVar0_3;
0364: }
0365: //;
0366: } else {
0367: StageVar0_StageVar15 = InterVar0_3;
0368: }
0369: //;
0370: if (null(DSLink24.Directional_Ind)) {
0371: StageVar0_StageVar16 = InterVar0_3;
0372: } else {
0373: if (((DSLink24.Directional_Ind == 3) || (DSLink24.Directional_Ind == 4))) {
0374: StageVar0_StageVar16 = InterVar0_0;
0375: } else {
0376: StageVar0_StageVar16 = InterVar0_3;
0377: }
0378: //;
0379: }
0380: //;
0381: if (null(DSLink24.Fare_Class_Code)) {
0382: StageVar0_StageVar17 = InterVar0_0;
0383: } else {
0384: if (null(DSLink24.Frbs_Cde)) {
0385: StageVar0_StageVar17 = InterVar0_0;
0386: } else {
0387: if ((((DSLink24.Frbs_Cde != DSLink24.Fare_Class_Code) && (index_of_substring_basic(DSLink24.Fare_Class_Code , InterVar0_16 , 1) > 0)) && (index_of_substring_basic(DSLink24.FARE_CLASS_CODE_WILD , DSLink24.Frbs_Cde , 1) > 0))) {
0388: StageVar0_StageVar17 = InterVar0_0;
0389: } else {
0390: StageVar0_StageVar17 = InterVar0_3;
0391: }
0392: //;
0393: }
0394: //;
0395: }
0396: //;
0397:
0398: // evaluate constraint and columns for link: DSLink29
0399: if (((((((((((((((((((StageVar0_StageVar == InterVar0_0) || (StageVar0_StageVar1 == InterVar0_0)) || (StageVar0_StageVar2 == InterVar0_0)) || (StageVar0_StageVar3 == InterVar0_0)) || (StageVar0_StageVar4 == InterVar0_0)) || (StageVar0_StageVar5 == InterVar0_0)) || (StageVar0_StageVar6 == InterVar0_0)) || (StageVar0_StageVar7 == InterVar0_0)) || (StageVar0_StageVar8 == InterVar0_0)) || (StageVar0_StageVar9 == InterVar0_0)) || (StageVar0_StageVar10 == InterVar0_0)) || (StageVar0_StageVar11 == InterVar0_0)) || (StageVar0_StageVar12 == InterVar0_0)) || (StageVar0_StageVar13 == InterVar0_0)) || (StageVar0_StageVar14 == InterVar0_0)) || (StageVar0_StageVar15 == InterVar0_0)) || (StageVar0_StageVar16 == InterVar0_0)) || (StageVar0_StageVar17 == InterVar0_0)))
0400: {
0401: DSLink29.Day_Of_Week_Type_Code = DSLink24.Day_Of_Week_Type_Code;
0402: DSLink29.FOOTNOTE_CODE = DSLink24.Pub_Ftnte_Id_Cde;
0403: writerecord 0;
0404: RowRejected0 = 0;
0405: }
0406: }
0407:
0408: finish {
0409: }
0410:
*** End of Internal Generated Transformer Code


Please let me know what I am doing wrong here.

Thanks.

Can you compile other jobs with Transformer stages?

Ray,

Yes. I can.

Thanks.

Any SetNull() function used in the Stage Variable?

DS User

No SetNull() function used.

Checking the validity before conversion seems to have fixed the problem. So adding before converting seems to work.

That is a "best practice" but I'm a little surprised to see it as a compile time error rather than a run time error. Interesting.