DataStage Errors
Posted: Thu May 04, 2006 8:52 am
I have a job where I have an Oracle Enterprise Stage->Surrogate Key Stage->Transformer->Oracle Enterprise Stage. In my transformer I am converting integer values into dates the format is YYYYDDD. In my derivation I am using the following:
if DSLink26.CIRAMST_DATE_LAST_BNOTICE =0 then setnull() else DateFromDaysSince(DSLink26.CIRAMST_DATE_LAST_BNOTICE[5,3],StringtoDate(DSLink26.CIRAMST_DATE_LAST_BNOTICE[1,4]:"-01-01"))
The job compiles fine up to a point. The source table has many columns as I add more columns as I am testing I get a transformer error:
Output from transformer compilation follows:
##I TFCN 000001 10:52:14(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 10:52:14(001) <main_program> orchgeneral: loaded
##I TOSH 000002 10:52:14(002) <main_program> orchsort: loaded
##I TOSH 000002 10:52:14(003) <main_program> orchstats: loaded
##W TFPA 000012 10:52:14(006) <main_program> Warning: the PWD environment variable is not defined. Remote process startup may be unsuccessful as a result.If your ORCHESTRATE job does not start up correctly, please set your PWD variable to a value that will work on all nodes of your system.
##E TBLD 000000 10:52:17(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 512
##E TFSR 000019 10:52:17(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 10:52:17(002) <transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
##W TFCP 000025 10:52:17(003) <transform> Error when checking composite operator: Possible range limitation
##W TFCP 000000 10:52:17(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 10:52:17(005) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(007) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(008) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(009) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(010) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(011) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(012) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(013) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(014) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(015) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(016) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(017) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(018) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(019) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(020) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(021) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(022) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(023) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(024) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(025) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(026) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(027) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(028) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(029) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(030) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(031) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(032) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(033) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(034) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(035) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(036) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(037) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(038) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(039) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(040) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(041) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(042) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(043) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(044) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(045) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(046) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(047) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(048) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(049) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(050) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(051) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(052) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(053) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(054) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(055) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(056) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(057) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(058) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(059) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(060) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(061) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(062) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(063) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(064) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(065) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(066) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(067) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(068) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(069) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(070) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##I TFCP 000008 10:52:17(071) <transform> Error when checking composite operator: cxx -O -IE:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c e:/Ascential/DataStage/Projects/dw_s2/RT_BP6.O/V0S19_Load_Customer_Transformer_19.C -o e:/Ascential/DataStage/Projects/dw_s2/RT_BP6.O/V0S19_Load_Customer_Transformer_19.tmp.o
##I TBLD 000000 10:52:17(072) <main_program> Error when checking composite operator: Output from subprocess: e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(246) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(382) : error C2026: string too big, trailing characters truncated
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(587) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential
##I TBLD 000000 10:52:17(073) <main_program> Error when checking composite operator: Output from subprocess: \DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(616) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(645) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(674) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of da
##I TBLD 000000 10:52:17(074) <main_program> Error when checking composite operator: Output from subprocess: ta
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(703) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(732) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(761) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', pos
##I TBLD 000000 10:52:17(075) <main_program> Error when checking composite operator: Output from subprocess: sible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(790) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(819) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(848) : warning C4244: '=' : conversion from 'double' to
##I TBLD 000000 10:52:17(076) <main_program> Error when checking composite operator: Output from subprocess: 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(877) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
##E TCOS 000029 10:52:17(077) <main_program> Creation of step finished with status = FAILED (Load_Customer.Transformer_19)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S19_repos_Transformer_19 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink26;
0007: outputname 0 DSLink21;
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: string InterVar0_3;
0018:
0019: // initialise constant values which require conversion
0020: InterVar0_3 = "-01-01";
0021: }
0022:
0023: mainloop {
0024: // initialise our row rejected variable
0025: RowRejected0 = 1;
0026:
0027: // declare our intermediate variables for this section
0028: string InterVar0_0;
0029: int32 InterVar0_1;
0030: string InterVar0_2;
0031:
0032: // evaluate columns (no constraints) for link: DSLink21
0033: DSLink21.CUST_KEY = DSLink26.CUST_KEY;
0034: DSLink21.RECORD_CODE = DSLink26.CIRAMST_RECORD_CODE;
0035: DSLink21.BANK_NBR = DSLink26.CIRAMST_BANK_NBR;
0036: DSLink21.CUST_NAME_KEY = DSLink26.CIRAMST_CUST_NAME_KEY;
0037: DSLink21.TIE_BREAKER = DSLink26.CIRAMST_TIE_BREAKER;
0038: DSLink21.CS_POINTER = DSLink26.CIRAMST_CS_POINTER;
0039: DSLink21.VARB_LEN = DSLink26.CIRAMST_VARB_LEN;
0040: DSLink21.LINE_CODE_1 = DSLink26.CIRAMST_LINE_CODE_1;
0041: DSLink21.LINE_CODE_2 = DSLink26.CIRAMST_LINE_CODE_2;
0042: DSLink21.LINE_CODE_3 = DSLink26.CIRAMST_LINE_CODE_3;
0043: DSLink21.LINE_CODE_4 = DSLink26.CIRAMST_LINE_CODE_4;
0044: DSLink21.LINE_CODE_5 = DSLink26.CIRAMST_LINE_CODE_5;
0045: DSLink21.LINE_CODE_6 = DSLink26.CIRAMST_LINE_CODE_6;
0046: DSLink21.GREETING = DSLink26.CIRAMST_GREETING;
0047: DSLink21.COMPLIMENT = DSLink26.CIRAMST_COMPLIMENT;
0048: DSLink21.ALT_BANK_NBR = DSLink26.CIRAMST_ALT_BANK_NBR;
0049: DSLink21.ALT_NAME_KEY = DSLink26.CIRAMST_ALT_NAME_KEY;
0050: DSLink21.ALT_TIE_BREAKER = DSLink26.CIRAMST_ALT_TIE_BREAKER;
0051: DSLink21.REG_P_CODE = DSLink26.CIRAMST_REG_P_CODE;
0052: DSLink21.SPEC_HAND = DSLink26.CIRAMST_SPEC_HAND;
0053: DSLink21.RESTRICTED = DSLink26.CIRAMST_RESTRICTED;
0054: DSLink21.REG_O_CODE = DSLink26.CIRAMST_REG_O_CODE;
0055: DSLink21.USER_CODE1 = DSLink26.CIRAMST_USER_CODE1;
0056: DSLink21.USER_CODE2 = DSLink26.CIRAMST_USER_CODE2;
0057: DSLink21.USER_CODE3 = DSLink26.CIRAMST_USER_CODE3;
0058: DSLink21.LAS_MAX_LIABILITY = DSLink26.CIRAMST_LAS_MAX_LIABILITY;
0059: DSLink21.IRA_PART_ST = DSLink26.CIRAMST_IRA_PART_ST;
0060: DSLink21.IRA_DSTRB_WH_FED = DSLink26.CIRAMST_IRA_DSTRB_WH_FED;
0061: DSLink21.IRA_DSTRB_WH_OTH = DSLink26.CIRAMST_IRA_DSTRB_WH_OTH;
0062: DSLink21.IRA_CONTRB_LIMIT = DSLink26.CIRAMST_IRA_CONTRB_LIMIT;
0063: DSLink21.DT_LST_MAINT_TAX = DSLink26.CIRAMST_DT_LST_MAINT_TAX;
0064: DSLink21.DT_LST_MAINT = DSLink26.CIRAMST_DT_LST_MAINT;
0065: DSLink21.DT_ELIGIBLE_DELETE = DSLink26.CIRAMST_DT_ELIGIBLE_DELETE;
0066: DSLink21.USER_CODE4 = DSLink26.CIRAMST_USER_CODE4;
0067: DSLink21.USER_CODE5 = DSLink26.CIRAMST_USER_CODE5;
0068: DSLink21.USER_CODE6 = DSLink26.CIRAMST_USER_CODE6;
0069: DSLink21.FORCE_NOTICE = DSLink26.CIRAMST_FORCE_NOTICE;
0070: NullSetVar0 = 0;
0071: if ((DSLink26.CIRAMST_DATE_LAST_BNOTICE == 0)) {
0072: NullSetVar0 = 1;
0073: } else {
0074: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_BNOTICE;
0075: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0076: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_BNOTICE;
0077: DSLink21.DATE_LAST_BNOTICE = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0078: }
0079: //;
0080: DSLink21.NBR_BNOTICES = DSLink26.CIRAMST_NBR_BNOTICES;
0081: NullSetVar0 = 0;
0082: if ((DSLink26.CIRAMST_DATE_LAST_W9 == 0)) {
0083: NullSetVar0 = 1;
0084: } else {
0085: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_W9;
0086: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0087: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_W9;
0088: DSLink21.DATE_LAST_W9 = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0089: }
0090: //;
0091: DSLink21.NBR_W9S = DSLink26.CIRAMST_NBR_W9S;
0092: DSLink21.INT_WH_FED = DSLink26.CIRAMST_INT_WH_FED;
0093: DSLink21.INT_WH_OTH = DSLink26.CIRAMST_INT_WH_OTH;
0094: DSLink21.TIN_CERTIFIED = DSLink26.CIRAMST_TIN_CERTIFIED;
0095: NullSetVar0 = 0;
0096: if ((DSLink26.CIRAMST_DATE_CERTIFIED == 0)) {
0097: NullSetVar0 = 1;
0098: } else {
0099: InterVar0_0 = DSLink26.CIRAMST_DATE_CERTIFIED;
0100: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0101: InterVar0_2 = DSLink26.CIRAMST_DATE_CERTIFIED;
0102: DSLink21.DATE_CERTIFIED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0103: }
0104: //;
0105: NullSetVar0 = 0;
0106: if ((DSLink26.CIRAMST_DATE_REQ_WITHHOLDING == 0)) {
0107: NullSetVar0 = 1;
0108: } else {
0109: InterVar0_0 = DSLink26.CIRAMST_DATE_REQ_WITHHOLDING;
0110: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0111: InterVar0_2 = DSLink26.CIRAMST_DATE_REQ_WITHHOLDING;
0112: DSLink21.DATE_REQ_WITHHOLDING = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0113: }
0114: //;
0115: DSLink21.TAX_EXEMPT = DSLink26.CIRAMST_TAX_EXEMPT;
0116: DSLink21.ID_TYPE = DSLink26.CIRAMST_ID_TYPE;
0117: DSLink21.ID_ISSUED_BY = DSLink26.CIRAMST_ID_ISSUED_BY;
0118: DSLink21.ID_NUMBER = DSLink26.CIRAMST_ID_NUMBER;
0119: DSLink21.REC_CREATE_PGM = DSLink26.CIRAMST_REC_CREATE_PGM;
0120: DSLink21.CUSTOMER_LEVEL = DSLink26.CIRAMST_CUSTOMER_LEVEL;
0121: DSLink21.CALL_AT_HOME = DSLink26.CIRAMST_CALL_AT_HOME;
0122: DSLink21.CALL_AT_WORK = DSLink26.CIRAMST_CALL_AT_WORK;
0123: DSLink21.COM_NBR_1 = DSLink26.CIRAMST_COM_NBR_1;
0124: DSLink21.COM_NBR_2 = DSLink26.CIRAMST_COM_NBR_2;
0125: DSLink21.COM_NBR_3 = DSLink26.CIRAMST_COM_NBR_3;
0126: DSLink21.CTR_EXEMPT = DSLink26.CIRAMST_CTR_EXEMPT;
0127: DSLink21.CRA_GROSS_SALES = DSLink26.CIRAMST_CRA_GROSS_SALES;
0128: DSLink21.CRA_GROSS_INCOME = DSLink26.CIRAMST_CRA_GROSS_INCOME;
0129: DSLink21.CRA_TOTAL_ASSETS = DSLink26.CIRAMST_CRA_TOTAL_ASSETS;
0130: DSLink21.CRA_TOTAL_LIAB = DSLink26.CIRAMST_CRA_TOTAL_LIAB;
0131: DSLink21.CRA_NET_WORTH = DSLink26.CIRAMST_CRA_NET_WORTH;
0132: NullSetVar0 = 0;
0133: if ((DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT == 0)) {
0134: NullSetVar0 = 1;
0135: } else {
0136: InterVar0_0 = DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT;
0137: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0138: InterVar0_2 = DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT;
0139: DSLink21.CRA_DATE_LAST_FIN_STMT = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0140: }
0141: //;
0142: NullSetVar0 = 0;
0143: if ((DSLink26.CIRAMST_CRA_DATE_VERIFIED == 0)) {
0144: NullSetVar0 = 1;
0145: } else {
0146: InterVar0_0 = DSLink26.CIRAMST_CRA_DATE_VERIFIED;
0147: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0148: InterVar0_2 = DSLink26.CIRAMST_CRA_DATE_VERIFIED;
0149: DSLink21.CRA_DATE_VERIFIED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0150: }
0151: //;
0152: DSLink21.CRA_FIN_STMT_REQUIRED = DSLink26.CIRAMST_CRA_FIN_STMT_REQUIRED;
0153: NullSetVar0 = 0;
0154: if ((DSLink26.CIRAMST_DATE_ADDED == 0)) {
0155: NullSetVar0 = 1;
0156: } else {
0157: InterVar0_0 = DSLink26.CIRAMST_DATE_ADDED;
0158: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0159: InterVar0_2 = DSLink26.CIRAMST_DATE_ADDED;
0160: DSLink21.DATE_ADDED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0161: }
0162: //;
0163: DSLink21.TIME_ADDED = DSLink26.CIRAMST_TIME_ADDED;
0164: DSLink21.USER_ADDED = DSLink26.CIRAMST_USER_ADDED;
0165: DSLink21.TERM_ADDED = DSLink26.CIRAMST_TERM_ADDED;
0166: DSLink21.SIC = DSLink26.CIRAMST_SIC;
0167: NullSetVar0 = 0;
0168: if ((DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA == 0)) {
0169: NullSetVar0 = 1;
0170: } else {
0171: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA;
0172: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0173: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA;
0174: DSLink21.DATE_FIRST_ROTH_IRA = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0175: }
0176: //;
0177: NullSetVar0 = 0;
0178: if ((DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV == 0)) {
0179: NullSetVar0 = 1;
0180: } else {
0181: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV;
0182: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0183: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV;
0184: DSLink21.DATE_FIRST_ROTH_CONV = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0185: }
0186: //;
0187: NullSetVar0 = 0;
0188: if ((DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA == 0)) {
0189: NullSetVar0 = 1;
0190: } else {
0191: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA;
0192: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0193: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA;
0194: DSLink21.DATE_FIRST_SIMPLE_IRA = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0195: }
0196: //;
0197: NullSetVar0 = 0;
0198: if ((DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT == 0)) {
0199: NullSetVar0 = 1;
0200: } else {
0201: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT;
0202: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0203: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT;
0204: DSLink21.DATE_LAST_CREDIT_RPT = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0205: }
0206: //;
0207: DSLink21.CUST_TYPE = DSLink26.CIRAMST_CUST_TYPE;
0208: DSLink21.CREDIT_RATING = DSLink26.CIRAMST_CREDIT_RATING;
0209: DSLink21.CREDIT_RATED_BY = DSLink26.CIRAMST_CREDIT_RATED_BY;
0210: DSLink21.OFFICER = DSLink26.CIRAMST_OFFICER;
0211: DSLink21.BRANCH = DSLink26.CIRAMST_BRANCH;
0212: DSLink21.FED_WTHLD_PERCENT = DSLink26.CIRAMST_FED_WTHLD_PERCENT;
0213: DSLink21.ST_WTHLD_PERCENT = DSLink26.CIRAMST_ST_WTHLD_PERCENT;
0214: DSLink21.IRA_CONTR_ANNUAL_MAX = DSLink26.CIRAMST_IRA_CONTR_ANNUAL_MAX;
0215: DSLink21.CUST_SOURCE = DSLink26.CIRAMST_CUST_SOURCE;
0216: DSLink21.ADDL_SOURCE_INFO = DSLink26.CIRAMST_ADDL_SOURCE_INFO;
0217: DSLink21.BUS_TYPE = DSLink26.CIRAMST_BUS_TYPE;
0218: DSLink21.BUS_SUB_TYPE = DSLink26.CIRAMST_BUS_SUB_TYPE;
0219: DSLink21.BUS_STARTED_DATE = DSLink26.CIRAMST_BUS_STARTED_DATE;
0220: DSLink21.BUS_RESOLUTION_DATE = DSLink26.CIRAMST_BUS_RESOLUTION_DATE;
0221: DSLink21.BUS_WIRE_TRF_RES_DATE = DSLink26.CIRAMST_BUS_WIRE_TRF_RES_DATE;
0222: DSLink21.BUS_INCORPORATION_DATE = DSLink26.CIRAMST_BUS_INCORPORATION_DATE;
0223: DSLink21.BUS_INCORPORATION_ST = DSLink26.CIRAMST_BUS_INCORPORATION_ST;
0224: DSLink21.BUS_SIG_OPEN_DEPOSIT = DSLink26.CIRAMST_BUS_SIG_OPEN_DEPOSIT;
0225: DSLink21.BUS_SIG_WD_DEP_FUNDS = DSLink26.CIRAMST_BUS_SIG_WD_DEP_FUNDS;
0226: DSLink21.BUS_SIG_BORROW_FUNDS = DSLink26.CIRAMST_BUS_SIG_BORROW_FUNDS;
0227: DSLink21.BUS_SIG_PLEDGE_COLL = DSLink26.CIRAMST_BUS_SIG_PLEDGE_COLL;
0228: DSLink21.BUS_SIG_OPEN_SAFE_DEP = DSLink26.CIRAMST_BUS_SIG_OPEN_SAFE_DEP;
0229: DSLink21.BUS_SIG_RLSE_NOTICE = DSLink26.CIRAMST_BUS_SIG_RLSE_NOTICE;
0230: DSLink21.BUS_ORAL_IN_PERSON = DSLink26.CIRAMST_BUS_ORAL_IN_PERSON;
0231: DSLink21.BUS_ORAL_BY_PHONE = DSLink26.CIRAMST_BUS_ORAL_BY_PHONE;
0232: DSLink21.BUS_WRITING_ORIG_SIG = DSLink26.CIRAMST_BUS_WRITING_ORIG_SIG;
0233: DSLink21.BUS_FAX_TRANSMISSION = DSLink26.CIRAMST_BUS_FAX_TRANSMISSION;
0234: DSLink21.BUS_ELEC_TRANSMISSION = DSLink26.CIRAMST_BUS_ELEC_TRANSMISSION;
0235: DSLink21.BUS_CALL_REPET = DSLink26.CIRAMST_BUS_CALL_REPET;
0236: DSLink21.BUS_CALL_NONREPET = DSLink26.CIRAMST_BUS_CALL_NONREPET;
0237: DSLink21.BUS_WTRF_SECURITY = DSLink26.CIRAMST_BUS_WTRF_SECURITY;
0238: DSLink21.COMM_TRF_TYPE = DSLink26.CIRAMST_COMM_TRF_TYPE;
0239: DSLink21.COMM_TRF_LIMIT = DSLink26.CIRAMST_COMM_TRF_LIMIT;
0240: DSLink21.COMM_TRF_DLY_LIMIT = DSLink26.CIRAMST_COMM_TRF_DLY_LIMIT;
0241: DSLink21.COMM_TRF_ADV_DAYS = DSLink26.CIRAMST_COMM_TRF_ADV_DAYS;
0242: DSLink21.DATE_LAST_CHEX_RPT = DSLink26.CIRAMST_DATE_LAST_CHEX_RPT;
0243: DSLink21.CHEX_RPT_BY = DSLink26.CIRAMST_CHEX_RPT_BY;
0244: writerecord 0;
0245: RowRejected0 = 0;
0246: }
0247:
0248: finish {
0249: }
0250:
*** End of Internal Generated Transformer Code
Thanks
if DSLink26.CIRAMST_DATE_LAST_BNOTICE =0 then setnull() else DateFromDaysSince(DSLink26.CIRAMST_DATE_LAST_BNOTICE[5,3],StringtoDate(DSLink26.CIRAMST_DATE_LAST_BNOTICE[1,4]:"-01-01"))
The job compiles fine up to a point. The source table has many columns as I add more columns as I am testing I get a transformer error:
Output from transformer compilation follows:
##I TFCN 000001 10:52:14(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 10:52:14(001) <main_program> orchgeneral: loaded
##I TOSH 000002 10:52:14(002) <main_program> orchsort: loaded
##I TOSH 000002 10:52:14(003) <main_program> orchstats: loaded
##W TFPA 000012 10:52:14(006) <main_program> Warning: the PWD environment variable is not defined. Remote process startup may be unsuccessful as a result.If your ORCHESTRATE job does not start up correctly, please set your PWD variable to a value that will work on all nodes of your system.
##E TBLD 000000 10:52:17(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 512
##E TFSR 000019 10:52:17(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 10:52:17(002) <transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
##W TFCP 000025 10:52:17(003) <transform> Error when checking composite operator: Possible range limitation
##W TFCP 000000 10:52:17(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 10:52:17(005) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(007) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(008) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(009) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(010) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(011) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(012) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(013) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(014) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(015) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(016) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(017) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(018) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(019) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(020) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(021) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(022) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(023) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(024) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(025) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(026) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(027) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(028) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(029) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(030) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(031) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(032) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(033) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(034) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(035) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(036) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(037) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(038) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(039) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(040) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(041) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(042) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(043) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(044) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(045) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(046) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(047) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(048) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(049) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(050) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(051) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(052) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(053) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(054) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(055) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(056) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(057) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(058) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(059) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(060) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(061) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(062) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(063) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(064) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(065) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(066) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(067) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(068) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(069) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(070) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##I TFCP 000008 10:52:17(071) <transform> Error when checking composite operator: cxx -O -IE:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c e:/Ascential/DataStage/Projects/dw_s2/RT_BP6.O/V0S19_Load_Customer_Transformer_19.C -o e:/Ascential/DataStage/Projects/dw_s2/RT_BP6.O/V0S19_Load_Customer_Transformer_19.tmp.o
##I TBLD 000000 10:52:17(072) <main_program> Error when checking composite operator: Output from subprocess: e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(246) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(382) : error C2026: string too big, trailing characters truncated
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(587) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential
##I TBLD 000000 10:52:17(073) <main_program> Error when checking composite operator: Output from subprocess: \DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(616) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(645) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(674) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of da
##I TBLD 000000 10:52:17(074) <main_program> Error when checking composite operator: Output from subprocess: ta
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(703) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(732) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(761) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', pos
##I TBLD 000000 10:52:17(075) <main_program> Error when checking composite operator: Output from subprocess: sible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(790) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(819) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(848) : warning C4244: '=' : conversion from 'double' to
##I TBLD 000000 10:52:17(076) <main_program> Error when checking composite operator: Output from subprocess: 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(877) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
##E TCOS 000029 10:52:17(077) <main_program> Creation of step finished with status = FAILED (Load_Customer.Transformer_19)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S19_repos_Transformer_19 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink26;
0007: outputname 0 DSLink21;
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: string InterVar0_3;
0018:
0019: // initialise constant values which require conversion
0020: InterVar0_3 = "-01-01";
0021: }
0022:
0023: mainloop {
0024: // initialise our row rejected variable
0025: RowRejected0 = 1;
0026:
0027: // declare our intermediate variables for this section
0028: string InterVar0_0;
0029: int32 InterVar0_1;
0030: string InterVar0_2;
0031:
0032: // evaluate columns (no constraints) for link: DSLink21
0033: DSLink21.CUST_KEY = DSLink26.CUST_KEY;
0034: DSLink21.RECORD_CODE = DSLink26.CIRAMST_RECORD_CODE;
0035: DSLink21.BANK_NBR = DSLink26.CIRAMST_BANK_NBR;
0036: DSLink21.CUST_NAME_KEY = DSLink26.CIRAMST_CUST_NAME_KEY;
0037: DSLink21.TIE_BREAKER = DSLink26.CIRAMST_TIE_BREAKER;
0038: DSLink21.CS_POINTER = DSLink26.CIRAMST_CS_POINTER;
0039: DSLink21.VARB_LEN = DSLink26.CIRAMST_VARB_LEN;
0040: DSLink21.LINE_CODE_1 = DSLink26.CIRAMST_LINE_CODE_1;
0041: DSLink21.LINE_CODE_2 = DSLink26.CIRAMST_LINE_CODE_2;
0042: DSLink21.LINE_CODE_3 = DSLink26.CIRAMST_LINE_CODE_3;
0043: DSLink21.LINE_CODE_4 = DSLink26.CIRAMST_LINE_CODE_4;
0044: DSLink21.LINE_CODE_5 = DSLink26.CIRAMST_LINE_CODE_5;
0045: DSLink21.LINE_CODE_6 = DSLink26.CIRAMST_LINE_CODE_6;
0046: DSLink21.GREETING = DSLink26.CIRAMST_GREETING;
0047: DSLink21.COMPLIMENT = DSLink26.CIRAMST_COMPLIMENT;
0048: DSLink21.ALT_BANK_NBR = DSLink26.CIRAMST_ALT_BANK_NBR;
0049: DSLink21.ALT_NAME_KEY = DSLink26.CIRAMST_ALT_NAME_KEY;
0050: DSLink21.ALT_TIE_BREAKER = DSLink26.CIRAMST_ALT_TIE_BREAKER;
0051: DSLink21.REG_P_CODE = DSLink26.CIRAMST_REG_P_CODE;
0052: DSLink21.SPEC_HAND = DSLink26.CIRAMST_SPEC_HAND;
0053: DSLink21.RESTRICTED = DSLink26.CIRAMST_RESTRICTED;
0054: DSLink21.REG_O_CODE = DSLink26.CIRAMST_REG_O_CODE;
0055: DSLink21.USER_CODE1 = DSLink26.CIRAMST_USER_CODE1;
0056: DSLink21.USER_CODE2 = DSLink26.CIRAMST_USER_CODE2;
0057: DSLink21.USER_CODE3 = DSLink26.CIRAMST_USER_CODE3;
0058: DSLink21.LAS_MAX_LIABILITY = DSLink26.CIRAMST_LAS_MAX_LIABILITY;
0059: DSLink21.IRA_PART_ST = DSLink26.CIRAMST_IRA_PART_ST;
0060: DSLink21.IRA_DSTRB_WH_FED = DSLink26.CIRAMST_IRA_DSTRB_WH_FED;
0061: DSLink21.IRA_DSTRB_WH_OTH = DSLink26.CIRAMST_IRA_DSTRB_WH_OTH;
0062: DSLink21.IRA_CONTRB_LIMIT = DSLink26.CIRAMST_IRA_CONTRB_LIMIT;
0063: DSLink21.DT_LST_MAINT_TAX = DSLink26.CIRAMST_DT_LST_MAINT_TAX;
0064: DSLink21.DT_LST_MAINT = DSLink26.CIRAMST_DT_LST_MAINT;
0065: DSLink21.DT_ELIGIBLE_DELETE = DSLink26.CIRAMST_DT_ELIGIBLE_DELETE;
0066: DSLink21.USER_CODE4 = DSLink26.CIRAMST_USER_CODE4;
0067: DSLink21.USER_CODE5 = DSLink26.CIRAMST_USER_CODE5;
0068: DSLink21.USER_CODE6 = DSLink26.CIRAMST_USER_CODE6;
0069: DSLink21.FORCE_NOTICE = DSLink26.CIRAMST_FORCE_NOTICE;
0070: NullSetVar0 = 0;
0071: if ((DSLink26.CIRAMST_DATE_LAST_BNOTICE == 0)) {
0072: NullSetVar0 = 1;
0073: } else {
0074: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_BNOTICE;
0075: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0076: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_BNOTICE;
0077: DSLink21.DATE_LAST_BNOTICE = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0078: }
0079: //;
0080: DSLink21.NBR_BNOTICES = DSLink26.CIRAMST_NBR_BNOTICES;
0081: NullSetVar0 = 0;
0082: if ((DSLink26.CIRAMST_DATE_LAST_W9 == 0)) {
0083: NullSetVar0 = 1;
0084: } else {
0085: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_W9;
0086: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0087: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_W9;
0088: DSLink21.DATE_LAST_W9 = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0089: }
0090: //;
0091: DSLink21.NBR_W9S = DSLink26.CIRAMST_NBR_W9S;
0092: DSLink21.INT_WH_FED = DSLink26.CIRAMST_INT_WH_FED;
0093: DSLink21.INT_WH_OTH = DSLink26.CIRAMST_INT_WH_OTH;
0094: DSLink21.TIN_CERTIFIED = DSLink26.CIRAMST_TIN_CERTIFIED;
0095: NullSetVar0 = 0;
0096: if ((DSLink26.CIRAMST_DATE_CERTIFIED == 0)) {
0097: NullSetVar0 = 1;
0098: } else {
0099: InterVar0_0 = DSLink26.CIRAMST_DATE_CERTIFIED;
0100: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0101: InterVar0_2 = DSLink26.CIRAMST_DATE_CERTIFIED;
0102: DSLink21.DATE_CERTIFIED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0103: }
0104: //;
0105: NullSetVar0 = 0;
0106: if ((DSLink26.CIRAMST_DATE_REQ_WITHHOLDING == 0)) {
0107: NullSetVar0 = 1;
0108: } else {
0109: InterVar0_0 = DSLink26.CIRAMST_DATE_REQ_WITHHOLDING;
0110: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0111: InterVar0_2 = DSLink26.CIRAMST_DATE_REQ_WITHHOLDING;
0112: DSLink21.DATE_REQ_WITHHOLDING = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0113: }
0114: //;
0115: DSLink21.TAX_EXEMPT = DSLink26.CIRAMST_TAX_EXEMPT;
0116: DSLink21.ID_TYPE = DSLink26.CIRAMST_ID_TYPE;
0117: DSLink21.ID_ISSUED_BY = DSLink26.CIRAMST_ID_ISSUED_BY;
0118: DSLink21.ID_NUMBER = DSLink26.CIRAMST_ID_NUMBER;
0119: DSLink21.REC_CREATE_PGM = DSLink26.CIRAMST_REC_CREATE_PGM;
0120: DSLink21.CUSTOMER_LEVEL = DSLink26.CIRAMST_CUSTOMER_LEVEL;
0121: DSLink21.CALL_AT_HOME = DSLink26.CIRAMST_CALL_AT_HOME;
0122: DSLink21.CALL_AT_WORK = DSLink26.CIRAMST_CALL_AT_WORK;
0123: DSLink21.COM_NBR_1 = DSLink26.CIRAMST_COM_NBR_1;
0124: DSLink21.COM_NBR_2 = DSLink26.CIRAMST_COM_NBR_2;
0125: DSLink21.COM_NBR_3 = DSLink26.CIRAMST_COM_NBR_3;
0126: DSLink21.CTR_EXEMPT = DSLink26.CIRAMST_CTR_EXEMPT;
0127: DSLink21.CRA_GROSS_SALES = DSLink26.CIRAMST_CRA_GROSS_SALES;
0128: DSLink21.CRA_GROSS_INCOME = DSLink26.CIRAMST_CRA_GROSS_INCOME;
0129: DSLink21.CRA_TOTAL_ASSETS = DSLink26.CIRAMST_CRA_TOTAL_ASSETS;
0130: DSLink21.CRA_TOTAL_LIAB = DSLink26.CIRAMST_CRA_TOTAL_LIAB;
0131: DSLink21.CRA_NET_WORTH = DSLink26.CIRAMST_CRA_NET_WORTH;
0132: NullSetVar0 = 0;
0133: if ((DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT == 0)) {
0134: NullSetVar0 = 1;
0135: } else {
0136: InterVar0_0 = DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT;
0137: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0138: InterVar0_2 = DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT;
0139: DSLink21.CRA_DATE_LAST_FIN_STMT = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0140: }
0141: //;
0142: NullSetVar0 = 0;
0143: if ((DSLink26.CIRAMST_CRA_DATE_VERIFIED == 0)) {
0144: NullSetVar0 = 1;
0145: } else {
0146: InterVar0_0 = DSLink26.CIRAMST_CRA_DATE_VERIFIED;
0147: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0148: InterVar0_2 = DSLink26.CIRAMST_CRA_DATE_VERIFIED;
0149: DSLink21.CRA_DATE_VERIFIED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0150: }
0151: //;
0152: DSLink21.CRA_FIN_STMT_REQUIRED = DSLink26.CIRAMST_CRA_FIN_STMT_REQUIRED;
0153: NullSetVar0 = 0;
0154: if ((DSLink26.CIRAMST_DATE_ADDED == 0)) {
0155: NullSetVar0 = 1;
0156: } else {
0157: InterVar0_0 = DSLink26.CIRAMST_DATE_ADDED;
0158: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0159: InterVar0_2 = DSLink26.CIRAMST_DATE_ADDED;
0160: DSLink21.DATE_ADDED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0161: }
0162: //;
0163: DSLink21.TIME_ADDED = DSLink26.CIRAMST_TIME_ADDED;
0164: DSLink21.USER_ADDED = DSLink26.CIRAMST_USER_ADDED;
0165: DSLink21.TERM_ADDED = DSLink26.CIRAMST_TERM_ADDED;
0166: DSLink21.SIC = DSLink26.CIRAMST_SIC;
0167: NullSetVar0 = 0;
0168: if ((DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA == 0)) {
0169: NullSetVar0 = 1;
0170: } else {
0171: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA;
0172: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0173: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA;
0174: DSLink21.DATE_FIRST_ROTH_IRA = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0175: }
0176: //;
0177: NullSetVar0 = 0;
0178: if ((DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV == 0)) {
0179: NullSetVar0 = 1;
0180: } else {
0181: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV;
0182: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0183: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV;
0184: DSLink21.DATE_FIRST_ROTH_CONV = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0185: }
0186: //;
0187: NullSetVar0 = 0;
0188: if ((DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA == 0)) {
0189: NullSetVar0 = 1;
0190: } else {
0191: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA;
0192: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0193: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA;
0194: DSLink21.DATE_FIRST_SIMPLE_IRA = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0195: }
0196: //;
0197: NullSetVar0 = 0;
0198: if ((DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT == 0)) {
0199: NullSetVar0 = 1;
0200: } else {
0201: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT;
0202: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0203: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT;
0204: DSLink21.DATE_LAST_CREDIT_RPT = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0205: }
0206: //;
0207: DSLink21.CUST_TYPE = DSLink26.CIRAMST_CUST_TYPE;
0208: DSLink21.CREDIT_RATING = DSLink26.CIRAMST_CREDIT_RATING;
0209: DSLink21.CREDIT_RATED_BY = DSLink26.CIRAMST_CREDIT_RATED_BY;
0210: DSLink21.OFFICER = DSLink26.CIRAMST_OFFICER;
0211: DSLink21.BRANCH = DSLink26.CIRAMST_BRANCH;
0212: DSLink21.FED_WTHLD_PERCENT = DSLink26.CIRAMST_FED_WTHLD_PERCENT;
0213: DSLink21.ST_WTHLD_PERCENT = DSLink26.CIRAMST_ST_WTHLD_PERCENT;
0214: DSLink21.IRA_CONTR_ANNUAL_MAX = DSLink26.CIRAMST_IRA_CONTR_ANNUAL_MAX;
0215: DSLink21.CUST_SOURCE = DSLink26.CIRAMST_CUST_SOURCE;
0216: DSLink21.ADDL_SOURCE_INFO = DSLink26.CIRAMST_ADDL_SOURCE_INFO;
0217: DSLink21.BUS_TYPE = DSLink26.CIRAMST_BUS_TYPE;
0218: DSLink21.BUS_SUB_TYPE = DSLink26.CIRAMST_BUS_SUB_TYPE;
0219: DSLink21.BUS_STARTED_DATE = DSLink26.CIRAMST_BUS_STARTED_DATE;
0220: DSLink21.BUS_RESOLUTION_DATE = DSLink26.CIRAMST_BUS_RESOLUTION_DATE;
0221: DSLink21.BUS_WIRE_TRF_RES_DATE = DSLink26.CIRAMST_BUS_WIRE_TRF_RES_DATE;
0222: DSLink21.BUS_INCORPORATION_DATE = DSLink26.CIRAMST_BUS_INCORPORATION_DATE;
0223: DSLink21.BUS_INCORPORATION_ST = DSLink26.CIRAMST_BUS_INCORPORATION_ST;
0224: DSLink21.BUS_SIG_OPEN_DEPOSIT = DSLink26.CIRAMST_BUS_SIG_OPEN_DEPOSIT;
0225: DSLink21.BUS_SIG_WD_DEP_FUNDS = DSLink26.CIRAMST_BUS_SIG_WD_DEP_FUNDS;
0226: DSLink21.BUS_SIG_BORROW_FUNDS = DSLink26.CIRAMST_BUS_SIG_BORROW_FUNDS;
0227: DSLink21.BUS_SIG_PLEDGE_COLL = DSLink26.CIRAMST_BUS_SIG_PLEDGE_COLL;
0228: DSLink21.BUS_SIG_OPEN_SAFE_DEP = DSLink26.CIRAMST_BUS_SIG_OPEN_SAFE_DEP;
0229: DSLink21.BUS_SIG_RLSE_NOTICE = DSLink26.CIRAMST_BUS_SIG_RLSE_NOTICE;
0230: DSLink21.BUS_ORAL_IN_PERSON = DSLink26.CIRAMST_BUS_ORAL_IN_PERSON;
0231: DSLink21.BUS_ORAL_BY_PHONE = DSLink26.CIRAMST_BUS_ORAL_BY_PHONE;
0232: DSLink21.BUS_WRITING_ORIG_SIG = DSLink26.CIRAMST_BUS_WRITING_ORIG_SIG;
0233: DSLink21.BUS_FAX_TRANSMISSION = DSLink26.CIRAMST_BUS_FAX_TRANSMISSION;
0234: DSLink21.BUS_ELEC_TRANSMISSION = DSLink26.CIRAMST_BUS_ELEC_TRANSMISSION;
0235: DSLink21.BUS_CALL_REPET = DSLink26.CIRAMST_BUS_CALL_REPET;
0236: DSLink21.BUS_CALL_NONREPET = DSLink26.CIRAMST_BUS_CALL_NONREPET;
0237: DSLink21.BUS_WTRF_SECURITY = DSLink26.CIRAMST_BUS_WTRF_SECURITY;
0238: DSLink21.COMM_TRF_TYPE = DSLink26.CIRAMST_COMM_TRF_TYPE;
0239: DSLink21.COMM_TRF_LIMIT = DSLink26.CIRAMST_COMM_TRF_LIMIT;
0240: DSLink21.COMM_TRF_DLY_LIMIT = DSLink26.CIRAMST_COMM_TRF_DLY_LIMIT;
0241: DSLink21.COMM_TRF_ADV_DAYS = DSLink26.CIRAMST_COMM_TRF_ADV_DAYS;
0242: DSLink21.DATE_LAST_CHEX_RPT = DSLink26.CIRAMST_DATE_LAST_CHEX_RPT;
0243: DSLink21.CHEX_RPT_BY = DSLink26.CIRAMST_CHEX_RPT_BY;
0244: writerecord 0;
0245: RowRejected0 = 0;
0246: }
0247:
0248: finish {
0249: }
0250:
*** End of Internal Generated Transformer Code
Thanks