Internal error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
suresh_dsx
Participant
Posts: 160
Joined: Tue May 02, 2006 7:49 am

Internal error

Post 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
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

There's no error in any of that.

Error messages begin with ##E.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”