We have a weird error as follows
We are running Datastage EE - Server version 7.5.1, Client Version - 7.5.1.A. Server is Sun Solaris, Clients are Windows XP Pro.
We have two jobs in our process out of approx 30 that will only compile on my machine and will not compile on any other Developers machines. The job once compiled by myself, works fine and we are about to go into production with this code. We are basically concerned that in the future if we need to make a change to this job, it will have to be made on my PC only which isn't ideal.
I know this is a problem that could have a wide range of causes but if anybody has seen this behaviour I would be interested in hearing of their experience, and if people have suggestions of configuration or other settings on the client/job or server that we should look at I would be grateful if you shared them also.
I've attached the output from Transformer Compilation for a failed compilation on another developers machine below,
Code: Select all
Output from transformer compilation follows:
##I TFCN 000001 15:36:38(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 15:36:38(001) <main_program> The open files limit is 100; raising to 65536.
##I TOSH 000002 15:36:38(002) <main_program> orchgeneral: loaded
##I TOSH 000002 15:36:38(003) <main_program> orchsort: loaded
##I TOSH 000002 15:36:38(004) <main_program> orchstats: loaded
##I TFSC 000001 15:36:38(007) <main_program> APT configuration file: /app/dstage/Ascential/DataStage/Configurations/ATR3_DEV_1Node.apt
##W TCOS 000049 15:36:39(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W TFCP 000000 15:36:40(000) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W TFCP 000025 15:36:40(001) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:36:40(002) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:36:40(003) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:36:40(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:36:40(005) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:36:40(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:36:40(007) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:36:40(008) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:36:40(009) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:36:40(010) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##E TFCP 000026 15:36:40(011) <transform> Error when checking composite operator: Setting null to this non-nullable field: StageVar0_svBalnA1.
##E TFSR 000019 15:36:40(012) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 15:36:40(013) <main_program> Creation of a step finished with status = FAILED. (LoadLndDealIntoStgAcctDomain_1.XfmLndDeal)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_LoadLndDealIntoStgAcctDomain_1_XfmLndDeal transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 InLndDeal;
0007: outputname 0 InAcctBase;
0008: outputname 1 InAcctBalnIntPaid;
0009: outputname 2 InAcctFeatRate;
0010: outputname 3 InAcctFeatTerm;
0011: outputname 4 InAcctFeatFreq;
0012: outputname 5 InAcctBalnIntAcrd;
0013: outputname 6 InAcctDept;
0014: outputname 7 InAcctPdctGL;
0015: outputname 8 InAcctDeptCntl;
0016:
0017: initialize {
0018: // define our row rejected variable
0019: int8 RowRejected0;
0020:
0021: // define our null set variable
0022: int8 NullSetVar0;
0023:
0024: // declare our intermediate variables for this section
0025: string InterVar0_0;
0026: string InterVar0_1;
0027: string InterVar0_2;
0028: string InterVar0_3;
0029: string InterVar0_4;
0030: string InterVar0_5;
0031: string InterVar0_6;
0032: string InterVar0_7;
0033: string InterVar0_8;
0034: string InterVar0_9;
0035: string InterVar0_10;
0036: string InterVar0_11;
0037: string InterVar0_12;
0038: string InterVar0_13;
0039: string InterVar0_14;
0040: string InterVar0_15;
0041: string InterVar0_16;
0042: date InterVar0_17;
0043: string InterVar0_18;
0044: string InterVar0_19;
0045: string InterVar0_20;
0046: string InterVar0_21;
0047: string InterVar0_22;
0048: decimal 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_36;
0061: string InterVar0_37;
0062: string InterVar0_38;
0063: string InterVar0_39;
0064: string InterVar0_40;
0065: string InterVar0_41;
0066: string InterVar0_42;
0067: string InterVar0_43;
0068: string InterVar0_44;
0069: string InterVar0_45;
0070:
0071: // initialise constant values which require conversion
0072: InterVar0_0 = "CDABAACD";
0073: InterVar0_1 = "11AM";
0074: InterVar0_2 = "DMM";
0075: InterVar0_3 = "D1";
0076: InterVar0_4 = "-";
0077: InterVar0_5 = "E";
0078: InterVar0_6 = "BA";
0079: InterVar0_7 = "IPAID";
0080: InterVar0_8 = "ICHG";
0081: InterVar0_9 = "IACRD ";
0082: InterVar0_10 = "IACRC";
0083: InterVar0_11 = " ";
0084: InterVar0_12 = "C";
0085: InterVar0_13 = "Y";
0086: InterVar0_14 = "N";
0087: InterVar0_15 = "";
0088: InterVar0_16 = "A";
0089: InterVar0_17 = date_from_string("9999-12-31");
0090: InterVar0_18 = "FNCL";
0091: InterVar0_19 = "DEAL";
0092: InterVar0_20 = "UNKN";
0093: InterVar0_21 = "CBA";
0094: InterVar0_22 = "AUD";
0095: InterVar0_23 = 0;
0096: InterVar0_24 = "I5DMMSMlAcctBase";
0097: InterVar0_25 = "ACCT_BASE";
0098: InterVar0_26 = "AGGR";
0099: InterVar0_27 = "I5DMMSMlAcctBalnInt";
0100: InterVar0_28 = "ACCT_BALN_INT";
0101: InterVar0_29 = "PAID";
0102: InterVar0_30 = "DEAL INTEREST RATE";
0103: InterVar0_31 = "I5DMMSMlAcctFeat";
0104: InterVar0_32 = "ACCT_FEAT";
0105: InterVar0_33 = "RATE";
0106: InterVar0_34 = "TERM IN DAYS";
0107: InterVar0_36 = "TERM";
0108: InterVar0_37 = "FREQ";
0109: InterVar0_38 = "ACRD";
0110: InterVar0_39 = "DMMDUM";
0111: InterVar0_40 = "I5DMMSMlAcctDept";
0112: InterVar0_41 = "ACCT_DEPT";
0113: InterVar0_42 = "9999999";
0114: InterVar0_43 = "I5DMMSMlAcctPdctGl";
0115: InterVar0_44 = "ACCT_PDCT_GL";
0116: InterVar0_45 = "CNTL";
0117: // Stage variable declaration and initialisation
0118: int32 StageVar0_sv11AMCount;
0119: StageVar0_sv11AMCount = 0;
0120: string[3] StageVar0_svSrceSystC;
0121: StageVar0_svSrceSystC = "";
0122: string[2] StageVar0_svAcctQlfyC;
0123: StageVar0_svAcctQlfyC = "";
0124: date StageVar0_svHeaderDateFormat;
0125: StageVar0_svHeaderDateFormat = date_from_string("2001-01-01");
0126: string StageVar0_svAcctI;
0127: StageVar0_svAcctI = "";
0128: decimal[15,2] StageVar0_svBalnA1;
0129: StageVar0_svBalnA1 = 0;
0130: decimal[15,2] StageVar0_svBalnA2;
0131: StageVar0_svBalnA2 = 0;
0132: decimal[15,2] StageVar0_svBalnA3;
0133: StageVar0_svBalnA3 = 0;
0134: decimal[15,2] StageVar0_svBalnA4;
0135: StageVar0_svBalnA4 = 0;
0136: date StageVar0_svLifeCyclD;
0137: StageVar0_svLifeCyclD = date_from_string("2001-01-01");
0138: string[5] StageVar0_svIntPaidBalnTypeC;
0139: StageVar0_svIntPaidBalnTypeC = "";
0140: string[5] StageVar0_svIntAcrdBalnTypeC;
0141: StageVar0_svIntAcrdBalnTypeC = "";
0142: string StageVar0_svFromDate;
0143: StageVar0_svFromDate = "";
0144: string StageVar0_svMatDate;
0145: StageVar0_svMatDate = "";
0146: string StageVar0_AcctBalnChange;
0147: StageVar0_AcctBalnChange = "";
0148: string StageVar0_AcctFeatRateChge;
0149: StageVar0_AcctFeatRateChge = "";
0150: string StageVar0_AcctFeatTermChge;
0151: StageVar0_AcctFeatTermChge = "";
0152: string StageVar0_AcctFeatFreqChge;
0153: StageVar0_AcctFeatFreqChge = "";
0154: string StageVar0_AcctBaseChge;
0155: StageVar0_AcctBaseChge = "";
0156: string StageVar0_AcctDeptChge;
0157: StageVar0_AcctDeptChge = "";
0158: string StageVar0_AcctDeptCntlChge;
0159: StageVar0_AcctDeptCntlChge = "";
0160: string StageVar0_AcctPdctGLChge;
0161: StageVar0_AcctPdctGLChge = "";
0162: string StageVar0_AcctBalnIntPdChge;
0163: StageVar0_AcctBalnIntPdChge = "";
0164: string StageVar0_AcctBalnIntAccruedChge;
0165: StageVar0_AcctBalnIntAccruedChge = "";
0166: string StageVar0_ExpireAll;
0167: StageVar0_ExpireAll = "";
0168: date StageVar0_svEfftD;
0169: StageVar0_svEfftD = date_from_string("2001-01-01");
0170: date StageVar0_svExpyD;
0171: StageVar0_svExpyD = date_from_string("2001-01-01");
0172: }
0173:
0174: mainloop {
0175: // initialise our row rejected variable
0176: RowRejected0 = 1;
0177:
0178: // declare our intermediate variables for this section
0179: decimal InterVar0_35;
0180:
0181: // evaluate the stage variables first
0182: if ((InLndDeal.TERM == InterVar0_0)) {
0183: StageVar0_sv11AMCount = 1;
0184: } else {
0185: StageVar0_sv11AMCount = count_substring(upper_case(InLndDeal.TERM) , InterVar0_1);
0186: }
0187: //;
0188: StageVar0_svSrceSystC = InterVar0_2;
0189: StageVar0_svAcctQlfyC = InterVar0_3;
0190: StageVar0_svHeaderDateFormat = date_from_string((((substring_1(InLndDeal.HEADER_DT , 1 , 4) + InterVar0_4) + substring_1(InLndDeal.HEADER_DT , 5 , 2)) + InterVar0_4) + substring_1(InLndDeal.HEADER_DT , 7 , 2));
0191: StageVar0_svAcctI = (((StageVar0_svSrceSystC + StageVar0_svAcctQlfyC) + InLndDeal.CLIENT_NO) + InLndDeal.DEP_NO);
0192: NullSetVar0 = 0;
0193: if (null(InLndDeal.BROKER_PD)) {
0194: NullSetVar0 = 1;
0195: } else {
0196: StageVar0_svBalnA1 = InLndDeal.BROKER_PD;
0197: }
0198: StageVar0_svBalnA1 = (NullSetVar0 == 1) ? set_null() : StageVar0_svBalnA1;
0199: NullSetVar0 = 0;
0200: if (null(InLndDeal.PRINCIPLE)) {
0201: NullSetVar0 = 1;
0202: } else {
0203: StageVar0_svBalnA2 = InLndDeal.PRINCIPLE;
0204: }
0205: StageVar0_svBalnA2 = (NullSetVar0 == 1) ? set_null() : StageVar0_svBalnA2;
0206: NullSetVar0 = 0;
0207: if (null(InLndDeal.INT_PAID_TP)) {
0208: NullSetVar0 = 1;
0209: } else {
0210: StageVar0_svBalnA3 = InLndDeal.INT_PAID_TP;
0211: }
0212: StageVar0_svBalnA3 = (NullSetVar0 == 1) ? set_null() : StageVar0_svBalnA3;
0213: NullSetVar0 = 0;
0214: if (null(InLndDeal.INT_ACCRUED_SOP)) {
0215: NullSetVar0 = 1;
0216: } else {
0217: StageVar0_svBalnA4 = InLndDeal.INT_ACCRUED_SOP;
0218: }
0219: StageVar0_svBalnA4 = (NullSetVar0 == 1) ? set_null() : StageVar0_svBalnA4;
0220: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0221: StageVar0_svLifeCyclD = current_date();
0222: } else {
0223: StageVar0_svLifeCyclD = date_from_string((((substring_1(InLndDeal.DT_OPEN , 1 , 4) + InterVar0_4) + substring_1(InLndDeal.DT_OPEN , 5 , 2)) + InterVar0_4) + substring_1(InLndDeal.DT_OPEN , 7 , 2));
0224: }
0225: //;
0226: if ((InLndDeal.BA_LA == InterVar0_6)) {
0227: StageVar0_svIntPaidBalnTypeC = InterVar0_7;
0228: } else {
0229: StageVar0_svIntPaidBalnTypeC = InterVar0_8;
0230: }
0231: //;
0232: if ((InLndDeal.BA_LA == InterVar0_6)) {
0233: StageVar0_svIntAcrdBalnTypeC = InterVar0_9;
0234: } else {
0235: StageVar0_svIntAcrdBalnTypeC = InterVar0_10;
0236: }
0237: //;
0238: StageVar0_svFromDate = ((((substring_1(InLndDeal.FROM_DT , 1 , 4) + InterVar0_4) + substring_1(InLndDeal.FROM_DT , 5 , 2)) + InterVar0_4) + substring_1(InLndDeal.FROM_DT , 7 , 2));
0239: if (null(InLndDeal.DEAL_MAT_DT)) {
0240: StageVar0_svMatDate = InterVar0_11;
0241: } else {
0242: StageVar0_svMatDate = ((((substring_1(InLndDeal.DEAL_MAT_DT , 1 , 4) + InterVar0_4) + substring_1(InLndDeal.DEAL_MAT_DT , 5 , 2)) + InterVar0_4) + substring_1(InLndDeal.DEAL_MAT_DT , 7 , 2));
0243: }
0244: //;
0245: if ((InLndDeal.ACTION_FG_PRINC == InterVar0_12)) {
0246: StageVar0_AcctBalnChange = InterVar0_13;
0247: } else {
0248: StageVar0_AcctBalnChange = InterVar0_14;
0249: }
0250: //;
0251: if ((((InLndDeal.ACTION_FG_RATE == InterVar0_12) || (InLndDeal.ACTION_FG_FROM_DT == InterVar0_12)) || (InLndDeal.ACTION_FG_MAT_DT == InterVar0_12))) {
0252: StageVar0_AcctFeatRateChge = InterVar0_13;
0253: } else {
0254: StageVar0_AcctFeatRateChge = InterVar0_14;
0255: }
0256: //;
0257: if (((InLndDeal.ACTION_FG_FROM_DT == InterVar0_12) || (InLndDeal.ACTION_FG_MAT_DT == InterVar0_12))) {
0258: StageVar0_AcctFeatTermChge = InterVar0_13;
0259: } else {
0260: StageVar0_AcctFeatTermChge = InterVar0_14;
0261: }
0262: //;
0263: if (((InLndDeal.ACTION_FG_FROM_DT == InterVar0_12) || (InLndDeal.ACTION_FG_MAT_DT == InterVar0_12))) {
0264: StageVar0_AcctFeatFreqChge = InterVar0_13;
0265: } else {
0266: StageVar0_AcctFeatFreqChge = InterVar0_14;
0267: }
0268: //;
0269: if (((((InLndDeal.ACTION_FG_REFER_BY == InterVar0_12) || (InLndDeal.ACTION_FG_BUSN_UNIT == InterVar0_12)) || (InLndDeal.ACTION_FG_FROM_DT == InterVar0_12)) && (InLndDeal.ACTION_FG == InterVar0_12))) {
0270: StageVar0_AcctBaseChge = InterVar0_13;
0271: } else {
0272: StageVar0_AcctBaseChge = InterVar0_14;
0273: }
0274: //;
0275: if ((InLndDeal.ACTION_FG_DEPT == InterVar0_12)) {
0276: StageVar0_AcctDeptChge = InterVar0_13;
0277: } else {
0278: StageVar0_AcctDeptChge = InterVar0_14;
0279: }
0280: //;
0281: if ((InLndDeal.ACTION_FG_DEPT_CNTL == InterVar0_12)) {
0282: StageVar0_AcctDeptCntlChge = InterVar0_13;
0283: } else {
0284: StageVar0_AcctDeptCntlChge = InterVar0_14;
0285: }
0286: //;
0287: if ((InLndDeal.ACTION_FG_MSA == InterVar0_12)) {
0288: StageVar0_AcctPdctGLChge = InterVar0_13;
0289: } else {
0290: StageVar0_AcctPdctGLChge = InterVar0_14;
0291: }
0292: //;
0293: if ((InLndDeal.ACTION_FG_INT_PD == InterVar0_12)) {
0294: StageVar0_AcctBalnIntPdChge = InterVar0_13;
0295: } else {
0296: StageVar0_AcctBalnIntPdChge = InterVar0_14;
0297: }
0298: //;
0299: if ((InLndDeal.ACTION_FG_INT_ACCRUED == InterVar0_12)) {
0300: StageVar0_AcctBalnIntAccruedChge = InterVar0_13;
0301: } else {
0302: StageVar0_AcctBalnIntAccruedChge = InterVar0_14;
0303: }
0304: //;
0305: if ((((((((((((((((((InLndDeal.ACTION_FG == InterVar0_5) && (trimc_string(InLndDeal.ACTION_FG_BRK_PD) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_BUSN_UNIT) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_DEALER) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_FROM_DT) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_INT_ACCRUED) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_INT_FREQ) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_INT_PD) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_MAT_DT) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_PDCT_N) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_PRINC) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_RATE) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_REFER_BY) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_TERM) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_DEPT) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_DEPT_CNTL) == InterVar0_15)) && (trimc_string(InLndDeal.ACTION_FG_MSA) == InterVar0_15))) {
0306: StageVar0_ExpireAll = InterVar0_13;
0307: } else {
0308: StageVar0_ExpireAll = InterVar0_14;
0309: }
0310: //;
0311: NullSetVar0 = 0;
0312: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0313: NullSetVar0 = 1;
0314: } else {
0315: if ((((((((((((InLndDeal.ACTION_FG == InterVar0_16) || (StageVar0_AcctBalnChange == InterVar0_13)) || (StageVar0_AcctBalnIntAccruedChge == InterVar0_13)) || (StageVar0_AcctBalnIntPdChge == InterVar0_13)) || (StageVar0_AcctBaseChge == InterVar0_13)) || (StageVar0_AcctFeatFreqChge == InterVar0_13)) || (StageVar0_AcctFeatRateChge == InterVar0_13)) || (StageVar0_AcctFeatTermChge == InterVar0_13)) || (StageVar0_AcctPdctGLChge == InterVar0_13)) || (StageVar0_AcctDeptCntlChge == InterVar0_13)) || (StageVar0_AcctDeptChge == InterVar0_13))) {
0316: StageVar0_svEfftD = StageVar0_svHeaderDateFormat;
0317: } else {
0318: NullSetVar0 = 1;
0319: }
0320: //;
0321: }
0322: StageVar0_svEfftD = (NullSetVar0 == 1) ? set_null() : StageVar0_svEfftD;
0323: if (((InLndDeal.ACTION_FG == InterVar0_5) && ((((((((((StageVar0_AcctBalnChange == InterVar0_13) || (StageVar0_AcctBalnIntAccruedChge == InterVar0_13)) || (StageVar0_AcctBalnIntPdChge == InterVar0_13)) || (StageVar0_AcctBaseChge == InterVar0_13)) || (StageVar0_AcctFeatFreqChge == InterVar0_13)) || (StageVar0_AcctFeatRateChge == InterVar0_13)) || (StageVar0_AcctFeatTermChge == InterVar0_13)) || (StageVar0_AcctPdctGLChge == InterVar0_13)) || (StageVar0_AcctDeptCntlChge == InterVar0_13)) || (StageVar0_AcctDeptChge == InterVar0_13)))) {
0324: StageVar0_svExpyD = date_from_days_since(-1 , string_from_date(StageVar0_svHeaderDateFormat));
0325: } else {
0326: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0327: StageVar0_svExpyD = StageVar0_svHeaderDateFormat;
0328: } else {
0329: StageVar0_svExpyD = InterVar0_17;
0330: }
0331: //;
0332: }
0333: //;
0334:
0335: // evaluate constraint and columns for link: InAcctBase
0336: if ((((InLndDeal.ACTION_FG == InterVar0_16) || (StageVar0_ExpireAll == InterVar0_13)) || (StageVar0_AcctBaseChge == InterVar0_13)))
0337: {
0338: InAcctBase.ACCT_I = StageVar0_svAcctI;
0339: InAcctBase.SRCE_SYST_C = StageVar0_svSrceSystC;
0340: InAcctBase.SRCE_SYST_ACCT_N = (InLndDeal.CLIENT_NO + InLndDeal.DEP_NO);
0341: InAcctBase.ACCT_QLFY_C = StageVar0_svAcctQlfyC;
0342: InAcctBase.ACCT_N = set_null();
0343: InAcctBase.OPEN_D = date_from_string(StageVar0_svFromDate);
0344: NullSetVar0 = 0;
0345: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0346: InAcctBase.CLSE_D = StageVar0_svHeaderDateFormat;
0347: } else {
0348: NullSetVar0 = 1;
0349: }
0350: InAcctBase.CLSE_D = (NullSetVar0 == 1) ? set_null() : InAcctBase.CLSE_D;
0351: InAcctBase.ACCT_CATG_TYPE_C = InterVar0_18;
0352: InAcctBase.ACCT_CLAS_TYPE_C = InterVar0_19;
0353: InAcctBase.ACCT_OBTN_TYPE_C = InterVar0_20;
0354: InAcctBase.ORIG_I = InterVar0_21;
0355: NullSetVar0 = 0;
0356: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0357: InAcctBase.ACCT_CLSE_REAS_C = InterVar0_20;
0358: } else {
0359: NullSetVar0 = 1;
0360: }
0361: InAcctBase.ACCT_CLSE_REAS_C = (NullSetVar0 == 1) ? set_null() : InAcctBase.ACCT_CLSE_REAS_C;
0362: InAcctBase.BUSN_UNIT_BRCH_N = InLndDeal.REFER_BY;
0363: InAcctBase.CNCY_C = InterVar0_22;
0364: InAcctBase.EROR_SEQN_I = InterVar0_23;
0365: InAcctBase.UPDATE_FG = InLndDeal.ACTION_FG;
0366: InAcctBase.CONV_M = InterVar0_24;
0367: InAcctBase.TABLE_NAME = InterVar0_25;
0368: writerecord 0;
0369: RowRejected0 = 0;
0370: }
0371: // evaluate constraint and columns for link: InAcctBalnIntPaid
0372: if (((((InLndDeal.ACTION_FG == InterVar0_16) && notnull(InLndDeal.INT_PAID_TP)) || ((StageVar0_ExpireAll == InterVar0_13) && notnull(InLndDeal.INT_PAID_TP))) || ((StageVar0_AcctBalnIntPdChge == InterVar0_13) && notnull(InLndDeal.INT_PAID_TP))))
0373: {
0374: InAcctBalnIntPaid.ACCT_I = StageVar0_svAcctI;
0375: InAcctBalnIntPaid.BALN_TYPE_C = StageVar0_svIntPaidBalnTypeC;
0376: InAcctBalnIntPaid.CALC_FUNC_C = InterVar0_26;
0377: InAcctBalnIntPaid.TIME_PERD_C = InterVar0_12;
0378: NullSetVar0 = 0;
0379: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0380: NullSetVar0 = 1;
0381: } else {
0382: InAcctBalnIntPaid.EFFT_D = StageVar0_svEfftD;
0383: }
0384: InAcctBalnIntPaid.EFFT_D = (NullSetVar0 == 1) ? set_null() : InAcctBalnIntPaid.EFFT_D;
0385: InAcctBalnIntPaid.BALN_A = StageVar0_svBalnA3;
0386: InAcctBalnIntPaid.CALC_F = InterVar0_14;
0387: InAcctBalnIntPaid.EXPY_D = StageVar0_svExpyD;
0388: InAcctBalnIntPaid.EROR_SEQN_I = InterVar0_23;
0389: InAcctBalnIntPaid.UPDATE_FG = InLndDeal.ACTION_FG;
0390: InAcctBalnIntPaid.CONV_M = InterVar0_27;
0391: InAcctBalnIntPaid.TABLE_NAME = InterVar0_28;
0392: InAcctBalnIntPaid.ACCT_I_LU = (StageVar0_svAcctI + InterVar0_29);
0393: writerecord 1;
0394: RowRejected0 = 0;
0395: }
0396: // evaluate constraint and columns for link: InAcctFeatRate
0397: if (((((InLndDeal.ACTION_FG == InterVar0_16) && notnull(InLndDeal.RATE)) || ((StageVar0_ExpireAll == InterVar0_13) && notnull(InLndDeal.RATE))) || ((StageVar0_AcctFeatRateChge == InterVar0_13) && notnull(InLndDeal.RATE))))
0398: {
0399: InAcctFeatRate.ACCT_I = StageVar0_svAcctI;
0400: InAcctFeatRate.FEAT_I = InLndDeal.RATE_FEAT_I;
0401: InAcctFeatRate.ACCT_FEAT_STRT_D = date_from_string(StageVar0_svFromDate);
0402: NullSetVar0 = 0;
0403: if (null(InLndDeal.DEAL_MAT_DT)) {
0404: NullSetVar0 = 1;
0405: } else {
0406: InAcctFeatRate.ACCT_FEAT_END_D = date_from_string(StageVar0_svMatDate);
0407: }
0408: InAcctFeatRate.ACCT_FEAT_END_D = (NullSetVar0 == 1) ? set_null() : InAcctFeatRate.ACCT_FEAT_END_D;
0409: InAcctFeatRate.FEAT_VALU_X = InterVar0_30;
0410: InAcctFeatRate.FEAT_VALU_Q = set_null();
0411: InAcctFeatRate.FEAT_VALU_A = set_null();
0412: InAcctFeatRate.FEAT_VALU_R = InLndDeal.RATE;
0413: NullSetVar0 = 0;
0414: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0415: NullSetVar0 = 1;
0416: } else {
0417: InAcctFeatRate.EFFT_D = StageVar0_svEfftD;
0418: }
0419: InAcctFeatRate.EFFT_D = (NullSetVar0 == 1) ? set_null() : InAcctFeatRate.EFFT_D;
0420: InAcctFeatRate.EXPY_D = StageVar0_svExpyD;
0421: InAcctFeatRate.EROR_SEQN_I = InterVar0_23;
0422: InAcctFeatRate.UPDATE_FG = InLndDeal.ACTION_FG;
0423: InAcctFeatRate.CONV_M = InterVar0_31;
0424: InAcctFeatRate.TABLE_NAME = InterVar0_32;
0425: InAcctFeatRate.ACCT_I_LU = (StageVar0_svAcctI + InterVar0_33);
0426: writerecord 2;
0427: RowRejected0 = 0;
0428: }
0429: // evaluate constraint and columns for link: InAcctFeatTerm
0430: if (((((InLndDeal.ACTION_FG == InterVar0_16) || (StageVar0_ExpireAll == InterVar0_13)) || (StageVar0_AcctFeatTermChge == InterVar0_13)) && (StageVar0_sv11AMCount == 0)))
0431: {
0432: InAcctFeatTerm.ACCT_I = StageVar0_svAcctI;
0433: InAcctFeatTerm.FEAT_I = InLndDeal.TERM_FEAT_I;
0434: InAcctFeatTerm.ACCT_FEAT_STRT_D = date_from_string(StageVar0_svFromDate);
0435: NullSetVar0 = 0;
0436: if (null(InLndDeal.DEAL_MAT_DT)) {
0437: NullSetVar0 = 1;
0438: } else {
0439: InAcctFeatTerm.ACCT_FEAT_END_D = date_from_string(StageVar0_svMatDate);
0440: }
0441: InAcctFeatTerm.ACCT_FEAT_END_D = (NullSetVar0 == 1) ? set_null() : InAcctFeatTerm.ACCT_FEAT_END_D;
0442: InAcctFeatTerm.FEAT_VALU_X = InterVar0_34;
0443: NullSetVar0 = 0;
0444: if (null(InLndDeal.DEAL_MAT_DT)) {
0445: NullSetVar0 = 1;
0446: } else {
0447: InterVar0_35 = days_since_from_date(date_from_string(StageVar0_svMatDate) , StageVar0_svFromDate);
0448: InAcctFeatTerm.FEAT_VALU_Q = InterVar0_35;
0449: }
0450: InAcctFeatTerm.FEAT_VALU_Q = (NullSetVar0 == 1) ? set_null() : InAcctFeatTerm.FEAT_VALU_Q;
0451: InAcctFeatTerm.FEAT_VALU_A = set_null();
0452: InAcctFeatTerm.FEAT_VALU_R = set_null();
0453: NullSetVar0 = 0;
0454: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0455: NullSetVar0 = 1;
0456: } else {
0457: InAcctFeatTerm.EFFT_D = StageVar0_svEfftD;
0458: }
0459: InAcctFeatTerm.EFFT_D = (NullSetVar0 == 1) ? set_null() : InAcctFeatTerm.EFFT_D;
0460: InAcctFeatTerm.EXPY_D = StageVar0_svExpyD;
0461: InAcctFeatTerm.EROR_SEQN_I = InterVar0_23;
0462: InAcctFeatTerm.UPDATE_FG = InLndDeal.ACTION_FG;
0463: InAcctFeatTerm.CONV_M = InterVar0_31;
0464: InAcctFeatTerm.TABLE_NAME = InterVar0_32;
0465: InAcctFeatTerm.ACCT_I_LU = (StageVar0_svAcctI + InterVar0_36);
0466: writerecord 3;
0467: RowRejected0 = 0;
0468: }
0469: // evaluate constraint and columns for link: InAcctFeatFreq
0470: if (((((InLndDeal.ACTION_FG == InterVar0_16) || (StageVar0_ExpireAll == InterVar0_13)) || (StageVar0_AcctFeatFreqChge == InterVar0_13)) && (StageVar0_sv11AMCount == 0)))
0471: {
0472: InAcctFeatFreq.ACCT_I = StageVar0_svAcctI;
0473: InAcctFeatFreq.FEAT_I = InLndDeal.FREQ_FEAT_I;
0474: InAcctFeatFreq.ACCT_FEAT_STRT_D = date_from_string(StageVar0_svFromDate);
0475: NullSetVar0 = 0;
0476: if (null(InLndDeal.DEAL_MAT_DT)) {
0477: NullSetVar0 = 1;
0478: } else {
0479: InAcctFeatFreq.ACCT_FEAT_END_D = date_from_string(StageVar0_svMatDate);
0480: }
0481: InAcctFeatFreq.ACCT_FEAT_END_D = (NullSetVar0 == 1) ? set_null() : InAcctFeatFreq.ACCT_FEAT_END_D;
0482: InAcctFeatFreq.FEAT_VALU_X = InLndDeal.INT_FREQ;
0483: NullSetVar0 = 0;
0484: if (null(InLndDeal.DEAL_MAT_DT)) {
0485: NullSetVar0 = 1;
0486: } else {
0487: InterVar0_35 = days_since_from_date(date_from_string(StageVar0_svMatDate) , StageVar0_svFromDate);
0488: InAcctFeatFreq.FEAT_VALU_Q = InterVar0_35;
0489: }
0490: InAcctFeatFreq.FEAT_VALU_Q = (NullSetVar0 == 1) ? set_null() : InAcctFeatFreq.FEAT_VALU_Q;
0491: InAcctFeatFreq.FEAT_VALU_A = set_null();
0492: InAcctFeatFreq.FEAT_VALU_R = set_null();
0493: NullSetVar0 = 0;
0494: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0495: NullSetVar0 = 1;
0496: } else {
0497: InAcctFeatFreq.EFFT_D = StageVar0_svEfftD;
0498: }
0499: InAcctFeatFreq.EFFT_D = (NullSetVar0 == 1) ? set_null() : InAcctFeatFreq.EFFT_D;
0500: InAcctFeatFreq.EXPY_D = StageVar0_svExpyD;
0501: InAcctFeatFreq.EROR_SEQN_I = InterVar0_23;
0502: InAcctFeatFreq.UPDATE_FG = InLndDeal.ACTION_FG;
0503: InAcctFeatFreq.CONV_M = InterVar0_31;
0504: InAcctFeatFreq.TABLE_NAME = InterVar0_32;
0505: InAcctFeatFreq.ACCT_I_LU = (StageVar0_svAcctI + InterVar0_37);
0506: writerecord 4;
0507: RowRejected0 = 0;
0508: }
0509: // evaluate constraint and columns for link: InAcctBalnIntAcrd
0510: if (((((InLndDeal.ACTION_FG == InterVar0_16) && notnull(InLndDeal.INT_ACCRUED_SOP)) || ((StageVar0_ExpireAll == InterVar0_13) && notnull(InLndDeal.INT_ACCRUED_SOP))) || ((StageVar0_AcctBalnIntAccruedChge == InterVar0_13) && notnull(InLndDeal.INT_ACCRUED_SOP))))
0511: {
0512: InAcctBalnIntAcrd.ACCT_I = StageVar0_svAcctI;
0513: InAcctBalnIntAcrd.BALN_TYPE_C = StageVar0_svIntAcrdBalnTypeC;
0514: InAcctBalnIntAcrd.CALC_FUNC_C = InterVar0_26;
0515: InAcctBalnIntAcrd.TIME_PERD_C = InterVar0_12;
0516: NullSetVar0 = 0;
0517: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0518: NullSetVar0 = 1;
0519: } else {
0520: InAcctBalnIntAcrd.EFFT_D = StageVar0_svEfftD;
0521: }
0522: InAcctBalnIntAcrd.EFFT_D = (NullSetVar0 == 1) ? set_null() : InAcctBalnIntAcrd.EFFT_D;
0523: InAcctBalnIntAcrd.BALN_A = StageVar0_svBalnA4;
0524: InAcctBalnIntAcrd.CALC_F = InterVar0_14;
0525: InAcctBalnIntAcrd.EXPY_D = StageVar0_svExpyD;
0526: InAcctBalnIntAcrd.EROR_SEQN_I = InterVar0_23;
0527: InAcctBalnIntAcrd.UPDATE_FG = InLndDeal.ACTION_FG;
0528: InAcctBalnIntAcrd.CONV_M = InterVar0_27;
0529: InAcctBalnIntAcrd.TABLE_NAME = InterVar0_28;
0530: InAcctBalnIntAcrd.ACCT_I_LU = (StageVar0_svAcctI + InterVar0_38);
0531: writerecord 5;
0532: RowRejected0 = 0;
0533: }
0534: // evaluate constraint and columns for link: InAcctDept
0535: if (((((InLndDeal.ACTION_FG == InterVar0_16) && (InLndDeal.DEPT_I != InterVar0_39)) || ((StageVar0_ExpireAll == InterVar0_13) && (InLndDeal.DEPT_I != InterVar0_39))) || ((StageVar0_AcctDeptChge == InterVar0_13) && (InLndDeal.DEPT_I != InterVar0_39))))
0536: {
0537: InAcctDept.ACCT_I = StageVar0_svAcctI;
0538: InAcctDept.DEPT_ROLE_C = trimc_string(InLndDeal.DEPT_ROLE_C);
0539: NullSetVar0 = 0;
0540: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0541: NullSetVar0 = 1;
0542: } else {
0543: InAcctDept.EFFT_D = StageVar0_svEfftD;
0544: }
0545: InAcctDept.EFFT_D = (NullSetVar0 == 1) ? set_null() : InAcctDept.EFFT_D;
0546: InAcctDept.EXPY_D = StageVar0_svExpyD;
0547: InAcctDept.BRCH_N = trimc_string(InLndDeal.BRCH_N);
0548: InAcctDept.DEPT_I = trimc_string(InLndDeal.DEPT_I);
0549: InAcctDept.EROR_SEQN_I = InterVar0_23;
0550: InAcctDept.UPDATE_FG = InLndDeal.ACTION_FG;
0551: InAcctDept.CONV_M = InterVar0_40;
0552: InAcctDept.TABLE_NAME = InterVar0_41;
0553: writerecord 6;
0554: RowRejected0 = 0;
0555: }
0556: // evaluate constraint and columns for link: InAcctPdctGL
0557: if (((((InLndDeal.ACTION_FG == InterVar0_16) && (InLndDeal.MSA_ACCT_N != InterVar0_42)) || ((StageVar0_ExpireAll == InterVar0_13) && (InLndDeal.MSA_ACCT_N != InterVar0_42))) || ((StageVar0_AcctPdctGLChge == InterVar0_13) && (InLndDeal.MSA_ACCT_N != InterVar0_42))))
0558: {
0559: InAcctPdctGL.ACCT_I = StageVar0_svAcctI;
0560: NullSetVar0 = 0;
0561: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0562: NullSetVar0 = 1;
0563: } else {
0564: InAcctPdctGL.EFFT_D = StageVar0_svEfftD;
0565: }
0566: InAcctPdctGL.EFFT_D = (NullSetVar0 == 1) ? set_null() : InAcctPdctGL.EFFT_D;
0567: InAcctPdctGL.EXPY_D = StageVar0_svExpyD;
0568: InAcctPdctGL.MSA_ACCT_DR_I = InLndDeal.MSA_ACCT_N;
0569: InAcctPdctGL.MSA_ACCT_CR_I = InLndDeal.MSA_ACCT_N;
0570: InAcctPdctGL.EROR_SEQN_I = InterVar0_23;
0571: InAcctPdctGL.UPDATE_FG = InLndDeal.ACTION_FG;
0572: InAcctPdctGL.CONV_M = InterVar0_43;
0573: InAcctPdctGL.TABLE_NAME = InterVar0_44;
0574: writerecord 7;
0575: RowRejected0 = 0;
0576: }
0577: // evaluate constraint and columns for link: InAcctDeptCntl
0578: if (((((InLndDeal.ACTION_FG == InterVar0_16) && (InLndDeal.DEPT_I != InterVar0_39)) || ((StageVar0_ExpireAll == InterVar0_13) && (InLndDeal.DEPT_I != InterVar0_39))) || ((StageVar0_AcctDeptCntlChge == InterVar0_13) && (InLndDeal.DEPT_I != InterVar0_39))))
0579: {
0580: InAcctDeptCntl.ACCT_I = StageVar0_svAcctI;
0581: InAcctDeptCntl.DEPT_ROLE_C = InterVar0_45;
0582: NullSetVar0 = 0;
0583: if ((InLndDeal.ACTION_FG == InterVar0_5)) {
0584: NullSetVar0 = 1;
0585: } else {
0586: InAcctDeptCntl.EFFT_D = StageVar0_svEfftD;
0587: }
0588: InAcctDeptCntl.EFFT_D = (NullSetVar0 == 1) ? set_null() : InAcctDeptCntl.EFFT_D;
0589: InAcctDeptCntl.EXPY_D = StageVar0_svExpyD;
0590: InAcctDeptCntl.BRCH_N = trimc_string(InLndDeal.REFER_BY);
0591: InAcctDeptCntl.DEPT_I = trimc_string(InLndDeal.DEPT_I_CNTL);
0592: InAcctDeptCntl.EROR_SEQN_I = InterVar0_23;
0593: InAcctDeptCntl.UPDATE_FG = InLndDeal.ACTION_FG;
0594: InAcctDeptCntl.CONV_M = InterVar0_40;
0595: InAcctDeptCntl.TABLE_NAME = InterVar0_41;
0596: InAcctDeptCntl.ACCT_I_LU = (StageVar0_svAcctI + InterVar0_45);
0597: writerecord 8;
0598: RowRejected0 = 0;
0599: }
0600: }
0601:
0602: finish {
0603: }
0604:
*** End of Internal Generated Transformer Code
</a>