Parallel Transformer Compilation 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
kumar3846
Participant
Posts: 36
Joined: Mon Jan 09, 2006 2:58 pm

Parallel Transformer Compilation Error

Post by kumar3846 »

Hi all,

Can you guys please help me what exactly this error means and i am not able to figured it out the causing issue, please reply your valuble suggestions.

Here is the Error Log ,

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 16:40:16(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5000
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 16:40:16(001) <main_program> conductor uname: -s=Linux; -r=2.6.9-67.ELsmp; -v=#1 SMP Wed Nov 7 13:58:04 EST 2007; -n=SVAMN14GLBSMU7.nc.us.bank-dns.com; -m=i686
##I IIS-DSEE-TOSH-00002 16:40:16(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 16:40:16(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 16:40:16(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 16:40:16(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 16:40:18(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256.
##E IIS-DSEE-TFSR-00019 16:40:18(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 16:40:18(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W IIS-DSEE-TFEV-00025 16:40:18(003) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(005) <transform> Error when checking composite operator: Converting number to string.
##W IIS-DSEE-TFEV-00023 16:40:18(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W IIS-DSEE-TFEV-00025 16:40:18(007) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(008) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(009) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(010) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(011) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(012) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(013) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(014) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(015) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(016) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(017) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(018) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(019) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(020) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(021) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(022) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(023) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(024) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(025) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(026) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(027) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(028) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(029) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(030) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(031) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(032) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(033) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(034) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(035) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(036) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(037) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(038) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(039) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(040) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(041) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(042) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(043) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(044) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(045) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(046) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(047) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(048) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(049) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(050) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(051) <transform> Error when checking composite operator: Possible range limitation.
##W IIS-DSEE-TFEV-00023 16:40:18(052) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 16:40:18(053) <transform> Error when checking composite operator: Converting string to decimal.
##W IIS-DSEE-TFEV-00023 16:40:18(054) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W IIS-DSEE-TBLD-00000 16:40:18(055) <main_program> Error when checking composite operator: Output from subprocess: /opt/IBM/InformationServer/Server/Projects/Dev_Mellon/RT_BP667.O/V0S16_CopyOfCopyOfDDA_Santosh_Transform_005.C:722:38:
##W IIS-DSEE-TBLD-00000 16:40:18(056) <main_program> Error when checking composite operator: Output from subprocess: invalid digit "9" in octal constant
/opt/IBM/InformationServer/Server/Projects/Dev_Mellon/RT_BP667.O/V0S16_CopyOfCopyOfDDA_Santosh_Transform_005.C:723:38: invalid digit "8" in octal constant
/opt/IBM/InformationServer/Server/Projects/Dev_Mellon/RT_BP667.O/V0S16_CopyOfCopyOfDDA_Santosh_Transform_005.C:724:38: invalid digit "9" in octal constant

##I IIS-DSEE-TBLD-00079 16:40:18(057) <transform> Error when checking composite operator: g++ -fPIC -O -I/opt/IBM/InformationServer/Server/PXEngine/include -O -fPIC -Wno-deprecated -c /opt/IBM/InformationServer/Server/Projects/Dev_Mellon/RT_BP667.O/V0S16_CopyOfCopyOfDDA_Santosh_Transform_005.C -o /opt/IBM/InformationServer/Server/Projects/Dev_Mellon/RT_BP667.O/V0S16_CopyOfCopyOfDDA_Santosh_Transform_005.tmp.o.
##E IIS-DSEE-TCOS-00029 16:40:18(058) <main_program> Creation of a step finished with status = FAILED. (CopyOfCopyOfDDA_Santosh.Transform_005)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S16_CopyOfCopyOfDDA_Santosh_Transform_005 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 Link_DEPOSIT_CHECKING_USBNDAOUT;
0007: outputname 0 Link_Transform_005_Join_001;
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: decimal InterVar0_0;
0018: string InterVar0_1;
0019: string InterVar0_2;
0020: decimal InterVar0_3;
0021: decimal InterVar0_4;
0022: decimal InterVar0_5;
0023: decimal InterVar0_6;
0024: decimal InterVar0_7;
0025: decimal InterVar0_8;
0026: decimal InterVar0_9;
0027: decimal InterVar0_10;
0028: decimal InterVar0_11;
0029: decimal InterVar0_12;
0030: decimal InterVar0_13;
0031: decimal InterVar0_14;
0032: decimal InterVar0_15;
0033: decimal InterVar0_16;
0034: decimal InterVar0_17;
0035: decimal InterVar0_18;
0036: decimal InterVar0_19;
0037: decimal InterVar0_20;
0038: decimal InterVar0_21;
0039: decimal InterVar0_22;
0040: string InterVar0_23;
0041: string InterVar0_24;
0042: decimal InterVar0_25;
0043: string InterVar0_26;
0044: string InterVar0_27;
0045: string InterVar0_28;
0046: string InterVar0_29;
0047: string InterVar0_30;
0048: decimal InterVar0_31;
0049: string InterVar0_32;
0050: string InterVar0_33;
0051: decimal InterVar0_34;
0052: string InterVar0_35;
0053: string InterVar0_36;
0054: decimal InterVar0_37;
0055:
0056: // initialise constant values which require conversion
0057: InterVar0_0 = 3;
0058: InterVar0_1 = 07;
0059: InterVar0_2 = "99";
0060: InterVar0_3 = 200;
0061: InterVar0_4 = 5831;
0062: InterVar0_5 = 55;
0063: InterVar0_6 = 169;
0064: InterVar0_7 = 170;
0065: InterVar0_8 = 181;
0066: InterVar0_9 = 186;
0067: InterVar0_10 = 190;
0068: InterVar0_11 = 333;
0069: InterVar0_12 = 356;
0070: InterVar0_13 = 5993;
0071: InterVar0_14 = 00999;
0072: InterVar0_15 = 0015831;
0073: InterVar0_16 = 0015993;
0074: InterVar0_17 = 0;
0075: InterVar0_18 = 70;
0076: InterVar0_19 = 71;
0077: InterVar0_20 = 75;
0078: InterVar0_21 = 606;
0079: InterVar0_22 = 621;
0080: InterVar0_23 = "44";
0081: InterVar0_24 = "92";
0082: InterVar0_25 = 780101;
0083: InterVar0_26 = "Y";
0084: InterVar0_27 = "N";
0085: InterVar0_28 = "05993";
0086: InterVar0_29 = "05831";
0087: InterVar0_30 = "0";
0088: InterVar0_31 = 6;
0089: InterVar0_32 = "02";
0090: InterVar0_33 = "04";
0091: InterVar0_34 = 7;
0092: InterVar0_35 = "82";
0093: InterVar0_36 = " ";
0094: InterVar0_37 = "";
0095: }
0096:
0097: mainloop {
0098: // initialise our row rejected variable
0099: RowRejected0 = 1;
0100:
0101: // evaluate columns (no constraints) for link: Link_Transform_005_Join_001
0102: Link_Transform_005_Join_001.OUTND_APPL_CODE = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_TYPE;
0103: Link_Transform_005_Join_001.OUTND_IMAGE_PER_PAGE = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TRUNCATE_CODE;
0104: Link_Transform_005_Join_001.OUTND_MAIL_CODE = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TRUNCATE_CODE;
0105: Link_Transform_005_Join_001.OUTND_RATE_INDEX_NBR = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_TYPE;
0106: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_STATUS == InterVar0_0)) {
0107: Link_Transform_005_Join_001.MCI_DM_ACT_STATUS = InterVar0_1;
0108: } else {
0109: Link_Transform_005_Join_001.MCI_DM_ACT_STATUS = InterVar0_2;
0110: }
0111: //;
0112: Link_Transform_005_Join_001.MCI_DM_AMT_LAST_INT_ACCR = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCRUED_INT;
0113: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_01 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL;
0114: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_02 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_2;
0115: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_03 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_3;
0116: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_04 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_4;
0117: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_05 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_5;
0118: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_06 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_6;
0119: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_07 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_7;
0120: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_08 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_8;
0121: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_09 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_9;
0122: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_10 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_10;
0123: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_11 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_11;
0124: Link_Transform_005_Join_001.MCI_DM_AVG_COLL_BAL_PC_12 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_12;
0125: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_01 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL;
0126: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_02 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_2;
0127: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_03 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_3;
0128: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_04 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_4;
0129: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_05 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_5;
0130: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_06 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_6;
0131: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_07 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_7;
0132: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_08 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_8;
0133: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_09 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_9;
0134: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_10 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_10;
0135: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_11 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_11;
0136: Link_Transform_005_Join_001.MCI_DM_AVG_LDGR_BAL_PC_12 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_SC_AVGBAL_12;
0137: Link_Transform_005_Join_001.MCI_DM_BAL_AFTER_INT_PYMT = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0138: Link_Transform_005_Join_001.MCI_DM_BAL_LAST_STMT = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0139: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_3)) {
0140: Link_Transform_005_Join_001.MCI_DM_BRANCH_NO = InterVar0_4;
0141: } else {
0142: if (((((((((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_5) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_6)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_7)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_8)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_9)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_10)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_11)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_12))) {
0143: Link_Transform_005_Join_001.MCI_DM_BRANCH_NO = InterVar0_13;
0144: } else {
0145: Link_Transform_005_Join_001.MCI_DM_BRANCH_NO = InterVar0_14;
0146: }
0147: //;
0148: }
0149: //;
0150: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_3)) {
0151: Link_Transform_005_Join_001.MCI_DM_COST_CENTER = InterVar0_15;
0152: } else {
0153: if (((((((((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_5) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_6)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_7)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_8)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_9)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_10)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_11)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_12))) {
0154: Link_Transform_005_Join_001.MCI_DM_COST_CENTER = InterVar0_16;
0155: } else {
0156: Link_Transform_005_Join_001.MCI_DM_COST_CENTER = InterVar0_17;
0157: }
0158: //;
0159: }
0160: //;
0161: if ((((((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_18) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_19)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_20)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_21)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_22))) {
0162: Link_Transform_005_Join_001.MCI_DM_CO_ID = InterVar0_23;
0163: } else {
0164: Link_Transform_005_Join_001.MCI_DM_CO_ID = InterVar0_24;
0165: }
0166: //;
0167: Link_Transform_005_Join_001.MCI_DM_CURR_BAL = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0168: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_STATUS == InterVar0_0)) {
0169: Link_Transform_005_Join_001.MCI_DM_CURR_COLL_BAL = InterVar0_17;
0170: } else {
0171: Link_Transform_005_Join_001.MCI_DM_CURR_COLL_BAL = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0172: }
0173: //;
0174: Link_Transform_005_Join_001.MCI_DM_DAILY_COLL_BAL_PD_01 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0175: Link_Transform_005_Join_001.MCI_DM_DAILY_COLL_BAL_PD_02 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0176: Link_Transform_005_Join_001.MCI_DM_DAILY_COLL_BAL_PD_03 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0177: Link_Transform_005_Join_001.MCI_DM_DAILY_CURR_BAL_PD_01 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0178: Link_Transform_005_Join_001.MCI_DM_DAILY_CURR_BAL_PD_02 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0179: Link_Transform_005_Join_001.MCI_DM_DAILY_CURR_BAL_PD_03 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0180: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_STATUS == InterVar0_0)) {
0181: Link_Transform_005_Join_001.MCI_DM_DATE_CLOSED = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_OTHER_DT_1;
0182: } else {
0183: if (notnull(Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_STATUS)) {
0184: Link_Transform_005_Join_001.MCI_DM_DATE_CLOSED = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_DT_LAST_ACT_MAX;
0185: } else {
0186: Link_Transform_005_Join_001.MCI_DM_DATE_CLOSED = InterVar0_17;
0187: }
0188: //;
0189: }
0190: //;
0191: Link_Transform_005_Join_001.MCI_DM_DATE_LAST_CONTACT = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_DORM_DT;
0192: Link_Transform_005_Join_001.MCI_DM_DATE_LAST_DEP = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_DT_LAST_DEP;
0193: Link_Transform_005_Join_001.MCI_DM_DATE_LAST_DIR_DEP = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACH_LAST_DEP;
0194: Link_Transform_005_Join_001.MCI_DM_DATE_LAST_DR_CR = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_DT_LAST_ACT;
0195: Link_Transform_005_Join_001.MCI_DM_DATE_LAST_MAINT = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_DT_LAST_FM;
0196: Link_Transform_005_Join_001.MCI_DM_DATE_LAST_TRAN = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_DT_LAST_ACT;
0197: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL < InterVar0_17)) {
0198: Link_Transform_005_Join_001.MCI_DM_DATE_OD = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_OD_DATE;
0199: } else {
0200: Link_Transform_005_Join_001.MCI_DM_DATE_OD = InterVar0_17;
0201: }
0202: //;
0203: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_OPENING_DT > InterVar0_25)) {
0204: Link_Transform_005_Join_001.MCI_DM_DATE_OPENED = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_OPENING_DT;
0205: } else {
0206: Link_Transform_005_Join_001.MCI_DM_DATE_OPENED = InterVar0_25;
0207: }
0208: //;
0209: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_STATUS == InterVar0_0)) {
0210: Link_Transform_005_Join_001.MCI_DM_GEN_1203_FLAG = InterVar0_26;
0211: } else {
0212: Link_Transform_005_Join_001.MCI_DM_GEN_1203_FLAG = InterVar0_27;
0213: }
0214: //;
0215: if ((notnull(Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_INT_RATE) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_INT_RATE != InterVar0_17))) {
0216: Link_Transform_005_Join_001.MCI_DM_GEN_1236_FLAG = InterVar0_26;
0217: } else {
0218: Link_Transform_005_Join_001.MCI_DM_GEN_1236_FLAG = InterVar0_27;
0219: }
0220: //;
0221: Link_Transform_005_Join_001.MCI_DM_HIGH_BAL = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0222: Link_Transform_005_Join_001.MCI_DM_INT_PAID_PRIOR_YR = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_YTD_INT;
0223: Link_Transform_005_Join_001.MCI_DM_INT_PAID_YTD = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_YTD_INT;
0224: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_1 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_5;
0225: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_10 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_8;
0226: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_11 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_7;
0227: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_12 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_6;
0228: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_2 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_4;
0229: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_3 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_3;
0230: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_4 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_2;
0231: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_6 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_12;
0232: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_7 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_11;
0233: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_8 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_10;
0234: Link_Transform_005_Join_001.MCI_DM_ITEMS_NSF_CYC_9 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_TIMES_NSF_9;
0235: Link_Transform_005_Join_001.MCI_DM_LOW_BAL = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0236: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_3)) {
0237: Link_Transform_005_Join_001.MCI_DM_OFFICER = InterVar0_28;
0238: } else {
0239: if (((((((((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_5) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_6)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_7)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_8)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_9)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_10)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_11)) || (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ORIG_BR == InterVar0_12))) {
0240: Link_Transform_005_Join_001.MCI_DM_OFFICER = InterVar0_29;
0241: } else {
0242: Link_Transform_005_Join_001.MCI_DM_OFFICER = InterVar0_30;
0243: }
0244: //;
0245: }
0246: //;
0247: Link_Transform_005_Join_001.MCI_DM_OPENING_DEP = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_OPENING_AMT;
0248: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_MAIL_CODE == InterVar0_31)) {
0249: Link_Transform_005_Join_001.MCI_DM_STMT_FORM_MEDIA = InterVar0_32;
0250: } else {
0251: Link_Transform_005_Join_001.MCI_DM_STMT_FORM_MEDIA = InterVar0_33;
0252: }
0253: //;
0254: if ((Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_MAIL_CODE == InterVar0_34)) {
0255: Link_Transform_005_Join_001.MCI_DM_STMT_MAIL_CODE = InterVar0_35;
0256: } else {
0257: Link_Transform_005_Join_001.MCI_DM_STMT_MAIL_CODE = InterVar0_36;
0258: }
0259: //;
0260: if ((notnull(Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_YTD_INT) && notnull(Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_YTD_INT))) {
0261: Link_Transform_005_Join_001.MCI_DM_TOTAL_INTEREST_PAID = (Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_PREV_YTD_INT + Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_YTD_INT);
0262: } else {
0263: Link_Transform_005_Join_001.MCI_DM_TOTAL_INTEREST_PAID = InterVar0_37;
0264: }
0265: //;
0266: Link_Transform_005_Join_001.MCI_USBC_DATE_OF_LAST_CONTACT = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_DORM_DT;
0267: Link_Transform_005_Join_001.MCI_USBC_OPENING_COLLECTED_BAL = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0268: Link_Transform_005_Join_001.MCI_USBC_OPENING_LEDGER_BAL = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_BAL;
0269: Link_Transform_005_Join_001.joinKey0 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_NBR;
0270: Link_Transform_005_Join_001.joinKey1 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_NBR;
0271: Link_Transform_005_Join_001.joinKey2 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_TYPE;
0272: Link_Transform_005_Join_001.joinKey4 = Link_DEPOSIT_CHECKING_USBNDAOUT.OUTND_ACCT_NBR;
0273: writerecord 0;
0274: RowRejected0 = 0;
0275: }
0276:
0277: finish {
0278: }
0279:
*** End of Internal Generated Transformer Code
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 »

You can not use 8 or 9 in octal constants.
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
kumar3846
Participant
Posts: 36
Joined: Mon Jan 09, 2006 2:58 pm

Post by kumar3846 »

ray.wurlod wrote:You can not use 8 or 9 in octal constants. ...

Hi Ray,

Thanks for your response and , can you please tell me what is this octal constant because i am not assigning any values like 8 or 9 in my logic and i am also getting compilation error with out that ocatl constant error.
Top
datastage_learner
Participant
Posts: 15
Joined: Thu May 07, 2009 9:50 pm

Post by datastage_learner »

K3486... dude have you created any transformer stage variables...? Make sure to use proper datatypes for them and set proper metadata too in transformer
Thanks,
DS_Learner
Top
Post Reply

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