error in parallel transformer stage
Posted: Thu Jul 13, 2006 3:17 am
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
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