Page 1 of 1

Internal error

Posted: Fri Jan 18, 2008 5:35 am
by suresh_dsx
Hi,
The code is working fine in the server but not in the parallel transformer.
Iam unable to compile the job in parallel. If any one face the same error please share with me.

The compilation error:

Output from transformer compilation follows:

##I TFCN 000001 05:22:10(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TUTL 000031 05:22:10(001) <main_program> The open files limit is 2048; raising to 4096.
##I TOSH 000002 05:22:10(002) <main_program> orchgeneral: loaded
##I TOSH 000002 05:22:10(003) <main_program> orchsort: loaded
##I TOSH 000002 05:22:10(004) <main_program> orchstats: loaded
##I TFSC 000001 05:22:10(007) <main_program> APT configuration file: /dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 05:22:12(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (CopyOfElDataSetLoad.ACCT_STRUC)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V27S3_repos_ACCT_STRUC transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DI_OUTPUT_Lnk;
0007: outputname 0 PXI_SUBS_File;
0008:
0009: global {
0010: // Job parameter declaration
0011: string CoalChk;
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: decimal InterVar0_0;
0023: decimal InterVar0_1;
0024: string InterVar0_5;
0025: string InterVar0_6;
0026: decimal InterVar0_7;
0027: decimal InterVar0_10;
0028: int64 InterVar0_11;
0029: string InterVar0_12;
0030: string InterVar0_13;
0031: date InterVar0_14;
0032: string InterVar0_15;
0033: decimal InterVar0_18;
0034:
0035: // initialise constant values which require conversion
0036: InterVar0_0 = 0;
0037: InterVar0_1 = 999;
0038: InterVar0_5 = "";
0039: InterVar0_6 = "1700-01-01";
0040: InterVar0_7 = "0100-01-01";
0041: InterVar0_10 = "";
0042: InterVar0_11 = "";
0043: InterVar0_12 = "n/a";
0044: InterVar0_13 = "0100-01-01";
0045: InterVar0_14 = date_from_string("0100-01-01");
0046: InterVar0_15 = "0";
0047: InterVar0_18 = 1;
0048: // Stage variable declaration and initialisation
0049: decimal[10,0] StageVar0_AgeCalc;
0050: StageVar0_AgeCalc = InterVar0_0;
0051: decimal[10,0] StageVar0_AgeGendID;
0052: StageVar0_AgeGendID = InterVar0_0;
0053: decimal[10,0] StageVar0_NetCreditSvcDt;
0054: StageVar0_NetCreditSvcDt = InterVar0_0;
0055: }
0056:
0057: mainloop {
0058: // initialise our row rejected variable
0059: RowRejected0 = 1;
0060:
0061: // declare our intermediate variables for this section
0062: decimal InterVar0_2;
0063: string InterVar0_3;
0064: string InterVar0_4;
0065: decimal InterVar0_8;
0066: int64 InterVar0_9;
0067: string InterVar0_16;
0068: int32 InterVar0_17;
0069:
0070: // evaluate the stage variables first
0071: if (((DI_OUTPUT_Lnk.PERSON_AGE < 0) || (DI_OUTPUT_Lnk.PERSON_AGE > 999))) {
0072: StageVar0_AgeCalc = InterVar0_1;
0073: } else {
0074: InterVar0_2 = DI_OUTPUT_Lnk.PERSON_AGE;
0075: StageVar0_AgeCalc = InterVar0_2;
0076: }
0077: //;
0078: InterVar0_3 = StageVar0_AgeCalc;
0079: InterVar0_4 = DI_OUTPUT_Lnk.INGX_GENDER;
0080: StageVar0_AgeGendID = (InterVar0_3 + InterVar0_4);
0081: if (((trimc_string(DI_OUTPUT_Lnk.SUB_CREDIT_SVC_DT) == InterVar0_5) || (left_substring(DI_OUTPUT_Lnk.SUB_CREDIT_SVC_DT , 10) == InterVar0_6))) {
0082: if (notnull(DI_OUTPUT_Lnk.LkupCoverageEbdate)) {
0083: StageVar0_NetCreditSvcDt = InterVar0_7;
0084: } else {
0085: InterVar0_2 = DI_OUTPUT_Lnk.ELIG_BEGIN_DT;
0086: StageVar0_NetCreditSvcDt = InterVar0_2;
0087: }
0088: //;
0089: } else {
0090: InterVar0_8 = DI_OUTPUT_Lnk.SUB_CREDIT_SVC_DT;
0091: StageVar0_NetCreditSvcDt = InterVar0_8;
0092: }
0093: //;
0094:
0095: // evaluate columns (no constraints) for link: PXI_SUBS_File
0096: if (notnull(((DI_OUTPUT_Lnk.SUB_PERSON_ID == InterVar0_10) || null(DI_OUTPUT_Lnk.SUB_PERSON_ID)))) {
0097: InterVar0_9 = ((DI_OUTPUT_Lnk.SUB_PERSON_ID == InterVar0_10) || null(DI_OUTPUT_Lnk.SUB_PERSON_ID));
0098: } else {
0099: InterVar0_9 = InterVar0_11;
0100: }
0101: if (InterVar0_9) {
0102: PXI_SUBS_File.SUB_PERSON_ID = InterVar0_0;
0103: } else {
0104: PXI_SUBS_File.SUB_PERSON_ID = DI_OUTPUT_Lnk.SUB_PERSON_ID;
0105: }
0106: //;
0107: if (((DI_OUTPUT_Lnk.SUB_CUST_ID == InterVar0_5) || null(DI_OUTPUT_Lnk.SUB_CUST_ID))) {
0108: PXI_SUBS_File.SUB_CUST_ID = InterVar0_12;
0109: } else {
0110: PXI_SUBS_File.SUB_CUST_ID = DI_OUTPUT_Lnk.SUB_CUST_ID;
0111: }
0112: //;
0113: if (((trimc_string(DI_OUTPUT_Lnk.SUB_ZIP_CD) == InterVar0_5) || null(DI_OUTPUT_Lnk.SUB_ZIP_CD))) {
0114: PXI_SUBS_File.SUB_ZIP_CD = InterVar0_12;
0115: } else {
0116: PXI_SUBS_File.SUB_ZIP_CD = left_substring(DI_OUTPUT_Lnk.SUB_ZIP_CD , 5);
0117: }
0118: //;
0119: PXI_SUBS_File.SUB_ADDR_1 = InterVar0_12;
0120: PXI_SUBS_File.SUB_ADDR_2 = InterVar0_12;
0121: PXI_SUBS_File.SUB_DATA_SRCE_ID = InterVar0_12;
0122: if ((((trimc_string(DI_OUTPUT_Lnk.SUB_DOB) == InterVar0_5) || null(DI_OUTPUT_Lnk.SUB_DOB)) || (left_substring(DI_OUTPUT_Lnk.SUB_DOB , 10) == InterVar0_6))) {
0123: PXI_SUBS_File.SUB_DOB = InterVar0_13;
0124: } else {
0125: PXI_SUBS_File.SUB_DOB = left_substring(DI_OUTPUT_Lnk.SUB_DOB , 10);
0126: }
0127: //;
0128: PXI_SUBS_File.SUB_PH_NBR = InterVar0_12;
0129: if ((((trimc_string(string_from_timestamp(DI_OUTPUT_Lnk.SUB_HIRE_DT)) == InterVar0_5) || null(DI_OUTPUT_Lnk.SUB_HIRE_DT)) || (left_substring(string_from_timestamp(DI_OUTPUT_Lnk.SUB_HIRE_DT) , 10) == InterVar0_6))) {
0130: PXI_SUBS_File.SUB_HIRE_DT = InterVar0_14;
0131: } else {
0132: PXI_SUBS_File.SUB_HIRE_DT = date_from_string(left_substring(string_from_timestamp(DI_OUTPUT_Lnk.SUB_HIRE_DT) , 10));
0133: }
0134: //;
0135: if ((((trimc_string(string_from_timestamp(DI_OUTPUT_Lnk.SUB_RETIRE_DT)) == InterVar0_5) || null(DI_OUTPUT_Lnk.SUB_RETIRE_DT)) || (left_substring(string_from_timestamp(DI_OUTPUT_Lnk.SUB_RETIRE_DT) , 10) == InterVar0_6))) {
0136: PXI_SUBS_File.SUB_RETIRE_DT = InterVar0_14;
0137: } else {
0138: PXI_SUBS_File.SUB_RETIRE_DT = date_from_string(left_substring(string_from_timestamp(DI_OUTPUT_Lnk.SUB_RETIRE_DT) , 10));
0139: }
0140: //;
0141: if ((((trimc_string(DI_OUTPUT_Lnk.SUB_TERM_DT) == InterVar0_5) || null(DI_OUTPUT_Lnk.SUB_TERM_DT)) || (left_substring(DI_OUTPUT_Lnk.SUB_TERM_DT , 10) == InterVar0_6))) {
0142: PXI_SUBS_File.SUB_TERM_DT = InterVar0_14;
0143: } else {
0144: PXI_SUBS_File.SUB_TERM_DT = date_from_string(left_substring(DI_OUTPUT_Lnk.SUB_TERM_DT , 10));
0145: }
0146: //;
0147: if ((((trimc_string(string_from_timestamp(DI_OUTPUT_Lnk.SUB_DEATH_DT)) == InterVar0_5) || null(DI_OUTPUT_Lnk.SUB_DEATH_DT)) || (left_substring(string_from_timestamp(DI_OUTPUT_Lnk.SUB_DEATH_DT) , 10) == InterVar0_6))) {
0148: PXI_SUBS_File.SUB_DEATH_DT = InterVar0_14;
0149: } else {
0150: PXI_SUBS_File.SUB_DEATH_DT = date_from_string(left_substring(string_from_timestamp(DI_OUTPUT_Lnk.SUB_DEATH_DT) , 10));
0151: }
0152: //;
0153: PXI_SUBS_File.SUB_CREATE_SYS_IND = InterVar0_15;
0154: InterVar0_3 = StageVar0_NetCreditSvcDt;
0155: InterVar0_4 = StageVar0_NetCreditSvcDt;
0156: if ((((trimc_string(InterVar0_3) == InterVar0_5) || null(StageVar0_NetCreditSvcDt)) || (left_substring(InterVar0_4 , 10) == InterVar0_6))) {
0157: PXI_SUBS_File.NET_CREDIT_SVC_DT = InterVar0_13;
0158: } else {
0159: InterVar0_16 = StageVar0_NetCreditSvcDt;
0160: PXI_SUBS_File.NET_CREDIT_SVC_DT = left_substring(InterVar0_16 , 10);
0161: }
0162: //;
0163: if ((((trimc_string(string_from_timestamp(DI_OUTPUT_Lnk.SUB_REHIRE_DT)) == InterVar0_5) || null(DI_OUTPUT_Lnk.SUB_REHIRE_DT)) || (left_substring(string_from_timestamp(DI_OUTPUT_Lnk.SUB_REHIRE_DT) , 10) == InterVar0_6))) {
0164: PXI_SUBS_File.REHIRE_DT = InterVar0_14;
0165: } else {
0166: PXI_SUBS_File.REHIRE_DT = date_from_string(left_substring(string_from_timestamp(DI_OUTPUT_Lnk.SUB_REHIRE_DT) , 10));
0167: }
0168: //;
0169: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_MARITAL_STATUS_CD;
0170: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_MARITAL_STATUS_CD))) {
0171: PXI_SUBS_File.CURRENT_MARITAL_STATUS_CD = InterVar0_0;
0172: } else {
0173: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_MARITAL_STATUS_CD;
0174: InterVar0_2 = trimc_string(InterVar0_4);
0175: PXI_SUBS_File.CURRENT_MARITAL_STATUS_CD = InterVar0_2;
0176: }
0177: //;
0178: InterVar0_3 = StageVar0_AgeGendID;
0179: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(StageVar0_AgeGendID))) {
0180: PXI_SUBS_File.CURRENT_AGEGEND_ID = 9990;
0181: } else {
0182: InterVar0_4 = StageVar0_AgeGendID;
0183: InterVar0_17 = trimc_string(InterVar0_4);
0184: PXI_SUBS_File.CURRENT_AGEGEND_ID = InterVar0_17;
0185: }
0186: //;
0187: if (((trimc_string(DI_OUTPUT_Lnk.PXI_BUS_UNIT) == InterVar0_5) || null(DI_OUTPUT_Lnk.PXI_BUS_UNIT))) {
0188: PXI_SUBS_File.CURRENT_BUS_UNIT = InterVar0_12;
0189: } else {
0190: PXI_SUBS_File.CURRENT_BUS_UNIT = trimc_string(DI_OUTPUT_Lnk.PXI_BUS_UNIT);
0191: }
0192: //;
0193: if (((trimc_string(DI_OUTPUT_Lnk.PXI_EMP_STAT) == InterVar0_5) || null(DI_OUTPUT_Lnk.PXI_EMP_STAT))) {
0194: PXI_SUBS_File.CURRENT_EMP_STAT = InterVar0_12;
0195: } else {
0196: PXI_SUBS_File.CURRENT_EMP_STAT = trimc_string(DI_OUTPUT_Lnk.PXI_EMP_STAT);
0197: }
0198: //;
0199: if (((trimc_string(DI_OUTPUT_Lnk.PXI_EMP_TYP) == InterVar0_5) || null(DI_OUTPUT_Lnk.PXI_EMP_TYP))) {
0200: PXI_SUBS_File.CURRENT_EMP_TYP = InterVar0_12;
0201: } else {
0202: PXI_SUBS_File.CURRENT_EMP_TYP = trimc_string(DI_OUTPUT_Lnk.PXI_EMP_TYP);
0203: }
0204: //;
0205: if (((trimc_string(DI_OUTPUT_Lnk.PXI_WORK_LOC) == InterVar0_5) || null(DI_OUTPUT_Lnk.PXI_WORK_LOC))) {
0206: PXI_SUBS_File.CURRENT_WORK_LOC = InterVar0_12;
0207: } else {
0208: PXI_SUBS_File.CURRENT_WORK_LOC = trimc_string(DI_OUTPUT_Lnk.PXI_WORK_LOC);
0209: }
0210: //;
0211: if (((trimc_string(DI_OUTPUT_Lnk.CURRENT_UNION_CD) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_UNION_CD))) {
0212: PXI_SUBS_File.CURRENT_UNION_CD = InterVar0_12;
0213: } else {
0214: PXI_SUBS_File.CURRENT_UNION_CD = left_substring(DI_OUTPUT_Lnk.CURRENT_UNION_CD , 7);
0215: }
0216: //;
0217: if (((trimc_string(DI_OUTPUT_Lnk.CURRENT_JOB_CD) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_JOB_CD))) {
0218: PXI_SUBS_File.CURRENT_JOB_CD = InterVar0_12;
0219: } else {
0220: PXI_SUBS_File.CURRENT_JOB_CD = trimc_string(DI_OUTPUT_Lnk.CURRENT_JOB_CD);
0221: }
0222: //;
0223: if (((trimc_string(DI_OUTPUT_Lnk.CURRENT_SIC_CD) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_SIC_CD))) {
0224: PXI_SUBS_File.CURRENT_SIC_CD = InterVar0_12;
0225: } else {
0226: PXI_SUBS_File.CURRENT_SIC_CD = trimc_string(DI_OUTPUT_Lnk.CURRENT_SIC_CD);
0227: }
0228: //;
0229: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_NAICS_CD;
0230: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_NAICS_CD))) {
0231: PXI_SUBS_File.CURRENT_NAICS_CD = InterVar0_12;
0232: } else {
0233: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_NAICS_CD;
0234: PXI_SUBS_File.CURRENT_NAICS_CD = left_substring(InterVar0_4 , 7);
0235: }
0236: //;
0237: if (((trimc_string(DI_OUTPUT_Lnk.CURRENT_SUPERVISOR_ID) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_SUPERVISOR_ID))) {
0238: PXI_SUBS_File.CURRENT_SUPERVISOR_ID = InterVar0_12;
0239: } else {
0240: PXI_SUBS_File.CURRENT_SUPERVISOR_ID = trimc_string(DI_OUTPUT_Lnk.CURRENT_SUPERVISOR_ID);
0241: }
0242: //;
0243: if (((trimc_string(DI_OUTPUT_Lnk.CURRENT_FULL_TIME_INDICATOR_CD) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_FULL_TIME_INDICATOR_CD))) {
0244: PXI_SUBS_File.CURRENT_FULL_TIME_INDICATOR_CD = InterVar0_0;
0245: } else {
0246: InterVar0_2 = trimc_string(DI_OUTPUT_Lnk.CURRENT_FULL_TIME_INDICATOR_CD);
0247: PXI_SUBS_File.CURRENT_FULL_TIME_INDICATOR_CD = InterVar0_2;
0248: }
0249: //;
0250: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_EXEMPT_STAT_CD;
0251: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_EXEMPT_STAT_CD))) {
0252: PXI_SUBS_File.CURRENT_EXEMPT_STAT_CD = InterVar0_0;
0253: } else {
0254: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_EXEMPT_STAT_CD;
0255: InterVar0_2 = trimc_string(InterVar0_4);
0256: PXI_SUBS_File.CURRENT_EXEMPT_STAT_CD = InterVar0_2;
0257: }
0258: //;
0259: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_MOD_RESTRICT_DUTY_CD;
0260: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_MOD_RESTRICT_DUTY_CD))) {
0261: PXI_SUBS_File.CURRENT_MOD_RESTRICT_DUTY_CD = InterVar0_0;
0262: } else {
0263: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_MOD_RESTRICT_DUTY_CD;
0264: InterVar0_2 = trimc_string(InterVar0_4);
0265: PXI_SUBS_File.CURRENT_MOD_RESTRICT_DUTY_CD = InterVar0_2;
0266: }
0267: //;
0268: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_EARN_AMT_CATEGORY_CD;
0269: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_EARN_AMT_CATEGORY_CD))) {
0270: PXI_SUBS_File.CURRENT_EARN_AMT_CATEGORY_CD = InterVar0_0;
0271: } else {
0272: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_EARN_AMT_CATEGORY_CD;
0273: InterVar0_2 = trimc_string(InterVar0_4);
0274: PXI_SUBS_File.CURRENT_EARN_AMT_CATEGORY_CD = InterVar0_2;
0275: }
0276: //;
0277: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_SUPERVISOR_IND_CD;
0278: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_SUPERVISOR_IND_CD))) {
0279: PXI_SUBS_File.CURRENT_SUPERVISOR_IND_CD = InterVar0_0;
0280: } else {
0281: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_SUPERVISOR_IND_CD;
0282: InterVar0_2 = trimc_string(InterVar0_4);
0283: PXI_SUBS_File.CURRENT_SUPERVISOR_IND_CD = InterVar0_2;
0284: }
0285: //;
0286: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_ALLOTMENT_CD;
0287: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_ALLOTMENT_CD))) {
0288: PXI_SUBS_File.CURRENT_ALLOTMENT_CD = InterVar0_0;
0289: } else {
0290: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_ALLOTMENT_CD;
0291: InterVar0_2 = trimc_string(InterVar0_4);
0292: PXI_SUBS_File.CURRENT_ALLOTMENT_CD = InterVar0_2;
0293: }
0294: //;
0295: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_LEN_SERVICE_YEARS;
0296: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_LEN_SERVICE_YEARS))) {
0297: PXI_SUBS_File.CURRENT_LEN_SERVICE_YEARS = InterVar0_0;
0298: } else {
0299: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_LEN_SERVICE_YEARS;
0300: InterVar0_2 = trimc_string(InterVar0_4);
0301: PXI_SUBS_File.CURRENT_LEN_SERVICE_YEARS = InterVar0_2;
0302: }
0303: //;
0304: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_LEN_SERV_CATEGORY_CD;
0305: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_LEN_SERV_CATEGORY_CD))) {
0306: PXI_SUBS_File.CURRENT_LEN_SERV_CATEGORY_CD = InterVar0_0;
0307: } else {
0308: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_LEN_SERV_CATEGORY_CD;
0309: InterVar0_2 = trimc_string(InterVar0_4);
0310: PXI_SUBS_File.CURRENT_LEN_SERV_CATEGORY_CD = InterVar0_2;
0311: }
0312: //;
0313: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_WORK_WK_SCH_HOURS_AMT;
0314: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_WORK_WK_SCH_HOURS_AMT))) {
0315: PXI_SUBS_File.CURRENT_WORK_WK_SCH_HOURS_AMT = InterVar0_0;
0316: } else {
0317: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_WORK_WK_SCH_HOURS_AMT;
0318: InterVar0_2 = trimc_string(InterVar0_4);
0319: PXI_SUBS_File.CURRENT_WORK_WK_SCH_HOURS_AMT = InterVar0_2;
0320: }
0321: //;
0322: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_VAC_ALLOT_DAYS_AMT;
0323: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_VAC_ALLOT_DAYS_AMT))) {
0324: PXI_SUBS_File.CURRENT_VAC_ALLOT_DAYS_AMT = InterVar0_0;
0325: } else {
0326: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_VAC_ALLOT_DAYS_AMT;
0327: InterVar0_2 = trimc_string(InterVar0_4);
0328: PXI_SUBS_File.CURRENT_VAC_ALLOT_DAYS_AMT = InterVar0_2;
0329: }
0330: //;
0331: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_SICK_ALLOT_DAYS_AMT;
0332: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_SICK_ALLOT_DAYS_AMT))) {
0333: PXI_SUBS_File.CURRENT_SICK_ALLOT_DAYS_AMT = InterVar0_0;
0334: } else {
0335: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_SICK_ALLOT_DAYS_AMT;
0336: InterVar0_2 = trimc_string(InterVar0_4);
0337: PXI_SUBS_File.CURRENT_SICK_ALLOT_DAYS_AMT = InterVar0_2;
0338: }
0339: //;
0340: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_PTO_ALLOTMENT_AMT;
0341: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_PTO_ALLOTMENT_AMT))) {
0342: PXI_SUBS_File.CURRENT_PTO_ALLOTMENT_AMT = InterVar0_0;
0343: } else {
0344: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_PTO_ALLOTMENT_AMT;
0345: InterVar0_2 = trimc_string(InterVar0_4);
0346: PXI_SUBS_File.CURRENT_PTO_ALLOTMENT_AMT = InterVar0_2;
0347: }
0348: //;
0349: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_ANNUAL_SALARY_AMT;
0350: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_ANNUAL_SALARY_AMT))) {
0351: PXI_SUBS_File.CURRENT_ANNUAL_SALARY_AMT = InterVar0_0;
0352: } else {
0353: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_ANNUAL_SALARY_AMT;
0354: InterVar0_2 = trimc_string(InterVar0_4);
0355: PXI_SUBS_File.CURRENT_ANNUAL_SALARY_AMT = InterVar0_2;
0356: }
0357: //;
0358: InterVar0_3 = DI_OUTPUT_Lnk.CURRENT_FTE_EQUIVALENCY_RATE;
0359: if (((trimc_string(InterVar0_3) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_FTE_EQUIVALENCY_RATE))) {
0360: PXI_SUBS_File.CURRENT_FTE_EQUIVALENCY_RATE = InterVar0_0;
0361: } else {
0362: InterVar0_4 = DI_OUTPUT_Lnk.CURRENT_FTE_EQUIVALENCY_RATE;
0363: InterVar0_2 = trimc_string(InterVar0_4);
0364: PXI_SUBS_File.CURRENT_FTE_EQUIVALENCY_RATE = InterVar0_2;
0365: }
0366: //;
0367: if (((trimc_string(DI_OUTPUT_Lnk.CURRENT_SUB_WORK_LOC_ZIP_CD) == InterVar0_5) || null(DI_OUTPUT_Lnk.CURRENT_SUB_WORK_LOC_ZIP_CD))) {
0368: PXI_SUBS_File.CURRENT_SUB_WORK_LOC_ZIP_CD = InterVar0_12;
0369: } else {
0370: PXI_SUBS_File.CURRENT_SUB_WORK_LOC_ZIP_CD = left_substring(DI_OUTPUT_Lnk.CURRENT_SUB_WORK_LOC_ZIP_CD , 5);
0371: }
0372: //;
0373: PXI_SUBS_File.SUB_ADD_DT = date_from_string(left_substring(DI_OUTPUT_Lnk.RMRM_POSTED_DT2 , 10));
0374: PXI_SUBS_File.RELATION = InterVar0_18;
0375: PXI_SUBS_File.RUN_ID = DI_OUTPUT_Lnk.RUN_ID;
0376: PXI_SUBS_File.COCL_FLG = CoalChk;
0377: PXI_SUBS_File.UNSCRAMBLED_SUB_PERSON_ID = DI_OUTPUT_Lnk.SUB_PERS_ID;
0378: writerecord 0;
0379: RowRejected0 = 0;
0380: }
0381:
0382: finish {
0383: }
0384:
*** End of Internal Generated Transformer Code

Thanks and Regards,
Suresh D

Posted: Fri Jan 18, 2008 5:59 am
by ray.wurlod
There's no error in any of that.

Error messages begin with ##E.