error in parallel transformer stage

[bhargava129189]

1) as before requested i am pasting the complete compilation out put.

Not able to use IsNull and IsNotNull functions in parallel transformer stage and also not able to use job parameters in derivation part of transformer. neither in stage variables nor in output column derivations.


Output from transformer compilation follows:

##I TFCN 000001 04:14:36(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TUTL 000031 04:14:36(001) <main_program> The open files limit is 3500; raising to 4096.
##I TOSH 000002 04:14:36(002) <main_program> orchgeneral: loaded
##I TOSH 000002 04:14:36(003) <main_program> orchsort: loaded
##I TOSH 000002 04:14:36(004) <main_program> orchstats: loaded
##I TFSC 000001 04:14:36(007) <main_program> APT configuration file: /dsstg/Ascential/DataStage/Configurations/default.apt
##I TFSC 000000 04:14:36(008) <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 (
node0[op0,p0]
)}
It runs 1 process on 1 node.
##W TCOS 000049 04:14:38(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (Nxrp_Trn_Tfs_Gos_Dtl_P2.Tfm_Insert)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S16_Nxrp_Trn_Tfs_Gos_Dtl_P2_Tfm_Insert transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl;
0007: outputname 0 Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej;
0008: outputname 1 Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1;
0009: outputname 2 Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2;
0010: outputname 3 Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl;
0011:
0012: initialize {
0013: // define our row rejected variable
0014: int8 RowRejected0;
0015:
0016: // define our null set variable
0017: int8 NullSetVar0;
0018:
0019: // declare our intermediate variables for this section
0020: string InterVar0_0;
0021: string InterVar0_1;
0022: string InterVar0_2;
0023: string InterVar0_3;
0024: string InterVar0_5;
0025: decimal InterVar0_6;
0026: decimal InterVar0_7;
0027: decimal InterVar0_8;
0028:
0029: // initialise constant values which require conversion
0030: InterVar0_0 = 1;
0031: InterVar0_1 = 0;
0032: InterVar0_2 = "D";
0033: InterVar0_3 = "N";
0034: InterVar0_5 = "1";
0035: InterVar0_6 = 1500;
0036: InterVar0_7 = 1501;
0037: InterVar0_8 = 1527;
0038: // Stage variable declaration and initialisation
0039: string StageVar0_StageVar1;
0040: StageVar0_StageVar1 = "";
0041: string StageVar0_StageVar2;
0042: StageVar0_StageVar2 = "";
0043: string StageVar0_StageVar3;
0044: StageVar0_StageVar3 = "";
0045: string StageVar0_StageVarNull;
0046: StageVar0_StageVarNull = "";
0047: string StageVar0_StageVar;
0048: StageVar0_StageVar = "";
0049: }
0050:
0051: mainloop {
0052: // initialise our row rejected variable
0053: RowRejected0 = 1;
0054:
0055: // declare our intermediate variables for this section
0056: string InterVar0_4;
0057:
0058: // evaluate the stage variables first
0059: if (((((((((null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE)) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CITY))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STATE))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.COUNTRY))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DISPOS)))) {
0060: StageVar0_StageVar1 = StageVar0_StageVar1;
0061: } else {
0062: StageVar0_StageVar1 = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM);
0063: }
0064: //;
0065: if (((((((((null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE)) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CITY))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STATE))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.COUNTRY))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DISPOS)))) {
0066: StageVar0_StageVar2 = StageVar0_StageVar2;
0067: } else {
0068: StageVar0_StageVar2 = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE);
0069: }
0070: //;
0071: if (((((((((null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE)) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CITY))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STATE))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.COUNTRY))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DISPOS)))) {
0072: StageVar0_StageVar3 = StageVar0_StageVar3;
0073: } else {
0074: StageVar0_StageVar3 = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME);
0075: }
0076: //;
0077: if (((((((((null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE)) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CITY))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STATE))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.COUNTRY))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM))) || null(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DISPOS)))) {
0078: StageVar0_StageVarNull = InterVar0_0;
0079: } else {
0080: StageVar0_StageVarNull = InterVar0_1;
0081: }
0082: //;
0083: if ((((StageVar0_StageVar1 == trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM)) && (StageVar0_StageVar2 == trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE))) && (StageVar0_StageVar3 == trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME)))) {
0084: StageVar0_StageVar = InterVar0_2;
0085: } else {
0086: StageVar0_StageVar = InterVar0_3;
0087: }
0088: //;
0089:
0090: // evaluate constraint and columns for link: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej
0091: if ((StageVar0_StageVarNull == InterVar0_0))
0092: {
0093: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.ENTID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ENTID);
0094: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.CORP_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CORP_ID);
0095: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.DIALNUM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DIALNUM);
0096: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.HIDDENNUM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.HIDDENNUM);
0097: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.NC_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.NC_ID);
0098: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.STRT_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE));
0099: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.STRT_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME);
0100: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.END_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE));
0101: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.END_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME);
0102: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.DURATION = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DURATION);
0103: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.TLK_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.TLK_TIME);
0104: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.CLI = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CLI);
0105: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.CITY = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CITY);
0106: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.STATE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STATE);
0107: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.COUNTRY = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.COUNTRY);
0108: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.REC_TYPE;
0109: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.REC_TYPE = trimc_string(InterVar0_4);
0110: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.IOIND = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.IOIND);
0111: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.FEATURE;
0112: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.FEATURE = trimc_string(InterVar0_4);
0113: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ORIG_CLASS;
0114: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.ORIG_CLASS = trimc_string(InterVar0_4);
0115: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.ACSS_TYPE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ACSS_TYPE);
0116: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.ATERM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM);
0117: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.ANCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ANCODE);
0118: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.PORT_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PORT_ID);
0119: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.INTERM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.INTERM);
0120: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.INCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.INCODE);
0121: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.DISPOS = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DISPOS);
0122: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.SUPPCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.SUPPCODE);
0123: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.DNIS = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DNIS);
0124: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.NCRCOUNT;
0125: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.NCRCOUNT = trimc_string(InterVar0_4);
0126: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OFLWREAS;
0127: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.OFLWREAS = trimc_string(InterVar0_4);
0128: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OVFLFLT;
0129: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.OVFLFLT = trimc_string(InterVar0_4);
0130: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.ECR = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECR);
0131: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.OPRSEIZTIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OPRSEIZTIME);
0132: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECRCOUNT;
0133: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.ECRCOUNT = trimc_string(InterVar0_4);
0134: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.ECRBRNA = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECRBRNA);
0135: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.PROD_START_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_START_DATE));
0136: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.PROD_START_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_START_TIME);
0137: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.PROD_END_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_END_DATE));
0138: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.PROD_END_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_END_TIME);
0139: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.PROD_DURATION = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_DURATION);
0140: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.CTR_ID = InterVar0_5;
0141: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej.REJ_CODE = InterVar0_6;
0142: writerecord 0;
0143: RowRejected0 = 0;
0144: }
0145: // evaluate constraint and columns for link: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1
0146: if (((StageVar0_StageVar == InterVar0_2) && (StageVar0_StageVarNull == InterVar0_1)))
0147: {
0148: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.ENTID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ENTID);
0149: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.CORP_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CORP_ID);
0150: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.DIALNUM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DIALNUM);
0151: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.HIDDENNUM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.HIDDENNUM);
0152: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.NC_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.NC_ID);
0153: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.STRT_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE));
0154: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.STRT_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME);
0155: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.END_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE));
0156: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.END_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME);
0157: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.DURATION = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DURATION);
0158: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.TLK_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.TLK_TIME);
0159: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.CLI = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CLI);
0160: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.CITY = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CITY);
0161: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.STATE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STATE);
0162: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.COUNTRY = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.COUNTRY);
0163: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.REC_TYPE;
0164: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.REC_TYPE = trimc_string(InterVar0_4);
0165: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.IOIND = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.IOIND);
0166: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.FEATURE;
0167: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.FEATURE = trimc_string(InterVar0_4);
0168: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ORIG_CLASS;
0169: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.ORIG_CLASS = trimc_string(InterVar0_4);
0170: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.ACSS_TYPE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ACSS_TYPE);
0171: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.ATERM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM);
0172: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.ANCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ANCODE);
0173: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.PORT_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PORT_ID);
0174: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.INTERM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.INTERM);
0175: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.INCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.INCODE);
0176: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.DISPOS = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DISPOS);
0177: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.SUPPCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.SUPPCODE);
0178: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.DNIS = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DNIS);
0179: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.NCRCOUNT;
0180: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.NCRCOUNT = trimc_string(InterVar0_4);
0181: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OFLWREAS;
0182: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.OFLWREAS = trimc_string(InterVar0_4);
0183: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OVFLFLT;
0184: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.OVFLFLT = trimc_string(InterVar0_4);
0185: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.ECR = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECR);
0186: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.OPRSEIZTIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OPRSEIZTIME);
0187: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECRCOUNT;
0188: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.ECRCOUNT = trimc_string(InterVar0_4);
0189: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.ECRBRNA = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECRBRNA);
0190: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.PROD_START_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_START_DATE));
0191: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.PROD_START_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_START_TIME);
0192: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.PROD_END_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_END_DATE));
0193: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.PROD_END_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_END_TIME);
0194: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.PROD_DURATION = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_DURATION);
0195: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.CTR_ID = InterVar0_5;
0196: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej1.REJ_CODE = InterVar0_7;
0197: writerecord 1;
0198: RowRejected0 = 0;
0199: }
0200: // evaluate constraint and columns for link: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2
0201: if (((trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE) < trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE)) || (trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME) < trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME))))
0202: {
0203: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.ENTID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ENTID);
0204: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.CORP_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CORP_ID);
0205: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.DIALNUM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DIALNUM);
0206: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.HIDDENNUM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.HIDDENNUM);
0207: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.NC_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.NC_ID);
0208: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.STRT_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE));
0209: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.STRT_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME);
0210: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.END_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE));
0211: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.END_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME);
0212: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.DURATION = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DURATION);
0213: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.TLK_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.TLK_TIME);
0214: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.CLI = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CLI);
0215: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.CITY = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CITY);
0216: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.STATE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STATE);
0217: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.COUNTRY = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.COUNTRY);
0218: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.REC_TYPE;
0219: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.REC_TYPE = trimc_string(InterVar0_4);
0220: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.IOIND = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.IOIND);
0221: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.FEATURE;
0222: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.FEATURE = trimc_string(InterVar0_4);
0223: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ORIG_CLASS;
0224: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.ORIG_CLASS = trimc_string(InterVar0_4);
0225: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.ACSS_TYPE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ACSS_TYPE);
0226: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.ATERM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM);
0227: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.ANCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ANCODE);
0228: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.PORT_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PORT_ID);
0229: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.INTERM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.INTERM);
0230: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.INCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.INCODE);
0231: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.DISPOS = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DISPOS);
0232: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.SUPPCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.SUPPCODE);
0233: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.DNIS = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DNIS);
0234: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.NCRCOUNT;
0235: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.NCRCOUNT = trimc_string(InterVar0_4);
0236: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OFLWREAS;
0237: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.OFLWREAS = trimc_string(InterVar0_4);
0238: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OVFLFLT;
0239: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.OVFLFLT = trimc_string(InterVar0_4);
0240: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.ECR = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECR);
0241: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.OPRSEIZTIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OPRSEIZTIME);
0242: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECRCOUNT;
0243: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.ECRCOUNT = trimc_string(InterVar0_4);
0244: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.ECRBRNA = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECRBRNA);
0245: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.PROD_START_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_START_DATE));
0246: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.PROD_START_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_START_TIME);
0247: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.PROD_END_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_END_DATE));
0248: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.PROD_END_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_END_TIME);
0249: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.PROD_DURATION = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_DURATION);
0250: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.CTR_ID = InterVar0_5;
0251: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl_Rej2.REJ_CODE = InterVar0_8;
0252: writerecord 2;
0253: RowRejected0 = 0;
0254: }
0255: // evaluate constraint and columns for link: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl
0256: if ((((StageVar0_StageVarNull == InterVar0_1) && (StageVar0_StageVar == InterVar0_3)) && (((trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE) < trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE)) || (trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME) < trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME))) == 0)))
0257: {
0258: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.ENTID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ENTID);
0259: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.CORP_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CORP_ID);
0260: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.DIALNUM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DIALNUM);
0261: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.HIDDENNUM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.HIDDENNUM);
0262: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.NC_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.NC_ID);
0263: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.STRT_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_DATE));
0264: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.STRT_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STRT_TIME);
0265: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.END_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_DATE));
0266: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.END_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.END_TIME);
0267: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.DURATION = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DURATION);
0268: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.TLK_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.TLK_TIME);
0269: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.CLI = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CLI);
0270: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.CITY = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.CITY);
0271: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.STATE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.STATE);
0272: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.COUNTRY = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.COUNTRY);
0273: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.REC_TYPE;
0274: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.REC_TYPE = trimc_string(InterVar0_4);
0275: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.IOIND = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.IOIND);
0276: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.FEATURE;
0277: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.FEATURE = trimc_string(InterVar0_4);
0278: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ORIG_CLASS;
0279: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.ORIG_CLASS = trimc_string(InterVar0_4);
0280: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.ACSS_TYPE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ACSS_TYPE);
0281: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.ATERM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ATERM);
0282: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.ANCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ANCODE);
0283: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.PORT_ID = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PORT_ID);
0284: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.INTERM = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.INTERM);
0285: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.INCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.INCODE);
0286: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.DISPOS = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DISPOS);
0287: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.SUPPCODE = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.SUPPCODE);
0288: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.DNIS = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.DNIS);
0289: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.NCRCOUNT;
0290: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.NCRCOUNT = trimc_string(InterVar0_4);
0291: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OFLWREAS;
0292: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.OFLWREAS = trimc_string(InterVar0_4);
0293: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OVFLFLT;
0294: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.OVFLFLT = trimc_string(InterVar0_4);
0295: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.ECR = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECR);
0296: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.OPRSEIZTIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.OPRSEIZTIME);
0297: InterVar0_4 = Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECRCOUNT;
0298: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.ECRCOUNT = trimc_string(InterVar0_4);
0299: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.ECRBRNA = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.ECRBRNA);
0300: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.PROD_START_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_START_DATE));
0301: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.PROD_START_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_START_TIME);
0302: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.PROD_END_DATE = timestamp_from_string(trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_END_DATE));
0303: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.PROD_END_TIME = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_END_TIME);
0304: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.PROD_DURATION = trimc_string(Lnk_Src_Extract_Nxrp_Tfs_Gos_Dtl.PROD_DURATION);
0305: Lnk_Tgt_Ins_Nxrp_Tfs_Gos_Dtl.CTR_ID = InterVar0_5;
0306: writerecord 3;
0307: RowRejected0 = 0;
0308: }
0309: }
0310:
0311: finish {
0312: }
0313:
*** End of Internal Generated Transformer Code

[bhargava129189]

this is the error when using job parameter with the remaining code being same.


##W TCOS 000049 04:18:28(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W TFCP 000000 04:18:28(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##E TFCP 000001 04:18:28(003) <transform> Error when checking composite operator: Unexpected tokens: ; [line 14,character 7].
##E TFCP 000012 04:18:28(004) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 14, character 7].
##E TFCP 000001 04:18:28(005) <transform> Error when checking composite operator: Unexpected tokens: ; [line 145,character 44].
##E TFCP 000027 04:18:28(006) <transform> Error when checking composite operator: Expected an operand; [line 145, character 42].
##E TFCP 000038 04:18:28(007) <transform> Error when checking composite operator: Expected semi-colon; [line 145, character 44].
##E TFSR 000019 04:18:28(008) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 04:18:28(009) <main_program> Creation of a step finished with status = FAILED. (Nxrp_Trn_Tfs_Gos_Dtl_P2.Tfm_Insert)

[opdas]

Can you post the derivation part you are writing when you use the null function and use parameters in the derivation ?

[Krazykoolrohit]

all the columns which you are using for any calculations in the stage variables in transformer have to be handled for nulls. Just make sure.