While compiling the job, We are getting Compilation error.
Please find below the details.
Output from transformer compilation follows:
##I TFCN 000001 11:05:20(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 11:05:20(001) <main_program> The open files limit is 8192; raising to 2147483647.
##I TOSH 000002 11:05:20(002) <main_program> orchgeneral: loaded
##I TOSH 000002 11:05:21(000) <main_program> orchsort: loaded
##I TOSH 000002 11:05:21(001) <main_program> orchstats: loaded
##I TFSC 000001 11:05:21(004) <main_program> APT configuration file: /usr/local/etl/default.apt
##W TCOS 000049 11:05:24(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (Spd_Daily_Ald_Credit_Load_Job.Stg_Ald_Credit_Validate_Tfm)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S21_repos_Stg_Ald_Credit_Validate_Tfm transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 Lkup_Credit_lnk;
0007: outputname 0 Valid_Records;
0008: outputname 1 Rej_Rec_Lnk;
0009: outputname 2 Error_Records;
0010:
0011: global {
0012: // Job parameter declaration
0013: string p_Spd_Trg_Username;
0014: string p_Spd_Cyc_Run_Id;
0015: }
0016:
0017: initialize {
0018: // define and initialise our input row count variable
0019: uint64 InRowNumber0;
0020: InRowNumber0 = 0;
0021:
0022: // define our row rejected variable
0023: int8 RowRejected0;
0024:
0025: // define our null set variable
0026: int8 NullSetVar0;
0027:
0028: // declare our intermediate variables for this section
0029: string InterVar0_1;
0030: string InterVar0_2;
0031: string InterVar0_4;
0032: string InterVar0_5;
0033: string InterVar0_6;
0034: string InterVar0_7;
0035: string InterVar0_8;
0036: string InterVar0_9;
0037: string InterVar0_10;
0038: string InterVar0_12;
0039: string InterVar0_14;
0040: string InterVar0_15;
0041: string InterVar0_16;
0042: string InterVar0_17;
0043: string InterVar0_18;
0044: string InterVar0_19;
0045: string InterVar0_20;
0046: string InterVar0_21;
0047: string InterVar0_22;
0048: string InterVar0_23;
0049: string InterVar0_24;
0050: string InterVar0_25;
0051: string InterVar0_26;
0052: string InterVar0_27;
0053: string InterVar0_28;
0054: string InterVar0_29;
0055: string InterVar0_30;
0056: string InterVar0_31;
0057: string InterVar0_32;
0058: string InterVar0_33;
0059: string InterVar0_34;
0060: string InterVar0_35;
0061: string InterVar0_36;
0062:
0063: // initialise constant values which require conversion
0064: InterVar0_1 = "";
0065: InterVar0_2 = "SPD0000101";
0066: InterVar0_4 = "00000997";
0067: InterVar0_5 = "N";
0068: InterVar0_6 = "SPD0000032";
0069: InterVar0_7 = "SPD0000102";
0070: InterVar0_8 = "IF";
0071: InterVar0_9 = "SPD0000103";
0072: InterVar0_10 = "PRS";
0073: InterVar0_12 = "ADD";
0074: InterVar0_14 = "DEL";
0075: InterVar0_15 = "SPD0000104";
0076: InterVar0_16 = "SPD0000122";
0077: InterVar0_17 = "I";
0078: InterVar0_18 = "D";
0079: InterVar0_19 = "SPD0000120";
0080: InterVar0_20 = "SPD0000119";
0081: InterVar0_21 = "SPD0000046";
0082: InterVar0_22 = "SPD00000133";
0083: InterVar0_23 = "Y";
0084: InterVar0_24 = "%mm%dd%yyyy %hh:%nn:%ss";
0085: InterVar0_25 = "S";
0086: InterVar0_26 = " ";
0087: InterVar0_27 = "SENDING_FIRM";
0088: InterVar0_28 = "SOURCE_SQ";
0089: InterVar0_29 = "SRC_CREDIT_FILE_TYPE_CD";
0090: InterVar0_30 = "SRC_STATUS_TYPE";
0091: InterVar0_31 = "PRINCIPLE_LENDER_ID";
0092: InterVar0_32 = "SRC_ID_IRS";
0093: InterVar0_33 = "CTRY_CD";
0094: InterVar0_34 = "LOCAL_GOV_CTRY_CD";
0095: InterVar0_35 = "CURRENCY";
0096: InterVar0_36 = "CLASS_CD";
0097: // Stage variable declaration and initialisation
0098: string StageVar0_vSendingfirmid;
0099: StageVar0_vSendingfirmid = "";
0100: string StageVar0_vSourcesq;
0101: StageVar0_vSourcesq = "";
0102: string StageVar0_vAldcreditfiletypecd;
0103: StageVar0_vAldcreditfiletypecd = "";
0104: string StageVar0_vstatustype;
0105: StageVar0_vstatustype = "";
0106: string StageVar0_vPrincipallenderid;
0107: StageVar0_vPrincipallenderid = "";
0108: string StageVar0_vidirs;
0109: StageVar0_vidirs = "";
0110: string StageVar0_vIncctrycd;
0111: StageVar0_vIncctrycd = "";
0112: string StageVar0_vLocalgovernmentctrycd;
0113: StageVar0_vLocalgovernmentctrycd = "";
0114: string StageVar0_vValueccyid;
0115: StageVar0_vValueccyid = "";
0116: string StageVar0_vClass;
0117: StageVar0_vClass = "";
0118: string StageVar0_ValidRec;
0119: StageVar0_ValidRec = "";
0120: }
0121:
0122: mainloop {
0123: // initialise our row rejected variable
0124: RowRejected0 = 1;
0125:
0126: // increment our input row count
0127: InRowNumber0 = InRowNumber0 + 1;
0128:
0129: // declare our intermediate variables for this section
0130: string InterVar0_0;
0131: string InterVar0_3;
0132: string InterVar0_11;
0133: string InterVar0_13;
0134:
0135: // evaluate the stage variables first
0136: if (notnull(Lkup_Credit_lnk.LKP_SENDING_FIRM)) {
0137: InterVar0_0 = Lkup_Credit_lnk.LKP_SENDING_FIRM;
0138: } else {
0139: InterVar0_0 = InterVar0_1;
0140: }
0141: if ((trim_leading_trailing(InterVar0_0) == InterVar0_1)) {
0142: StageVar0_vSendingfirmid = InterVar0_2;
0143: } else {
0144: if (notnull(Lkup_Credit_lnk.LKP_SENDING_FIRM)) {
0145: InterVar0_3 = Lkup_Credit_lnk.LKP_SENDING_FIRM;
0146: } else {
0147: InterVar0_3 = InterVar0_1;
0148: }
0149: if ((trim_leading_trailing(InterVar0_3) == InterVar0_4)) {
0150: StageVar0_vSendingfirmid = InterVar0_5;
0151: } else {
0152: StageVar0_vSendingfirmid = InterVar0_2;
0153: }
0154: //;
0155: }
0156: //;
0157: if (null(Lkup_Credit_lnk.LKP_SOURCE_SQ)) {
0158: StageVar0_vSourcesq = InterVar0_6;
0159: } else {
0160: StageVar0_vSourcesq = InterVar0_5;
0161: }
0162: //;
0163: if (notnull(Lkup_Credit_lnk.SRC_CREDIT_FILE_TYPE_CD)) {
0164: InterVar0_0 = Lkup_Credit_lnk.SRC_CREDIT_FILE_TYPE_CD;
0165: } else {
0166: InterVar0_0 = InterVar0_1;
0167: }
0168: if ((trim_leading_trailing(InterVar0_0) == InterVar0_1)) {
0169: StageVar0_vAldcreditfiletypecd = InterVar0_7;
0170: } else {
0171: if (notnull(Lkup_Credit_lnk.SRC_CREDIT_FILE_TYPE_CD)) {
0172: InterVar0_3 = Lkup_Credit_lnk.SRC_CREDIT_FILE_TYPE_CD;
0173: } else {
0174: InterVar0_3 = InterVar0_1;
0175: }
0176: if ((trim_leading_trailing(InterVar0_3) == InterVar0_8)) {
0177: StageVar0_vAldcreditfiletypecd = InterVar0_5;
0178: } else {
0179: StageVar0_vAldcreditfiletypecd = InterVar0_7;
0180: }
0181: //;
0182: }
0183: //;
0184: if (notnull(Lkup_Credit_lnk.SRC_STATUS_TYPE)) {
0185: InterVar0_0 = Lkup_Credit_lnk.SRC_STATUS_TYPE;
0186: } else {
0187: InterVar0_0 = InterVar0_1;
0188: }
0189: if ((trim_leading_trailing(InterVar0_0) == InterVar0_1)) {
0190: StageVar0_vstatustype = InterVar0_9;
0191: } else {
0192: if (notnull(Lkup_Credit_lnk.SRC_STATUS_TYPE)) {
0193: InterVar0_3 = Lkup_Credit_lnk.SRC_STATUS_TYPE;
0194: } else {
0195: InterVar0_3 = InterVar0_1;
0196: }
0197: if (notnull(Lkup_Credit_lnk.SRC_STATUS_TYPE)) {
0198: InterVar0_11 = Lkup_Credit_lnk.SRC_STATUS_TYPE;
0199: } else {
0200: InterVar0_11 = InterVar0_1;
0201: }
0202: if (notnull(Lkup_Credit_lnk.SRC_STATUS_TYPE)) {
0203: InterVar0_13 = Lkup_Credit_lnk.SRC_STATUS_TYPE;
0204: } else {
0205: InterVar0_13 = InterVar0_1;
0206: }
0207: if ((((trim_leading_trailing(InterVar0_3) == InterVar0_10) || (trim_leading_trailing(InterVar0_11) == InterVar0_12)) || (trim_leading_trailing(InterVar0_13) == InterVar0_14))) {
0208: StageVar0_vstatustype = InterVar0_5;
0209: } else {
0210: StageVar0_vstatustype = InterVar0_9;
0211: }
0212: //;
0213: }
0214: //;
0215: if (null(Lkup_Credit_lnk.SRC_PRINCIPAL_LENDER_ID)) {
0216: StageVar0_vPrincipallenderid = InterVar0_15;
0217: } else {
0218: StageVar0_vPrincipallenderid = InterVar0_5;
0219: }
0220: //;
0221: if (notnull(Lkup_Credit_lnk.SRC_ID_IRS)) {
0222: InterVar0_0 = Lkup_Credit_lnk.SRC_ID_IRS;
0223: } else {
0224: InterVar0_0 = InterVar0_1;
0225: }
0226: if ((trim_leading_trailing(InterVar0_0) == InterVar0_1)) {
0227: StageVar0_vidirs = InterVar0_16;
0228: } else {
0229: if (notnull(Lkup_Credit_lnk.SRC_ID_IRS)) {
0230: InterVar0_3 = Lkup_Credit_lnk.SRC_ID_IRS;
0231: } else {
0232: InterVar0_3 = InterVar0_1;
0233: }
0234: if (notnull(Lkup_Credit_lnk.SRC_ID_IRS)) {
0235: InterVar0_11 = Lkup_Credit_lnk.SRC_ID_IRS;
0236: } else {
0237: InterVar0_11 = InterVar0_1;
0238: }
0239: if (((trim_leading_trailing(InterVar0_3) == InterVar0_17) || (trim_leading_trailing(InterVar0_11) == InterVar0_18))) {
0240: StageVar0_vidirs = InterVar0_5;
0241: } else {
0242: StageVar0_vidirs = InterVar0_16;
0243: }
0244: //;
0245: }
0246: //;
0247: if (null(Lkup_Credit_lnk.LKP_CTRY_CD)) {
0248: StageVar0_vIncctrycd = InterVar0_19;
0249: } else {
0250: StageVar0_vIncctrycd = InterVar0_5;
0251: }
0252: //;
0253: if (null(Lkup_Credit_lnk.LKP_LOCAL_GOV_CTRY_CD)) {
0254: StageVar0_vLocalgovernmentctrycd = InterVar0_20;
0255: } else {
0256: StageVar0_vLocalgovernmentctrycd = InterVar0_5;
0257: }
0258: //;
0259: if (null(Lkup_Credit_lnk.LKP_CURRENCY)) {
0260: StageVar0_vValueccyid = InterVar0_21;
0261: } else {
0262: StageVar0_vValueccyid = InterVar0_5;
0263: }
0264: //;
0265: if (null(Lkup_Credit_lnk.LKP_CLASS)) {
0266: StageVar0_vClass = InterVar0_22;
0267: } else {
0268: StageVar0_vClass = InterVar0_5;
0269: }
0270: //;
0271: if (((((((((((StageVar0_vAldcreditfiletypecd == InterVar0_5) && (StageVar0_vIncctrycd == InterVar0_5)) && (StageVar0_vLocalgovernmentctrycd == InterVar0_5)) && (StageVar0_vPrincipallenderid == InterVar0_5)) && (StageVar0_vSendingfirmid == InterVar0_5)) && (StageVar0_vSourcesq == InterVar0_5)) && (StageVar0_vValueccyid == InterVar0_5)) && (StageVar0_vstatustype == InterVar0_5)) && (StageVar0_vidirs == InterVar0_5)) && (StageVar0_vClass == InterVar0_5))) {
0272: StageVar0_ValidRec = InterVar0_23;
0273: } else {
0274: StageVar0_ValidRec = InterVar0_5;
0275: }
0276: //;
0277:
0278: // evaluate constraint and columns for link: Valid_Records
0279: if ((StageVar0_ValidRec == InterVar0_23))
0280: {
0281: if (notnull(Lkup_Credit_lnk.CALENDAR_DT)) {
0282: InterVar0_0 = string_from_timestamp(Lkup_Credit_lnk.CALENDAR_DT);
0283: } else {
0284: InterVar0_0 = InterVar0_1;
0285: }
0286: Valid_Records.CALENDAR_DT = timestamp_from_string(trim_leading_trailing(InterVar0_0) , InterVar0_24);
0287: if (notnull(Lkup_Credit_lnk.SRC_SENDING_FIRM)) {
0288: InterVar0_0 = Lkup_Credit_lnk.SRC_SENDING_FIRM;
0289: } else {
0290: InterVar0_0 = InterVar0_1;
0291: }
0292: Valid_Records.SENDING_FIRM_ID = trim_leading_trailing(InterVar0_0);
0293: if (notnull(decimal_from_string(Lkup_Credit_lnk.LKP_SOURCE_SQ))) {
0294: InterVar0_3 = decimal_from_string(Lkup_Credit_lnk.LKP_SOURCE_SQ);
0295: InterVar0_0 = InterVar0_3;
0296: } else {
0297: InterVar0_0 = InterVar0_1;
0298: }
0299: Valid_Records.SOURCE_SQ = trim_leading_trailing(InterVar0_0);
0300: if (notnull(Lkup_Credit_lnk.SRC_CREDIT_FILE_TYPE_CD)) {
0301: InterVar0_0 = Lkup_Credit_lnk.SRC_CREDIT_FILE_TYPE_CD;
0302: } else {
0303: InterVar0_0 = InterVar0_1;
0304: }
0305: Valid_Records.ALD_CREDIT_FILE_TYPE_CD = trim_leading_trailing(InterVar0_0);
0306: if (notnull(Lkup_Credit_lnk.SRC_STATUS_TYPE)) {
0307: InterVar0_0 = Lkup_Credit_lnk.SRC_STATUS_TYPE;
0308: } else {
0309: InterVar0_0 = InterVar0_1;
0310: }
0311: Valid_Records.ALD_STATUS_CD = trim_leading_trailing(InterVar0_0);
0312: if (notnull(Lkup_Credit_lnk.SRC_STATUS_DT)) {
0313: InterVar0_0 = Lkup_Credit_lnk.SRC_STATUS_DT;
0314: } else {
0315: InterVar0_0 = InterVar0_1;
0316: }
0317: Valid_Records.ALD_STATUS_AS_OF_DT = timestamp_from_string(trim_leading_trailing(InterVar0_0) , InterVar0_24);
0318: if (notnull(Lkup_Credit_lnk.SRC_BORR_TAX_ID)) {
0319: InterVar0_0 = Lkup_Credit_lnk.SRC_BORR_TAX_ID;
0320: } else {
0321: InterVar0_0 = InterVar0_1;
0322: }
0323: Valid_Records.BORROWER_TAX_ID = trim_leading_trailing(InterVar0_0);
0324: if (notnull(Lkup_Credit_lnk.SRC_PRINCIPAL_LENDER_ID)) {
0325: InterVar0_0 = Lkup_Credit_lnk.SRC_PRINCIPAL_LENDER_ID;
0326: } else {
0327: InterVar0_0 = InterVar0_1;
0328: }
0329: Valid_Records.PRINCIPAL_LENDER_ID = trim_leading_trailing(InterVar0_0);
0330: if (notnull(Lkup_Credit_lnk.SRC_ID_IRS)) {
0331: InterVar0_0 = Lkup_Credit_lnk.SRC_ID_IRS;
0332: } else {
0333: InterVar0_0 = InterVar0_1;
0334: }
0335: Valid_Records.ID_IRS_CD = trim_leading_trailing(InterVar0_0);
0336: if (notnull(Lkup_Credit_lnk.SRC_PREDECESSOR_TAX_ID)) {
0337: InterVar0_0 = Lkup_Credit_lnk.SRC_PREDECESSOR_TAX_ID;
0338: } else {
0339: InterVar0_0 = InterVar0_1;
0340: }
0341: Valid_Records.PREDECESSOR_TAX_ID = trim_leading_trailing(InterVar0_0);
0342: if (notnull(Lkup_Credit_lnk.SRC_LOCAL_GOV_ID)) {
0343: InterVar0_0 = Lkup_Credit_lnk.SRC_LOCAL_GOV_ID;
0344: } else {
0345: InterVar0_0 = InterVar0_1;
0346: }
0347: Valid_Records.LOCAL_GOVERNMENT_ID = trim_leading_trailing(InterVar0_0);
0348: if (notnull(Lkup_Credit_lnk.SRC_PRINCIPAL_LENDER_NM)) {
0349: InterVar0_0 = Lkup_Credit_lnk.SRC_PRINCIPAL_LENDER_NM;
0350: } else {
0351: InterVar0_0 = InterVar0_1;
0352: }
0353: Valid_Records.PRINCIPLE_NM = trim_leading_trailing(InterVar0_0);
0354: if (notnull(Lkup_Credit_lnk.SRC_ADD1)) {
0355: InterVar0_0 = Lkup_Credit_lnk.SRC_ADD1;
0356: } else {
0357: InterVar0_0 = InterVar0_1;
0358: }
0359: Valid_Records.INC_ADDR_LINE_1_TXT = trim_leading_trailing(InterVar0_0);
0360: if (notnull(Lkup_Credit_lnk.SRC_ADD2)) {
0361: InterVar0_0 = Lkup_Credit_lnk.SRC_ADD2;
0362: } else {
0363: InterVar0_0 = InterVar0_1;
0364: }
0365: Valid_Records.INC_ADDR_LINE_2_TXT = trim_leading_trailing(InterVar0_0);
0366: if (notnull(Lkup_Credit_lnk.SRC_CITY)) {
0367: InterVar0_0 = Lkup_Credit_lnk.SRC_CITY;
0368: } else {
0369: InterVar0_0 = InterVar0_1;
0370: }
0371: Valid_Records.INC_CITY_TXT = trim_leading_trailing(InterVar0_0);
0372: if (notnull(Lkup_Credit_lnk.SRC_STATE)) {
0373: InterVar0_0 = Lkup_Credit_lnk.SRC_STATE;
0374: } else {
0375: InterVar0_0 = InterVar0_1;
0376: }
0377: Valid_Records.INC_US_STATE_CD = trim_leading_trailing(InterVar0_0);
0378: if (notnull(Lkup_Credit_lnk.SRC_MAIL_CODE)) {
0379: InterVar0_0 = Lkup_Credit_lnk.SRC_MAIL_CODE;
0380: } else {
0381: InterVar0_0 = InterVar0_1;
0382: }
0383: Valid_Records.INC_POSTAL_CD_TXT = trim_leading_trailing(InterVar0_0);
0384: if (notnull(Lkup_Credit_lnk.SRC_CTRY_CD)) {
0385: InterVar0_0 = Lkup_Credit_lnk.SRC_CTRY_CD;
0386: } else {
0387: InterVar0_0 = InterVar0_1;
0388: }
0389: Valid_Records.INC_CTRY_CD = trim_leading_trailing(InterVar0_0);
0390: if (notnull(Lkup_Credit_lnk.SRC_LOCAL_GOV_CTRY_CD)) {
0391: InterVar0_0 = Lkup_Credit_lnk.SRC_LOCAL_GOV_CTRY_CD;
0392: } else {
0393: InterVar0_0 = InterVar0_1;
0394: }
0395: Valid_Records.LOCAL_GOVERNMENT_CTRY_CD = trim_leading_trailing(InterVar0_0);
0396: if (notnull(Lkup_Credit_lnk.SRC_CONTACT)) {
0397: InterVar0_0 = Lkup_Credit_lnk.SRC_CONTACT;
0398: } else {
0399: InterVar0_0 = InterVar0_1;
0400: }
0401: Valid_Records.CONTACT_NM = trim_leading_trailing(InterVar0_0);
0402: if (notnull(Lkup_Credit_lnk.SRC_CONTACT_PHONE)) {
0403: InterVar0_0 = Lkup_Credit_lnk.SRC_CONTACT_PHONE;
0404: } else {
0405: InterVar0_0 = InterVar0_1;
0406: }
0407: Valid_Records.TELEPHONE_NUMBER_TXT = trim_leading_trailing(InterVar0_0);
0408: if (notnull(Lkup_Credit_lnk.SRC_CLASS)) {
0409: InterVar0_0 = Lkup_Credit_lnk.SRC_CLASS;
0410: } else {
0411: InterVar0_0 = InterVar0_1;
0412: }
0413: Valid_Records.CLIENT_CLASS_CD = trim_leading_trailing(InterVar0_0);
0414: if (notnull(Lkup_Credit_lnk.SRC_PARENT)) {
0415: InterVar0_0 = Lkup_Credit_lnk.SRC_PARENT;
0416: } else {
0417: InterVar0_0 = InterVar0_1;
0418: }
0419: Valid_Records.ALD_PARENT_NM = trim_leading_trailing(InterVar0_0);
0420: if (notnull(Lkup_Credit_lnk.SRC_CURRENCY)) {
0421: InterVar0_0 = Lkup_Credit_lnk.SRC_CURRENCY;
0422: } else {
0423: InterVar0_0 = InterVar0_1;
0424: }
0425: Valid_Records.VALUE_CCY_ID = trim_leading_trailing(InterVar0_0);
0426: if (notnull(Lkup_Credit_lnk.SRC_LENDABLE_ASSET_AMT)) {
0427: InterVar0_0 = Lkup_Credit_lnk.SRC_LENDABLE_ASSET_AMT;
0428: } else {
0429: InterVar0_0 = InterVar0_1;
0430: }
0431: Valid_Records.LENDABLE_ASSETS_AMT = trim_leading_trailing(InterVar0_0);
0432: if (notnull(Lkup_Credit_lnk.SRC_LENDABLE_ASSET_DT)) {
0433: InterVar0_0 = Lkup_Credit_lnk.SRC_LENDABLE_ASSET_DT;
0434: } else {
0435: InterVar0_0 = InterVar0_1;
0436: }
0437: Valid_Records.LENDABLE_ASSETS_AS_OF_DT = timestamp_from_string(trim_leading_trailing(InterVar0_0) , InterVar0_24);
0438: if (notnull(Lkup_Credit_lnk.SRC_CAP_AMT)) {
0439: InterVar0_0 = Lkup_Credit_lnk.SRC_CAP_AMT;
0440: } else {
0441: InterVar0_0 = InterVar0_1;
0442: }
0443: Valid_Records.CAPITALIZATION_AMT = trim_leading_trailing(InterVar0_0);
0444: if (notnull(Lkup_Credit_lnk.SRC_CAP_DT)) {
0445: InterVar0_0 = Lkup_Credit_lnk.SRC_CAP_DT;
0446: } else {
0447: InterVar0_0 = InterVar0_1;
0448: }
0449: Valid_Records.CAPITALIZATION_AS_OF_DT = timestamp_from_string(trim_leading_trailing(InterVar0_0) , InterVar0_24);
0450: if (notnull(Lkup_Credit_lnk.SRC_CUSTODY_AMT)) {
0451: InterVar0_0 = Lkup_Credit_lnk.SRC_CUSTODY_AMT;
0452: } else {
0453: InterVar0_0 = InterVar0_1;
0454: }
0455: Valid_Records.CUSTODY_ASSETS_AMT = trim_leading_trailing(InterVar0_0);
0456: if (notnull(Lkup_Credit_lnk.SRC_CUSTODY_DT)) {
0457: InterVar0_0 = Lkup_Credit_lnk.SRC_CUSTODY_DT;
0458: } else {
0459: InterVar0_0 = InterVar0_1;
0460: }
0461: Valid_Records.CUSTODY_ASSETS_AS_OF_DT = timestamp_from_string(trim_leading_trailing(InterVar0_0) , InterVar0_24);
0462: if (notnull(Lkup_Credit_lnk.SRC_NAV_DT)) {
0463: InterVar0_0 = Lkup_Credit_lnk.SRC_NAV_DT;
0464: } else {
0465: InterVar0_0 = InterVar0_1;
0466: }
0467: Valid_Records.NAV_AS_OF_DT = timestamp_from_string(trim_leading_trailing(InterVar0_0) , InterVar0_24);
0468: if (notnull(Lkup_Credit_lnk.SRC_NAV_AMT)) {
0469: InterVar0_0 = Lkup_Credit_lnk.SRC_NAV_AMT;
0470: } else {
0471: InterVar0_0 = InterVar0_1;
0472: }
0473: Valid_Records.NAV_AMT = trim_leading_trailing(InterVar0_0);
0474: Valid_Records.LAST_MOD_SIGNON_ID = p_Spd_Trg_Username;
0475: Valid_Records.LAST_MOD_DATE_TIME = current_timestamp();
0476: Valid_Records.CYCLE_RUN_ID = p_Spd_Cyc_Run_Id;
0477: writerecord 0;
0478: RowRejected0 = 0;
0479: }
0480: // evaluate constraint and columns for link: Rej_Rec_Lnk
0481: if ((StageVar0_ValidRec == InterVar0_5))
0482: {
0483: Rej_Rec_Lnk.CYCLE_RUN_ID = Lkup_Credit_lnk.CYCLE_RUN_ID;
0484: Rej_Rec_Lnk.REC_SEQ_NUM = ((get_partition_num() + (get_num_of_partitions() * (InRowNumber0 - 1))) + 1);
0485: Rej_Rec_Lnk.ERROR_STATUS_CD = InterVar0_25;
0486: Rej_Rec_Lnk.SRC_RECEIVING_FIRM_TAX_ID = Lkup_Credit_lnk.SRC_SENDING_FIRM_TAX_ID;
0487: Rej_Rec_Lnk.SRC_SENDING_FIRM_TAX_ID = Lkup_Credit_lnk.SRC_RECEIVING_FIRM_TAX_ID;
0488: Rej_Rec_Lnk.LAST_MOD_DATE_TIME = current_timestamp();
0489: Rej_Rec_Lnk.LAST_MOD_SIGNON_ID = p_Spd_Trg_Username;
0490: Rej_Rec_Lnk.COMMENT_TXT = InterVar0_26;
0491: writerecord 1;
0492: RowRejected0 = 0;
0493: }
0494: // evaluate constraint and columns for link: Error_Records
0495: if ((StageVar0_ValidRec == InterVar0_5))
0496: {
0497: Error_Records.SRC_SENDING_FIRM_CD = StageVar0_vSendingfirmid;
0498: Error_Records.SOURCE_SQ_CD = StageVar0_vSourcesq;
0499: Error_Records.SRC_CREDIT_FILE_TYPE_CD_CD = StageVar0_vAldcreditfiletypecd;
0500: Error_Records.SRC_STATUS_TYPE_CD = StageVar0_vstatustype;
0501: Error_Records.SRC_PRINCIPLE_LENDER_ID_CD = StageVar0_vPrincipallenderid;
0502: Error_Records.SRC_ID_IRS_CD = StageVar0_vidirs;
0503: Error_Records.SRC_CTRY_CD_CD = StageVar0_vIncctrycd;
0504: Error_Records.SRC_LOCAL_GOV_CTRY_CD_CD = StageVar0_vLocalgovernmentctrycd;
0505: Error_Records.SRC_CURRENCY_CD = StageVar0_vValueccyid;
0506: Error_Records.SRC_CLASS_CD = StageVar0_vClass;
0507: if ((StageVar0_vSendingfirmid != InterVar0_5)) {
0508: Error_Records.ERROR_COLUMN_NM_SRC_SENDING_FIRM = InterVar0_27;
0509: } else {
0510: Error_Records.ERROR_COLUMN_NM_SRC_SENDING_FIRM = InterVar0_5;
0511: }
0512: //;
0513: if ((StageVar0_vSourcesq != InterVar0_5)) {
0514: Error_Records.ERROR_COLUMN_NM_SOURCE_SQ = InterVar0_28;
0515: } else {
0516: Error_Records.ERROR_COLUMN_NM_SOURCE_SQ = InterVar0_5;
0517: }
0518: //;
0519: if ((StageVar0_vAldcreditfiletypecd != InterVar0_5)) {
0520: Error_Records.ERROR_COLUMN_NM_SRC_CREDIT_FILE_TYPE_CD = InterVar0_29;
0521: } else {
0522: Error_Records.ERROR_COLUMN_NM_SRC_CREDIT_FILE_TYPE_CD = InterVar0_5;
0523: }
0524: //;
0525: if ((StageVar0_vstatustype != InterVar0_5)) {
0526: Error_Records.ERROR_COLUMN_NM_STATUS_TYPE = InterVar0_30;
0527: } else {
0528: Error_Records.ERROR_COLUMN_NM_STATUS_TYPE = InterVar0_5;
0529: }
0530: //;
0531: if ((StageVar0_vPrincipallenderid != InterVar0_5)) {
0532: Error_Records.ERROR_COLUMN_NM_SRC_PRINCIPLE_LENDER_ID = InterVar0_31;
0533: } else {
0534: Error_Records.ERROR_COLUMN_NM_SRC_PRINCIPLE_LENDER_ID = InterVar0_5;
0535: }
0536: //;
0537: if ((StageVar0_vidirs != InterVar0_5)) {
0538: Error_Records.ERROR_COLUMN_NM_SRC_ID_IRS = InterVar0_32;
0539: } else {
0540: Error_Records.ERROR_COLUMN_NM_SRC_ID_IRS = InterVar0_5;
0541: }
0542: //;
0543: if ((StageVar0_vIncctrycd != InterVar0_5)) {
0544: Error_Records.ERROR_COLUMN_NM_SRC_CTRY_CD = InterVar0_33;
0545: } else {
0546: Error_Records.ERROR_COLUMN_NM_SRC_CTRY_CD = InterVar0_5;
0547: }
0548: //;
0549: if ((StageVar0_vLocalgovernmentctrycd != InterVar0_5)) {
0550: Error_Records.ERROR_COLUMN_NM_SRC_LOCAL_GOV_CTRY_CD = InterVar0_34;
0551: } else {
0552: Error_Records.ERROR_COLUMN_NM_SRC_LOCAL_GOV_CTRY_CD = InterVar0_5;
0553: }
0554: //;
0555: if ((StageVar0_vValueccyid != InterVar0_5)) {
0556: Error_Records.ERROR_COLUMN_NM_SRC_CURRENCY = InterVar0_35;
0557: } else {
0558: Error_Records.ERROR_COLUMN_NM_SRC_CURRENCY = InterVar0_5;
0559: }
0560: //;
0561: if ((StageVar0_vClass != InterVar0_5)) {
0562: Error_Records.ERROR_COLUMN_NM_CLASS = InterVar0_36;
0563: } else {
0564: Error_Records.ERROR_COLUMN_NM_CLASS = InterVar0_5;
0565: }
0566: //;
0567: Error_Records.SRC_SOURCE_SQ = Lkup_Credit_lnk.LKP_SOURCE_SQ;
0568: Error_Records.ERROR_REC_SEQ_NUM = ((get_partition_num() + (get_num_of_partitions() * (InRowNumber0 - 1))) + 1);
0569: writerecord 2;
0570: RowRejected0 = 0;
0571: }
0572: }
0573:
0574: finish {
0575: }
0576:
*** End of Internal Generated Transformer Code
Compilation Error in the Trasformer
Moderators: chulett, rschirm, roy
-
Shamanth_vk
- Premium Member
- Posts: 9
- Joined: Sat Jul 14, 2007 10:47 am
-
Shamanth_vk
- Premium Member
- Posts: 9
- Joined: Sat Jul 14, 2007 10:47 am