Compiling Error Problem

sush26283 · Post by **sush26283** » Wed Sep 08, 2010 2:27 pm

Hi...
I have been trying to compile the job but have been encountering errors.. I did resolve some of them but still am getting the error while compiling at the transformer level. I have checked all d stage variables an they all see to b fine, but still am getting error..Please help me out..the error message is..

Output from transformer compilation follows:

##I TFCN 000001 15:22:19(000) <main_program>
IBM DataStage(tm) Parallel Extender 7.5.3
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved

##I TOSH 000002 15:22:19(001) <main_program> orchgeneral: loaded
##I TOSH 000002 15:22:19(002) <main_program> orchsort: loaded
##I TOSH 000002 15:22:19(003) <main_program> orchstats: loaded
##I TFSC 000001 15:22:19(006) <main_program> APT configuration file: /u01/app/dsadm/Ascential/DataStage/Configurations/etldevs1/7_node_7_mp.apt
##I TFSC 000000 15:22:19(007) <main_program>
This step has no datasets.

It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##I TFOP 000094 15:22:19(000) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 15:22:19(001) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 15:22:19(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W TCOS 000049 15:22:19(009) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##I TCOS 000023 15:22:19(011) <main_program> Dump:
{
text="transform -inputschema record ( PROGRAM_NUMBER: nullable string[max=7]; PROJECT_ID: decimal[9,0]; OPCO_CD: nullable string[max=5]; PROGRAM_BRAND_CD: nullable string[max=4]; PROGRAM_SOURCE_CD: nullable string[max=5]; PROGRAM_TYPE_CD: nullable string[max=5]; PROGRAM_LONG_DESCRIPTION: nullable string[max=80]; ISSUE_CD: nullable string[max=3]; RESPONSE_EXPECTED_FLAG: nullable string[max=1]; HANDRAISER_FLAG: nullable string[max=1]; COMMUNICATION_TYPE_CD: nullable string[max=5]; START_DATE: nullable timestamp; END_DATE: nullable timestamp; REQUESTED_BY: nullable string[max=40]; REQUESTED_BY_PHONE: nullable string[max=12]; REQUESTED_BY_EMAIL: nullable string[max=100]; CLIENT_SERVICES_CONTACT: nullable string[max=40]; CLIENT_SERVICES_CONTACT_PHONE: nullable string[max=12]; CLIENT_SERVICES_CONTACT_EMAIL: nullable string[max=100]; RMT_CONTACT: nullable string[max=40]; RMT_CONTACT_PHONE: nullable string[max=12]; RMT_CONTACT_EMAIL: nullable string[max=100]; ESTIMATED_FIXED_COST: nullable decimal[9,2]; ACTUAL_FIXED_COST: nullable decimal[9,2]; ESTIMATED_VARIABLE_COST: nullable decimal[9,2]; ACTUAL_VARIABLE_COST: nullable decimal[9,2]; ESTIMATED_QUANTITY: nullable decimal[9,0]; ACTUAL_QUANTITY: nullable decimal[9,0]; ACTUAL_CIRCULATION: nullable decimal[9,0]; BRAND_SUPPORT_CONTACT: nullable string[max=40]; BRAND_SUPPORT_CONTACT_PHONE: nullable string[max=12]; BRAND_SUPPORT_CONTACT_EMAIL: nullable string[max=100]; PRINT_SERVICES_CONTACT: nullable string[max=40]; PRINT_SERVICES_CONTACT_PHONE: nullable string[max=12]; PRINT_SERVICES_CONTACT_EMAIL: nullable string[max=100]; PRINT_VENDOR_CONTACT: nullable string[max=40]; PRINT_VENDOR_CONTACT_PHONE: nullable string[max=12]; PRINT_VENDOR_CONTACT_EMAIL: nullable string[max=100]; PA_MONTH_1: nullable string[max=2]; PA_MONTH_2: nullable string[max=2]; PA_MONTH_3: nullable string[max=2]; PA_MONTH_4: nullable string[max=2]; PA_VALUE_1: nullable decimal[7,2]; PA_VALUE_2: nullable decimal[7,2]; PA_VALUE_3: nullable decimal[7,2]; PA_VALUE_4: nullable decimal[7,2]; PM_FULFILLMENT_CONTACT: nullable string[max=40]; PM_FULFILLMENT_PHONE_NUMBER: nullable string[max=40]; PM_FULFILLMENT_EMAIL: nullable string[max=100]; PROMO_CD: nullable string[max=10]; CHANNEL_TYPE_CD: nullable string[max=5]; MULTI_BRAND_CD: nullable string[max=4]; SERVICE_CD: nullable string[max=5]; GIID_IN_PERSON: nullable string[max=1]; RECORD_CREATE_DATE: nullable timestamp; LAST_REBUILD_DATE: nullable timestamp; CONTACT_HISTORY_ID: decimal[38,10]; DATA_SOURCE_ID: nullable decimal[9,0]; TRANSACTION_ID: nullable decimal[12,0]; OWNER_CD: string[max=5]; LIST_CD: nullable string[max=10]; TRANSACTION_DATE: nullable timestamp; PROGRAM_PHASE_CD: nullable string[max=4]; CELL_NUMBER: nullable string[max=3]; TREATMENT_ID: nullable decimal[9,0]; BRAND_FAMILY_CD: nullable string[max=5]; PRODUCT_LINE_CD: nullable string[max=5]; INDIVIDUAL_ID: nullable decimal[9,0]; CONTACT_DATE: nullable timestamp; OFFER_CATEGORY_CD: nullable string[max=5]; CONTACT_INITIATOR_CD: nullable string[max=5]; CONTACT_TYPE_CD: nullable string[max=5]; CONTACT_RESULT_CD: nullable string[max=5]; ORDER_NUMBER: nullable string[max=10]; ORG_ID: nullable decimal[9,0]; OCR_CD: nullable string[max=16]; MEDIA_CD: nullable string[max=3]; MEDIA_CATEGORY_CD: nullable string[max=5]; DATE_OF_BIRTH: nullable timestamp; CMS_RETAIL_ID: nullable string[max=9]; REDEMPTION_UPC_CODE: nullable string[max=12]; POS_NUMBER: nullable string[max=5]; BONUS_UPC_QTY: nullable decimal[4,0]; COUPON_ID: nullable string[max=30]; RETAIL_ACCOUNT_NO: nullable string[max=6]; PROMO_CODE: nullable string[max=10]; LAST_CONTACT_DATE: nullable timestamp; TOTAL_NUMBER_CONTACTS: nullable decimal[4,0]; AGE_VERIFICATION_CD: nullable string[max=5]; CONTACT_RESULT_DATE: nullable timestamp; BRAND_CD: nullable string[max=5]; CLASSIFICATION_CD: nullable string[max=5]; POSTING_LEVEL_CD: nullable string[max=5]; AS_INTEREST_FLAG: nullable string[max=1]; ADDRESS_TYPE_CD: nullable string[max=5]; OFFER_CATEGORY_CD_1: string[max=5]; PACKAGE_TYPE_CD: nullable string[max=5]; keyChange: int8; OFFER_CD: string[max=3]; )\n-outputschema record ( OPCO_CD: string[max=5]; INDIVIDUAL_ID: decimal[9,0]; BRAND_CD: string[max=5]; PRODUCT_LINE_CD: string[max=5]; CHANNEL_TYPE_CD: string[max=5]; LAST_GIFT_RESPONSE_DATE: nullable timestamp; LAST_COUPON_RESPONSE_DATE: nullable timestamp; LAST_EVENT_RESPONSE_DATE: nullable timestamp; LAST_SWEEPS_CONTEST_RESP_DATE: nullable timestamp; LAST_SURVEY_RESPONSE_DATE: nullable timestamp; LAST_MISC_RESPONSE_DATE: nullable timestamp; LAST_MAILED_DATE: nullable timestamp; LIFETIME_GIFT_RESPONSES: nullable decimal[7,0]; LIFETIME_COUPON_RESPONSES: nullable decimal[7,0]; LIFETIME_EVENT_RESPONSES: nullable decimal[7,0]; LIFETIME_SWEEPS_RESPONSES: nullable decimal[7,0]; LIFETIME_PROGRAMS_MAILED: nullable decimal[7,0]; LAST_PACK_REDEMPTION_DATE: nullable timestamp; LAST_CARTON_REDEMPTION_DATE: nullable timestamp; LAST_COMBO_REDEMPTION_DATE: nullable timestamp; LAST_COUPON_OFFERED_DATE: nullable timestamp; LAST_GIFT_OFFERED_DATE: nullable timestamp; LAST_PROGRAM_RESPONDED_TO: nullable string[max=7]; LAST_PROGRAM_RESPONDED_DATE: nullable timestamp; LAST_OPEN_DATE: nullable timestamp; LAST_CLICK_DATE: nullable timestamp; LIFETIME_OPENED: nullable decimal[7,0]; LIFETIME_CLICKED: nullable decimal[7,0]; LAST_REBUILD_DATE: nullable timestamp; keyChange: int8; )\n-expressionfile RT_SC290/V0S7_DM_INDIVIDUAL_X_BPC_SUMM_Transformer_7.trx\n-flag compile\n-compiler 'g++'\n-compileopt '-O -m32 -fPIC -Wno-deprecated -c'\n-linker 'g++'\n-linkopt '-shared -Wl,-Bsymbolic,--allow-shlib-undefined -m32'\n-name V0S7_DM_INDIVIDUAL_X_BPC_SUMM_Transformer_7\n-dir /u01/app/dsadm/Ascential/DataStage/Projects/etldevs1/RT_BP290.O",
line=1, column=1, name="", qualname="",
op={
text="transform -inputschema record ( PROGRAM_NUMBER: nullable string[max=7]; PROJECT_ID: decimal[9,0]; OPCO_CD: nullable string[max=5]; PROGRAM_BRAND_CD: nullable string[max=4]; PROGRAM_SOURCE_CD: nullable string[max=5]; PROGRAM_TYPE_CD: nullable string[max=5]; PROGRAM_LONG_DESCRIPTION: nullable string[max=80]; ISSUE_CD: nullable string[max=3]; RESPONSE_EXPECTED_FLAG: nullable string[max=1]; HANDRAISER_FLAG: nullable string[max=1]; COMMUNICATION_TYPE_CD: nullable string[max=5]; START_DATE: nullable timestamp; END_DATE: nullable timestamp; REQUESTED_BY: nullable string[max=40]; REQUESTED_BY_PHONE: nullable string[max=12]; REQUESTED_BY_EMAIL: nullable string[max=100]; CLIENT_SERVICES_CONTACT: nullable string[max=40]; CLIENT_SERVICES_CONTACT_PHONE: nullable string[max=12]; CLIENT_SERVICES_CONTACT_EMAIL: nullable string[max=100]; RMT_CONTACT: nullable string[max=40]; RMT_CONTACT_PHONE: nullable string[max=12]; RMT_CONTACT_EMAIL: nullable string[max=100]; ESTIMATED_FIXED_COST: nullable decimal[9,2]; ACTUAL_FIXED_COST: nullable decimal[9,2]; ESTIMATED_VARIABLE_COST: nullable decimal[9,2]; ACTUAL_VARIABLE_COST: nullable decimal[9,2]; ESTIMATED_QUANTITY: nullable decimal[9,0]; ACTUAL_QUANTITY: nullable decimal[9,0]; ACTUAL_CIRCULATION: nullable decimal[9,0]; BRAND_SUPPORT_CONTACT: nullable string[max=40]; BRAND_SUPPORT_CONTACT_PHONE: nullable string[max=12]; BRAND_SUPPORT_CONTACT_EMAIL: nullable string[max=100]; PRINT_SERVICES_CONTACT: nullable string[max=40]; PRINT_SERVICES_CONTACT_PHONE: nullable string[max=12]; PRINT_SERVICES_CONTACT_EMAIL: nullable string[max=100]; PRINT_VENDOR_CONTACT: nullable string[max=40]; PRINT_VENDOR_CONTACT_PHONE: nullable string[max=12]; PRINT_VENDOR_CONTACT_EMAIL: nullable string[max=100]; PA_MONTH_1: nullable string[max=2]; PA_MONTH_2: nullable string[max=2]; PA_MONTH_3: nullable string[max=2]; PA_MONTH_4: nullable string[max=2]; PA_VALUE_1: nullable decimal[7,2]; PA_VALUE_2: nullable decimal[7,2]; PA_VALUE_3: nullable decimal[7,2]; PA_VALUE_4: nullable decimal[7,2]; PM_FULFILLMENT_CONTACT: nullable string[max=40]; PM_FULFILLMENT_PHONE_NUMBER: nullable string[max=40]; PM_FULFILLMENT_EMAIL: nullable string[max=100]; PROMO_CD: nullable string[max=10]; CHANNEL_TYPE_CD: nullable string[max=5]; MULTI_BRAND_CD: nullable string[max=4]; SERVICE_CD: nullable string[max=5]; GIID_IN_PERSON: nullable string[max=1]; RECORD_CREATE_DATE: nullable timestamp; LAST_REBUILD_DATE: nullable timestamp; CONTACT_HISTORY_ID: decimal[38,10]; DATA_SOURCE_ID: nullable decimal[9,0]; TRANSACTION_ID: nullable decimal[12,0]; OWNER_CD: string[max=5]; LIST_CD: nullable string[max=10]; TRANSACTION_DATE: nullable timestamp; PROGRAM_PHASE_CD: nullable string[max=4]; CELL_NUMBER: nullable string[max=3]; TREATMENT_ID: nullable decimal[9,0]; BRAND_FAMILY_CD: nullable string[max=5]; PRODUCT_LINE_CD: nullable string[max=5]; INDIVIDUAL_ID: nullable decimal[9,0]; CONTACT_DATE: nullable timestamp; OFFER_CATEGORY_CD: nullable string[max=5]; CONTACT_INITIATOR_CD: nullable string[max=5]; CONTACT_TYPE_CD: nullable string[max=5]; CONTACT_RESULT_CD: nullable string[max=5]; ORDER_NUMBER: nullable string[max=10]; ORG_ID: nullable decimal[9,0]; OCR_CD: nullable string[max=16]; MEDIA_CD: nullable string[max=3]; MEDIA_CATEGORY_CD: nullable string[max=5]; DATE_OF_BIRTH: nullable timestamp; CMS_RETAIL_ID: nullable string[max=9]; REDEMPTION_UPC_CODE: nullable string[max=12]; POS_NUMBER: nullable string[max=5]; BONUS_UPC_QTY: nullable decimal[4,0]; COUPON_ID: nullable string[max=30]; RETAIL_ACCOUNT_NO: nullable string[max=6]; PROMO_CODE: nullable string[max=10]; LAST_CONTACT_DATE: nullable timestamp; TOTAL_NUMBER_CONTACTS: nullable decimal[4,0]; AGE_VERIFICATION_CD: nullable string[max=5]; CONTACT_RESULT_DATE: nullable timestamp; BRAND_CD: nullable string[max=5]; CLASSIFICATION_CD: nullable string[max=5]; POSTING_LEVEL_CD: nullable string[max=5]; AS_INTEREST_FLAG: nullable string[max=1]; ADDRESS_TYPE_CD: nullable string[max=5]; OFFER_CATEGORY_CD_1: string[max=5]; PACKAGE_TYPE_CD: nullable string[max=5]; keyChange: int8; OFFER_CD: string[max=3]; )\n-outputschema record ( OPCO_CD: string[max=5]; INDIVIDUAL_ID: decimal[9,0]; BRAND_CD: string[max=5]; PRODUCT_LINE_CD: string[max=5]; CHANNEL_TYPE_CD: string[max=5]; LAST_GIFT_RESPONSE_DATE: nullable timestamp; LAST_COUPON_RESPONSE_DATE: nullable timestamp; LAST_EVENT_RESPONSE_DATE: nullable timestamp; LAST_SWEEPS_CONTEST_RESP_DATE: nullable timestamp; LAST_SURVEY_RESPONSE_DATE: nullable timestamp; LAST_MISC_RESPONSE_DATE: nullable timestamp; LAST_MAILED_DATE: nullable timestamp; LIFETIME_GIFT_RESPONSES: nullable decimal[7,0]; LIFETIME_COUPON_RESPONSES: nullable decimal[7,0]; LIFETIME_EVENT_RESPONSES: nullable decimal[7,0]; LIFETIME_SWEEPS_RESPONSES: nullable decimal[7,0]; LIFETIME_PROGRAMS_MAILED: nullable decimal[7,0]; LAST_PACK_REDEMPTION_DATE: nullable timestamp; LAST_CARTON_REDEMPTION_DATE: nullable timestamp; LAST_COMBO_REDEMPTION_DATE: nullable timestamp; LAST_COUPON_OFFERED_DATE: nullable timestamp; LAST_GIFT_OFFERED_DATE: nullable timestamp; LAST_PROGRAM_RESPONDED_TO: nullable string[max=7]; LAST_PROGRAM_RESPONDED_DATE: nullable timestamp; LAST_OPEN_DATE: nullable timestamp; LAST_CLICK_DATE: nullable timestamp; LIFETIME_OPENED: nullable decimal[7,0]; LIFETIME_CLICKED: nullable decimal[7,0]; LAST_REBUILD_DATE: nullable timestamp; keyChange: int8; )\n-expressionfile RT_SC290/V0S7_DM_INDIVIDUAL_X_BPC_SUMM_Transformer_7.trx\n-flag compile\n-compiler 'g++'\n-compileopt '-O -m32 -fPIC -Wno-deprecated -c'\n-linker 'g++'\n-linkopt '-shared -Wl,-Bsymbolic,--allow-shlib-undefined -m32'\n-name V0S7_DM_INDIVIDUAL_X_BPC_SUMM_Transformer_7\n-dir /u01/app/dsadm/Ascential/DataStage/Projects/etldevs1/RT_BP290.O",
line=1, column=1, name=transform, qualname=transform,
wrapout={},
wrapperfile=transform, kind=non_wrapper_cdi_op, exec_mode=none,
args="'record ( PROGRAM_NUMBER: nullable string[max=7]; PROJECT_ID: decimal[9,0]; OPCO_CD: nullable string[max=5]; PROGRAM_BRAND_CD: nullable string[max=4]; PROGRAM_SOURCE_CD: nullable string[max=5]; PROGRAM_TYPE_CD: nullable string[max=5]; PROGRAM_LONG_DESCRIPTION: nullable string[max=80]; ISSUE_CD: nullable string[max=3]; RESPONSE_EXPECTED_FLAG: nullable string[max=1]; HANDRAISER_FLAG: nullable string[max=1]; COMMUNICATION_TYPE_CD: nullable string[max=5]; START_DATE: nullable timestamp; END_DATE: nullable timestamp; REQUESTED_BY: nullable string[max=40]; REQUESTED_BY_PHONE: nullable string[max=12]; REQUESTED_BY_EMAIL: nullable string[max=100]; CLIENT_SERVICES_CONTACT: nullable string[max=40]; CLIENT_SERVICES_CONTACT_PHONE: nullable string[max=12]; CLIENT_SERVICES_CONTACT_EMAIL: nullable string[max=100]; RMT_CONTACT: nullable string[max=40]; RMT_CONTACT_PHONE: nullable string[max=12]; RMT_CONTACT_EMAIL: nullable string[max=100]; ESTIMATED_FIXED_COST: nullable decimal[9,2]; ACTUAL_FIXED_COST: nullable decimal[9,2]; ESTIMATED_VARIABLE_COST: nullable decimal[9,2]; ACTUAL_VARIABLE_COST: nullable decimal[9,2]; ESTIMATED_QUANTITY: nullable decimal[9,0]; ACTUAL_QUANTITY: nullable decimal[9,0]; ACTUAL_CIRCULATION: nullable decimal[9,0]; BRAND_SUPPORT_CONTACT: nullable string[max=40]; BRAND_SUPPORT_CONTACT_PHONE: nullable string[max=12]; BRAND_SUPPORT_CONTACT_EMAIL: nullable string[max=100]; PRINT_SERVICES_CONTACT: nullable string[max=40]; PRINT_SERVICES_CONTACT_PHONE: nullable string[max=12]; PRINT_SERVICES_CONTACT_EMAIL: nullable string[max=100]; PRINT_VENDOR_CONTACT: nullable string[max=40]; PRINT_VENDOR_CONTACT_PHONE: nullable string[max=12]; PRINT_VENDOR_CONTACT_EMAIL: nullable string[max=100]; PA_MONTH_1: nullable string[max=2]; PA_MONTH_2: nullable string[max=2]; PA_MONTH_3: nullable string[max=2]; PA_MONTH_4: nullable string[max=2]; PA_VALUE_1: nullable decimal[7,2]; PA_VALUE_2: nullable decimal[7,2]; PA_VALUE_3: nullable decimal[7,2]; PA_VALUE_4: nullable decimal[7,2]; PM_FULFILLMENT_CONTACT: nullable string[max=40]; PM_FULFILLMENT_PHONE_NUMBER: nullable string[max=40]; PM_FULFILLMENT_EMAIL: nullable string[max=100]; PROMO_CD: nullable string[max=10]; CHANNEL_TYPE_CD: nullable string[max=5]; MULTI_BRAND_CD: nullable string[max=4]; SERVICE_CD: nullable string[max=5]; GIID_IN_PERSON: nullable string[max=1]; RECORD_CREATE_DATE: nullable timestamp; LAST_REBUILD_DATE: nullable timestamp; CONTACT_HISTORY_ID: decimal[38,10]; DATA_SOURCE_ID: nullable decimal[9,0]; TRANSACTION_ID: nullable decimal[12,0]; OWNER_CD: string[max=5]; LIST_CD: nullable string[max=10]; TRANSACTION_DATE: nullable timestamp; PROGRAM_PHASE_CD: nullable string[max=4]; CELL_NUMBER: nullable string[max=3]; TREATMENT_ID: nullable decimal[9,0]; BRAND_FAMILY_CD: nullable string[max=5]; PRODUCT_LINE_CD: nullable string[max=5]; INDIVIDUAL_ID: nullable decimal[9,0]; CONTACT_DATE: nullable timestamp; OFFER_CATEGORY_CD: nullable string[max=5]; CONTACT_INITIATOR_CD: nullable string[max=5]; CONTACT_TYPE_CD: nullable string[max=5]; CONTACT_RESULT_CD: nullable string[max=5]; ORDER_NUMBER: nullable string[max=10]; ORG_ID: nullable decimal[9,0]; OCR_CD: nullable string[max=16]; MEDIA_CD: nullable string[max=3]; MEDIA_CATEGORY_CD: nullable string[max=5]; DATE_OF_BIRTH: nullable timestamp; CMS_RETAIL_ID: nullable string[max=9]; REDEMPTION_UPC_CODE: nullable string[max=12]; POS_NUMBER: nullable string[max=5]; BONUS_UPC_QTY: nullable decimal[4,0]; COUPON_ID: nullable string[max=30]; RETAIL_ACCOUNT_NO: nullable string[max=6]; PROMO_CODE: nullable string[max=10]; LAST_CONTACT_DATE: nullable timestamp; TOTAL_NUMBER_CONTACTS: nullable decimal[4,0]; AGE_VERIFICATION_CD: nullable string[max=5]; CONTACT_RESULT_DATE: nullable timestamp; BRAND_CD: nullable string[max=5]; CLASSIFICATION_CD: nullable string[max=5]; POSTING_LEVEL_CD: nullable string[max=5]; AS_INTEREST_FLAG: nullable string[max=1]; ADDRESS_TYPE_CD: nullable string[max=5]; OFFER_CATEGORY_CD_1: string[max=5]; PACKAGE_TYPE_CD: nullable string[max=5]; keyChange: int8; OFFER_CD: string[max=3]; )'-outputschema'record ( OPCO_CD: string[max=5]; INDIVIDUAL_ID: decimal[9,0]; BRAND_CD: string[max=5]; PRODUCT_LINE_CD: string[max=5]; CHANNEL_TYPE_CD: string[max=5]; LAST_GIFT_RESPONSE_DATE: nullable timestamp; LAST_COUPON_RESPONSE_DATE: nullable timestamp; LAST_EVENT_RESPONSE_DATE: nullable timestamp; LAST_SWEEPS_CONTEST_RESP_DATE: nullable timestamp; LAST_SURVEY_RESPONSE_DATE: nullable timestamp; LAST_MISC_RESPONSE_DATE: nullable timestamp; LAST_MAILED_DATE: nullable timestamp; LIFETIME_GIFT_RESPONSES: nullable decimal[7,0]; LIFETIME_COUPON_RESPONSES: nullable decimal[7,0]; LIFETIME_EVENT_RESPONSES: nullable decimal[7,0]; LIFETIME_SWEEPS_RESPONSES: nullable decimal[7,0]; LIFETIME_PROGRAMS_MAILED: nullable decimal[7,0]; LAST_PACK_REDEMPTION_DATE: nullable timestamp; LAST_CARTON_REDEMPTION_DATE: nullable timestamp; LAST_COMBO_REDEMPTION_DATE: nullable timestamp; LAST_COUPON_OFFERED_DATE: nullable timestamp; LAST_GIFT_OFFERED_DATE: nullable timestamp; LAST_PROGRAM_RESPONDED_TO: nullable string[max=7]; LAST_PROGRAM_RESPONDED_DATE: nullable timestamp; LAST_OPEN_DATE: nullable timestamp; LAST_CLICK_DATE: nullable timestamp; LIFETIME_OPENED: nullable decimal[7,0]; LIFETIME_CLICKED: nullable decimal[7,0]; LAST_REBUILD_DATE: nullable timestamp; keyChange: int8; )'-expressionfile'RT_SC290/V0S7_DM_INDIVIDUAL_X_BPC_SUMM_Transformer_7.trx'-flag'compile'-compiler'g++'-compileopt'-O -m32 -fPIC -Wno-deprecated -c'-linker'g++'-linkopt'-shared -Wl,-Bsymbolic,--allow-shlib-undefined -m32'-name'V0S7_DM_INDIVIDUAL_X_BPC_SUMM_Transformer_7'-dir'/u01/app/dsadm/Ascential/DataStage/Projects/etldevs1/RT_BP290.O'"
}
}
.
##W TFCP 000000 15:22:19(012) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W TFCP 000025 15:22:19(013) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 15:22:19(014) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 15:22:19(015) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 15:22:19(016) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 15:22:19(017) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 15:22:19(018) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 15:22:19(019) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:22:19(020) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:22:19(021) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:22:19(022) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:22:19(023) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:22:19(024) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:22:19(025) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:22:19(026) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:22:19(027) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:22:19(028) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:22:19(029) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:22:19(030) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:22:19(031) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:22:19(032) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##E TFCP 000000 15:22:19(033) <transform> Error when checking composite operator: Only an input field can be "null"; function argument: [line 118,character 102].
##E TFSR 000019 15:22:19(034) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 15:22:19(035) <main_program> Creation of a step finished with status = FAILED. (DM_INDIVIDUAL_X_BPC_SUMM.Transformer_7)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S7_repos_Transformer_7 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 In1;
0007: outputname 0 DSLink10;
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_0;
0018: string InterVar0_1;
0019: string InterVar0_2;
0020: string InterVar0_3;
0021: string InterVar0_4;
0022: string InterVar0_5;
0023: string InterVar0_6;
0024: string InterVar0_7;
0025: string InterVar0_8;
0026: string InterVar0_9;
0027: string InterVar0_10;
0028: string InterVar0_11;
0029: timestamp InterVar0_12;
0030: string InterVar0_13;
0031: string InterVar0_14;
0032: string InterVar0_15;
0033:
0034: // initialise constant values which require conversion
0035: InterVar0_0 = "I";
0036: InterVar0_1 = "GF";
0037: InterVar0_2 = "CC";
0038: InterVar0_3 = "EV";
0039: InterVar0_4 = "sw";
0040: InterVar0_5 = "SW";
0041: InterVar0_6 = "HR";
0042: InterVar0_7 = "CT, ML, MS, PR, UK, SW, HR";
0043: InterVar0_8 = "O";
0044: InterVar0_9 = 1;
0045: InterVar0_10 = 2;
0046: InterVar0_11 = 0;
0047: InterVar0_12 = timestamp_from_string("NULL");
0048: InterVar0_13 = "EM";
0049: InterVar0_14 = "OPN";
0050: InterVar0_15 = "C";
0051: // Stage variable declaration and initialisation
0052: timestamp StageVar0_LastGiftResponseDate;
0053: StageVar0_LastGiftResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0054: timestamp StageVar0_LastCouponResponseDate;
0055: StageVar0_LastCouponResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0056: timestamp StageVar0_LastEventResponseDate;
0057: StageVar0_LastEventResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0058: timestamp StageVar0_LastSweepsContestRespDate;
0059: StageVar0_LastSweepsContestRespDate = timestamp_from_string("2001-01-01 00:00:01");
0060: timestamp StageVar0_LastSurveyResponseDate;
0061: StageVar0_LastSurveyResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0062: timestamp StageVar0_LastMiscResponseDate;
0063: StageVar0_LastMiscResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0064: timestamp StageVar0_LastMailedDate;
0065: StageVar0_LastMailedDate = timestamp_from_string("2001-01-01 00:00:01");
0066: timestamp StageVar0_LastPackRedemptionDate;
0067: StageVar0_LastPackRedemptionDate = timestamp_from_string("2001-01-01 00:00:01");
0068: timestamp StageVar0_LastCartonRedemptionDate;
0069: StageVar0_LastCartonRedemptionDate = timestamp_from_string("2001-01-01 00:00:01");
0070: timestamp StageVar0_LastComboRedemptionDate;
0071: StageVar0_LastComboRedemptionDate = timestamp_from_string("2001-01-01 00:00:01");
0072: timestamp StageVar0_LastCouponOfferedDate;
0073: StageVar0_LastCouponOfferedDate = timestamp_from_string("2001-01-01 00:00:01");
0074: timestamp StageVar0_LastGiftOfferedDate;
0075: StageVar0_LastGiftOfferedDate = timestamp_from_string("2001-01-01 00:00:01");
0076: timestamp StageVar0_LastProgramRespondedDate;
0077: StageVar0_LastProgramRespondedDate = timestamp_from_string("2001-01-01 00:00:01");
0078: timestamp StageVar0_LastOpenDate;
0079: StageVar0_LastOpenDate = timestamp_from_string("2001-01-01 00:00:01");
0080: timestamp StageVar0_LastClickDate;
0081: StageVar0_LastClickDate = timestamp_from_string("2001-01-01 00:00:01");
0082: decimal[7,0] StageVar0_LifeTimeGiftResposes;
0083: StageVar0_LifeTimeGiftResposes = 0;
0084: decimal[7,0] StageVar0_LifeTimeCouponResponses;
0085: StageVar0_LifeTimeCouponResponses = 0;
0086: decimal[7,0] StageVar0_LifeTimeEventResponses;
0087: StageVar0_LifeTimeEventResponses = 0;
0088: decimal[7,0] StageVar0_LifeTimeSweepsResponses;
0089: StageVar0_LifeTimeSweepsResponses = 0;
0090: decimal[7,0] StageVar0_LifeTimeProgramsMailed;
0091: StageVar0_LifeTimeProgramsMailed = 0;
0092: decimal[7,0] StageVar0_LifeTimeOpened;
0093: StageVar0_LifeTimeOpened = 0;
0094: string StageVar0_LastProgramRespondedTo;
0095: StageVar0_LastProgramRespondedTo = "";
0096: decimal[7,0] StageVar0_LifeTimeClicked;
0097: StageVar0_LifeTimeClicked = 0;
0098: }
0099:
0100: mainloop {
0101: // initialise our row rejected variable
0102: RowRejected0 = 1;
0103:
0104: // declare our intermediate variables for this section
0105: decimal InterVar0_16;
0106: string InterVar0_17;
0107: string InterVar0_18;
0108: string InterVar0_19;
0109:
0110: // evaluate the stage variables first
0111: NullSetVar0 = 0;
0112: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_1))) {
0113: StageVar0_LastGiftResponseDate = In1.CONTACT_DATE;
0114: } else {
0115: if ((In1.keyChange == 1)) {
0116: NullSetVar0 = 1;
0117: } else {
0118: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_1)) && null(StageVar0_LastGiftResponseDate))) {
0119: StageVar0_LastGiftResponseDate = In1.CONTACT_DATE;
0120: } else {
0121: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_1)) && (In1.CONTACT_DATE > StageVar0_LastGiftResponseDate))) {
0122: StageVar0_LastGiftResponseDate = In1.CONTACT_DATE;
0123: } else {
0124: StageVar0_LastGiftResponseDate = StageVar0_LastGiftResponseDate;
0125: }
0126: //;
0127: }
0128: //;
0129: }
0130: //;
0131: }
0132: StageVar0_LastGiftResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastGiftResponseDate;
0133: NullSetVar0 = 0;
0134: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2))) {
0135: StageVar0_LastCouponResponseDate = In1.CONTACT_DATE;
0136: } else {
0137: if ((In1.keyChange == 1)) {
0138: NullSetVar0 = 1;
0139: } else {
0140: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && null(StageVar0_LastCouponResponseDate))) {
0141: StageVar0_LastCouponResponseDate = In1.CONTACT_DATE;
0142: } else {
0143: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.CONTACT_DATE > StageVar0_LastCouponResponseDate))) {
0144: StageVar0_LastCouponResponseDate = In1.CONTACT_DATE;
0145: } else {
0146: StageVar0_LastCouponResponseDate = StageVar0_LastCouponResponseDate;
0147: }
0148: //;
0149: }
0150: //;
0151: }
0152: //;
0153: }
0154: StageVar0_LastCouponResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastCouponResponseDate;
0155: NullSetVar0 = 0;
0156: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_3))) {
0157: StageVar0_LastEventResponseDate = In1.CONTACT_DATE;
0158: } else {
0159: if ((In1.keyChange == 1)) {
0160: NullSetVar0 = 1;
0161: } else {
0162: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_3)) && null(StageVar0_LastEventResponseDate))) {
0163: StageVar0_LastEventResponseDate = In1.CONTACT_DATE;
0164: } else {
0165: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_3)) && (In1.CONTACT_DATE > StageVar0_LastEventResponseDate))) {
0166: StageVar0_LastEventResponseDate = In1.CONTACT_DATE;
0167: } else {
0168: StageVar0_LastEventResponseDate = StageVar0_LastEventResponseDate;
0169: }
0170: //;
0171: }
0172: //;
0173: }
0174: //;
0175: }
0176: StageVar0_LastEventResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastEventResponseDate;
0177: NullSetVar0 = 0;
0178: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_4))) {
0179: StageVar0_LastSweepsContestRespDate = In1.CONTACT_DATE;
0180: } else {
0181: if ((In1.keyChange == 1)) {
0182: NullSetVar0 = 1;
0183: } else {
0184: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_5)) && null(StageVar0_LastSweepsContestRespDate))) {
0185: StageVar0_LastSweepsContestRespDate = In1.CONTACT_DATE;
0186: } else {
0187: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_5)) && (In1.CONTACT_DATE > StageVar0_LastSweepsContestRespDate))) {
0188: StageVar0_LastSweepsContestRespDate = In1.CONTACT_DATE;
0189: } else {
0190: StageVar0_LastSweepsContestRespDate = StageVar0_LastSweepsContestRespDate;
0191: }
0192: //;
0193: }
0194: //;
0195: }
0196: //;
0197: }
0198: StageVar0_LastSweepsContestRespDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastSweepsContestRespDate;
0199: NullSetVar0 = 0;
0200: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_6))) {
0201: StageVar0_LastSurveyResponseDate = In1.CONTACT_DATE;
0202: } else {
0203: if ((In1.keyChange == 1)) {
0204: NullSetVar0 = 1;
0205: } else {
0206: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_6)) && null(StageVar0_LastSurveyResponseDate))) {
0207: StageVar0_LastSurveyResponseDate = In1.CONTACT_DATE;
0208: } else {
0209: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_6)) && (In1.CONTACT_DATE > StageVar0_LastSurveyResponseDate))) {
0210: StageVar0_LastSurveyResponseDate = In1.CONTACT_DATE;
0211: } else {
0212: StageVar0_LastSurveyResponseDate = StageVar0_LastSurveyResponseDate;
0213: }
0214: //;
0215: }
0216: //;
0217: }
0218: //;
0219: }
0220: StageVar0_LastSurveyResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastSurveyResponseDate;
0221: NullSetVar0 = 0;
0222: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_7))) {
0223: StageVar0_LastMiscResponseDate = In1.CONTACT_DATE;
0224: } else {
0225: if ((In1.keyChange == 1)) {
0226: NullSetVar0 = 1;
0227: } else {
0228: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_7)) && null(StageVar0_LastMiscResponseDate))) {
0229: StageVar0_LastMiscResponseDate = In1.CONTACT_DATE;
0230: } else {
0231: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_7)) && (In1.CONTACT_DATE > StageVar0_LastMiscResponseDate))) {
0232: StageVar0_LastMiscResponseDate = In1.CONTACT_DATE;
0233: } else {
0234: StageVar0_LastMiscResponseDate = StageVar0_LastMiscResponseDate;
0235: }
0236: //;
0237: }
0238: //;
0239: }
0240: //;
0241: }
0242: StageVar0_LastMiscResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastMiscResponseDate;
0243: NullSetVar0 = 0;
0244: if (((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_8))) {
0245: StageVar0_LastMailedDate = In1.CONTACT_DATE;
0246: } else {
0247: if ((In1.keyChange == 1)) {
0248: NullSetVar0 = 1;
0249: } else {
0250: if (((In1.CONTACT_INITIATOR_CD == InterVar0_8) && null(StageVar0_LastMailedDate))) {
0251: StageVar0_LastMailedDate = In1.CONTACT_DATE;
0252: } else {
0253: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.CONTACT_DATE > StageVar0_LastMailedDate))) {
0254: StageVar0_LastMailedDate = In1.CONTACT_DATE;
0255: } else {
0256: StageVar0_LastMailedDate = StageVar0_LastMailedDate;
0257: }
0258: //;
0259: }
0260: //;
0261: }
0262: //;
0263: }
0264: StageVar0_LastMailedDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastMailedDate;
0265: NullSetVar0 = 0;
0266: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_9))) {
0267: StageVar0_LastPackRedemptionDate = In1.CONTACT_DATE;
0268: } else {
0269: if ((In1.keyChange == 1)) {
0270: NullSetVar0 = 1;
0271: } else {
0272: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_9)) && null(StageVar0_LastPackRedemptionDate))) {
0273: StageVar0_LastPackRedemptionDate = In1.CONTACT_DATE;
0274: } else {
0275: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_9)) && (In1.CONTACT_DATE > StageVar0_LastPackRedemptionDate))) {
0276: StageVar0_LastPackRedemptionDate = In1.CONTACT_DATE;
0277: } else {
0278: StageVar0_LastPackRedemptionDate = StageVar0_LastPackRedemptionDate;
0279: }
0280: //;
0281: }
0282: //;
0283: }
0284: //;
0285: }
0286: StageVar0_LastPackRedemptionDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastPackRedemptionDate;
0287: NullSetVar0 = 0;
0288: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_10))) {
0289: StageVar0_LastCartonRedemptionDate = In1.CONTACT_DATE;
0290: } else {
0291: if ((In1.keyChange == 1)) {
0292: NullSetVar0 = 1;
0293: } else {
0294: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_10)) && null(StageVar0_LastCartonRedemptionDate))) {
0295: StageVar0_LastCartonRedemptionDate = In1.CONTACT_DATE;
0296: } else {
0297: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_10)) && (In1.CONTACT_DATE > StageVar0_LastCartonRedemptionDate))) {
0298: StageVar0_LastCartonRedemptionDate = In1.CONTACT_DATE;
0299: } else {
0300: StageVar0_LastCartonRedemptionDate = StageVar0_LastCartonRedemptionDate;
0301: }
0302: //;
0303: }
0304: //;
0305: }
0306: //;
0307: }
0308: StageVar0_LastCartonRedemptionDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastCartonRedemptionDate;
0309: NullSetVar0 = 0;
0310: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_11))) {
0311: StageVar0_LastComboRedemptionDate = In1.CONTACT_DATE;
0312: } else {
0313: if ((In1.keyChange == 1)) {
0314: NullSetVar0 = 1;
0315: } else {
0316: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_11)) && null(StageVar0_LastComboRedemptionDate))) {
0317: StageVar0_LastComboRedemptionDate = In1.CONTACT_DATE;
0318: } else {
0319: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_11)) && (In1.CONTACT_DATE > StageVar0_LastComboRedemptionDate))) {
0320: StageVar0_LastComboRedemptionDate = In1.CONTACT_DATE;
0321: } else {
0322: StageVar0_LastComboRedemptionDate = StageVar0_LastComboRedemptionDate;
0323: }
0324: //;
0325: }
0326: //;
0327: }
0328: //;
0329: }
0330: StageVar0_LastComboRedemptionDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastComboRedemptionDate;
0331: StageVar0_LastCouponOfferedDate = InterVar0_12;
0332: StageVar0_LastGiftOfferedDate = InterVar0_12;
0333: NullSetVar0 = 0;
0334: if (((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0))) {
0335: StageVar0_LastProgramRespondedDate = In1.CONTACT_DATE;
0336: } else {
0337: if ((In1.keyChange == 1)) {
0338: NullSetVar0 = 1;
0339: } else {
0340: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && null(StageVar0_LastProgramRespondedDate))) {
0341: StageVar0_LastProgramRespondedDate = In1.CONTACT_DATE;
0342: } else {
0343: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.CONTACT_DATE > StageVar0_LastProgramRespondedDate))) {
0344: StageVar0_LastProgramRespondedDate = In1.CONTACT_DATE;
0345: } else {
0346: StageVar0_LastProgramRespondedDate = StageVar0_LastProgramRespondedDate;
0347: }
0348: //;
0349: }
0350: //;
0351: }
0352: //;
0353: }
0354: StageVar0_LastProgramRespondedDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastProgramRespondedDate;
0355: NullSetVar0 = 0;
0356: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (In1.OFFER_CD == InterVar0_14))) {
0357: StageVar0_LastOpenDate = In1.CONTACT_DATE;
0358: } else {
0359: if ((In1.keyChange == 1)) {
0360: NullSetVar0 = 1;
0361: } else {
0362: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (In1.OFFER_CD == InterVar0_14)) && null(StageVar0_LastOpenDate))) {
0363: StageVar0_LastOpenDate = In1.CONTACT_DATE;
0364: } else {
0365: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (In1.OFFER_CD == InterVar0_14)) && (In1.CONTACT_DATE > StageVar0_LastOpenDate))) {
0366: StageVar0_LastOpenDate = In1.CONTACT_DATE;
0367: } else {
0368: StageVar0_LastOpenDate = StageVar0_LastOpenDate;
0369: }
0370: //;
0371: }
0372: //;
0373: }
0374: //;
0375: }
0376: StageVar0_LastOpenDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastOpenDate;
0377: NullSetVar0 = 0;
0378: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (substring_1(In1.OFFER_CD , 1 , 1) == InterVar0_15))) {
0379: StageVar0_LastClickDate = In1.CONTACT_DATE;
0380: } else {
0381: if ((In1.keyChange == 1)) {
0382: NullSetVar0 = 1;
0383: } else {
0384: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (substring_1(In1.OFFER_CD , 1 , 1) == InterVar0_15)) && null(StageVar0_LastClickDate))) {
0385: StageVar0_LastClickDate = In1.CONTACT_DATE;
0386: } else {
0387: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (substring_1(In1.OFFER_CD , 1 , 1) == InterVar0_15)) && (In1.CONTACT_DATE > StageVar0_LastClickDate))) {
0388: StageVar0_LastClickDate = In1.CONTACT_DATE;
0389: } else {
0390: StageVar0_LastClickDate = StageVar0_LastClickDate;
0391: }
0392: //;
0393: }
0394: //;
0395: }
0396: //;
0397: }
0398: StageVar0_LastClickDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastClickDate;
0399: NullSetVar0 = 0;
0400: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_1))) {
0401: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.OFFER_CATEGORY_CD , 2);
0402: StageVar0_LifeTimeGiftResposes = InterVar0_16;
0403: } else {
0404: NullSetVar0 = 1;
0405: }
0406: StageVar0_LifeTimeGiftResposes = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeGiftResposes;
0407: NullSetVar0 = 0;
0408: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2))) {
0409: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.OFFER_CATEGORY_CD , 2);
0410: StageVar0_LifeTimeCouponResponses = InterVar0_16;
0411: } else {
0412: NullSetVar0 = 1;
0413: }
0414: StageVar0_LifeTimeCouponResponses = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeCouponResponses;
0415: NullSetVar0 = 0;
0416: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_3))) {
0417: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.MEDIA_CATEGORY_CD , 2);
0418: StageVar0_LifeTimeEventResponses = InterVar0_16;
0419: } else {
0420: NullSetVar0 = 1;
0421: }
0422: StageVar0_LifeTimeEventResponses = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeEventResponses;
0423: NullSetVar0 = 0;
0424: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_5))) {
0425: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.OFFER_CATEGORY_CD , 2);
0426: StageVar0_LifeTimeSweepsResponses = InterVar0_16;
0427: } else {
0428: NullSetVar0 = 1;
0429: }
0430: StageVar0_LifeTimeSweepsResponses = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeSweepsResponses;
0431: NullSetVar0 = 0;
0432: if (((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_8))) {
0433: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.CONTACT_INITIATOR_CD , 1);
0434: StageVar0_LifeTimeProgramsMailed = InterVar0_16;
0435: } else {
0436: NullSetVar0 = 1;
0437: }
0438: StageVar0_LifeTimeProgramsMailed = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeProgramsMailed;
0439: NullSetVar0 = 0;
0440: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (In1.OFFER_CD == InterVar0_14))) {
0441: InterVar0_17 = string_num_compare(In1.MEDIA_CATEGORY_CD , In1.OFFER_CD , 3);
0442: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , InterVar0_17 , 3);
0443: StageVar0_LifeTimeOpened = InterVar0_16;
0444: } else {
0445: NullSetVar0 = 1;
0446: }
0447: StageVar0_LifeTimeOpened = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeOpened;
0448: NullSetVar0 = 0;
0449: if (((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0))) {
0450: InterVar0_17 = In1.PROGRAM_NUMBER == string_from_timestamp(In1.CONTACT_DATE);
0451: StageVar0_LastProgramRespondedTo = InterVar0_17;
0452: } else {
0453: if ((In1.keyChange == 1)) {
0454: NullSetVar0 = 1;
0455: } else {
0456: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && null(StageVar0_LastProgramRespondedTo))) {
0457: InterVar0_18 = In1.PROGRAM_NUMBER == string_from_timestamp(In1.CONTACT_DATE);
0458: StageVar0_LastProgramRespondedTo = InterVar0_18;
0459: } else {
0460: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.CONTACT_DATE > timestamp_from_string(StageVar0_LastProgramRespondedTo)))) {
0461: InterVar0_19 = In1.PROGRAM_NUMBER == string_from_timestamp(In1.CONTACT_DATE);
0462: StageVar0_LastProgramRespondedTo = InterVar0_19;
0463: } else {
0464: StageVar0_LastProgramRespondedTo = StageVar0_LastProgramRespondedTo;
0465: }
0466: //;
0467: }
0468: //;
0469: }
0470: //;
0471: }
0472: StageVar0_LastProgramRespondedTo = (NullSetVar0 == 1) ? set_null() : StageVar0_LastProgramRespondedTo;
0473: NullSetVar0 = 0;
0474: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (substring_1(In1.OFFER_CD , 1 , 1) == InterVar0_15))) {
0475: InterVar0_17 = string_num_compare(In1.MEDIA_CATEGORY_CD , In1.OFFER_CD , 2);
0476: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , InterVar0_17 , 2);
0477: StageVar0_LifeTimeClicked = InterVar0_16;
0478: } else {
0479: NullSetVar0 = 1;
0480: }
0481: StageVar0_LifeTimeClicked = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeClicked;
0482:
0483: // evaluate columns (no constraints) for link: DSLink10
0484: DSLink10.OPCO_CD = In1.OPCO_CD;
0485: DSLink10.INDIVIDUAL_ID = In1.INDIVIDUAL_ID;
0486: DSLink10.BRAND_CD = In1.BRAND_CD;
0487: DSLink10.PRODUCT_LINE_CD = In1.PRODUCT_LINE_CD;
0488: DSLink10.CHANNEL_TYPE_CD = In1.CHANNEL_TYPE_CD;
0489: DSLink10.LAST_GIFT_RESPONSE_DATE = StageVar0_LastGiftResponseDate;
0490: DSLink10.LAST_COUPON_RESPONSE_DATE = StageVar0_LastCouponResponseDate;
0491: DSLink10.LAST_EVENT_RESPONSE_DATE = StageVar0_LastEventResponseDate;
0492: DSLink10.LAST_SWEEPS_CONTEST_RESP_DATE = StageVar0_LastSweepsContestRespDate;
0493: DSLink10.LAST_SURVEY_RESPONSE_DATE = StageVar0_LastSurveyResponseDate;
0494: DSLink10.LAST_MISC_RESPONSE_DATE = StageVar0_LastMiscResponseDate;
0495: DSLink10.LAST_MAILED_DATE = StageVar0_LastMailedDate;
0496: DSLink10.LIFETIME_GIFT_RESPONSES = StageVar0_LifeTimeGiftResposes;
0497: DSLink10.LIFETIME_COUPON_RESPONSES = StageVar0_LifeTimeCouponResponses;
0498: DSLink10.LIFETIME_EVENT_RESPONSES = StageVar0_LifeTimeEventResponses;
0499: DSLink10.LIFETIME_SWEEPS_RESPONSES = StageVar0_LifeTimeSweepsResponses;
0500: DSLink10.LIFETIME_PROGRAMS_MAILED = StageVar0_LifeTimeProgramsMailed;
0501: DSLink10.LAST_PACK_REDEMPTION_DATE = StageVar0_LastPackRedemptionDate;
0502: DSLink10.LAST_CARTON_REDEMPTION_DATE = StageVar0_LastCartonRedemptionDate;
0503: DSLink10.LAST_COMBO_REDEMPTION_DATE = StageVar0_LastComboRedemptionDate;
0504: DSLink10.LAST_COUPON_OFFERED_DATE = StageVar0_LastCouponOfferedDate;
0505: DSLink10.LAST_GIFT_OFFERED_DATE = StageVar0_LastGiftOfferedDate;
0506: DSLink10.LAST_PROGRAM_RESPONDED_TO = StageVar0_LastProgramRespondedTo;
0507: DSLink10.LAST_PROGRAM_RESPONDED_DATE = StageVar0_LastProgramRespondedDate;
0508: DSLink10.LAST_OPEN_DATE = StageVar0_LastOpenDate;
0509: DSLink10.LAST_CLICK_DATE = StageVar0_LastClickDate;
0510: DSLink10.LIFETIME_OPENED = StageVar0_LifeTimeOpened;
0511: DSLink10.LIFETIME_CLICKED = StageVar0_LifeTimeClicked;
0512: writerecord 0;
0513: RowRejected0 = 0;
0514: }
0515:
0516: finish {
0517: }
0518:
*** End of Internal Generated Transformer Code

vinothkumar · Post by **vinothkumar** » Wed Sep 08, 2010 2:47 pm

Can you please what are doing with StageVar0_LastGiftResponseDate. Because the error message has ...
"##E TFCP 000000 15:22:19(033) <transform> Error when checking composite operator: Only an input field can be "null"; function argument: [line 118,character 102]. ".

kumar_s · Post by **kumar_s** » Wed Sep 08, 2010 3:02 pm

Is this the first time you compiling this job in this environment? Does the other job compile without any issue?
Have you compiled this job in any other environment?

sush26283 · Post by **sush26283** » Wed Sep 08, 2010 3:18 pm

kumar_s wrote:Is this the first time you compiling this job in this environment? Does the other job compile without any issue?
Have you compiled this job in any other environment? ...

Hi
yes this is the first time am compiling this job inthis environment...and its for the first time that this job is being compiled in any environment as i have formed it from scratch...

kumar_s · Post by **kumar_s** » Wed Sep 08, 2010 3:37 pm

How about the answer to my other questioon?
Is this the first job thats been compiled in the environment?
Just to make sure, wheather the issue is with your code or with the environment.

sush26283 · Post by **sush26283** » Wed Sep 08, 2010 3:43 pm

kumar_s wrote:How about the answer to my other questioon?
Is this the first job thats been compiled in the environment?
Just to make sure, wheather the issue is with your code or with the environment. ...

nope...

kumar_s · Post by **kumar_s** » Wed Sep 08, 2010 4:00 pm

Parameter specified but not used in flow: DSPXWorkingDir

Did you try setting up the PWD Environmental variable?
If now try settting to current project directory or '.'.
Is your compiler path set up right?