Hi
I am getting compilation error. Parameter specified but not used in flow: DSWorkingDir
When I removed the stage variable of the Relation then it is working fine. But I need to substring of the Relation.
Any inputs greatly appreciated.
Source column: Relation/Integer/2
Transformer stage variable\ Derivation\data type: Stg1 Input_Lnk.RELATION [1, 1] Varchar 1
Column: relation/varchar/1
Final transformer Stage
Column: RelId/Varchar/15
Transformer stage column derivation: Relation: Age
Target column: personId/varchar 15
Thanks and Regards,
Suri.
compilation error. Parameter specified but not used in flow
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
Output from transformer compilation follows:
##I TFCN 000001 01:46:17(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 01:46:17(001) <main_program> The open files limit is 2048; raising to 4096.
##I TOSH 000002 01:46:18(000) <main_program> orchgeneral: loaded
##I TOSH 000002 01:46:18(001) <main_program> orchsort: loaded
##I TOSH 000002 01:46:19(000) <main_program> orchstats: loaded
##I TFSC 000001 01:46:20(000) <main_program> APT configuration file: /dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 01:46:22(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (LABPXITransformProcJob1_PXI.LABPXITrans_Tmr2)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V110S0_repos_LABPXITrans_Tmr2 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 LabInp_Lnk;
0007: outputname 0 DIIDEN_lkp_Lnk;
0008: outputname 1 SCRAMBLE_Lkp_Lnk;
0009:
0010: global {
0011: // Job parameter declaration
0012: string DeIdentification;
0013: }
0014:
0015: initialize {
0016: // define our row rejected variable
0017: int8 RowRejected0;
0018:
0019: // define our null set variable
0020: int8 NullSetVar0;
0021:
0022: // declare our intermediate variables for this section
0023: string InterVar0_2;
0024: string InterVar0_3;
0025: string InterVar0_4;
0026: string InterVar0_6;
0027: string InterVar0_7;
0028: string InterVar0_8;
0029:
0030: // initialise constant values which require conversion
0031: InterVar0_2 = "";
0032: InterVar0_3 = "N";
0033: InterVar0_4 = "0";
0034: InterVar0_6 = "Y";
0035: InterVar0_7 = "17000101";
0036: InterVar0_8 = "0000";
0037: // Stage variable declaration and initialisation
0038: string StageVar0_IngxRelationStgVar;
0039: StageVar0_IngxRelationStgVar = "";
0040: string StageVar0_GendidStgVar;
0041: StageVar0_GendidStgVar = "";
0042: string StageVar0_IngxRelationStgVar1;
0043: StageVar0_IngxRelationStgVar1 = "";
0044: string StageVar0_GendidStgVar1;
0045: StageVar0_GendidStgVar1 = "";
0046: }
0047:
0048: mainloop {
0049: // initialise our row rejected variable
0050: RowRejected0 = 1;
0051:
0052: // declare our intermediate variables for this section
0053: string InterVar0_0;
0054: string InterVar0_1;
0055: int32 InterVar0_5;
0056:
0057: // evaluate the stage variables first
0058: InterVar0_0 = LabInp_Lnk.INGX_RELATION;
0059: if (notnull(trimc_string(InterVar0_0))) {
0060: InterVar0_1 = LabInp_Lnk.INGX_RELATION;
0061: StageVar0_IngxRelationStgVar = trimc_string(InterVar0_1);
0062: } else {
0063: StageVar0_IngxRelationStgVar = InterVar0_2;
0064: }
0065: //;
0066: if (notnull(LabInp_Lnk.GENDID)) {
0067: InterVar0_0 = LabInp_Lnk.GENDID;
0068: StageVar0_GendidStgVar = InterVar0_0;
0069: } else {
0070: StageVar0_GendidStgVar = InterVar0_2;
0071: }
0072: //;
0073: StageVar0_IngxRelationStgVar1 = substring_1(StageVar0_IngxRelationStgVar , 1 , 1);
0074: InterVar0_0 = LabInp_Lnk.GENDID;
0075: StageVar0_GendidStgVar1 = trimc_string(InterVar0_0);
0076:
0077: // evaluate constraint and columns for link: DIIDEN_lkp_Lnk
0078: if ((DeIdentification == InterVar0_3))
0079: {
0080: DIIDEN_lkp_Lnk.EE_SSN = LabInp_Lnk.EE_SSN;
0081: InterVar0_5 = 9 - string_length(trimc_string(LabInp_Lnk.EE_SSN));
0082: DIIDEN_lkp_Lnk.DIN_PERSON_ID_src = (string_of_substring(InterVar0_4 , InterVar0_5) + trimc_string(LabInp_Lnk.EE_SSN));
0083: InterVar0_5 = 2 - string_length(trimc_string(StageVar0_IngxRelationStgVar));
0084: DIIDEN_lkp_Lnk.DIN_SUFFIX_src = (((string_of_substring(InterVar0_4 , InterVar0_5) + trimc_string(StageVar0_IngxRelationStgVar)) + LabInp_Lnk.DOB) + trimc_string(StageVar0_GendidStgVar));
0085: writerecord 0;
0086: RowRejected0 = 0;
0087: }
0088: // evaluate constraint and columns for link: SCRAMBLE_Lkp_Lnk
0089: if ((DeIdentification == InterVar0_6))
0090: {
0091: SCRAMBLE_Lkp_Lnk.LAB_SERV_FROM_MTH_ID = LabInp_Lnk.LAB_SERV_FROM_MTH_ID;
0092: SCRAMBLE_Lkp_Lnk.EE_SSN = LabInp_Lnk.EE_SSN;
0093: if ((trim_leading_trailing(substring_1(LabInp_Lnk.DOB , 1 ,
) == InterVar0_7)) {
0094: SCRAMBLE_Lkp_Lnk.DOB = InterVar0_8;
0095: } else {
0096: SCRAMBLE_Lkp_Lnk.DOB = LabInp_Lnk.DOB;
0097: }
0098: //;
0099: SCRAMBLE_Lkp_Lnk.INGX_RELATION = StageVar0_IngxRelationStgVar1;
0100: SCRAMBLE_Lkp_Lnk.GENDID = StageVar0_GendidStgVar1;
0101: SCRAMBLE_Lkp_Lnk.SOURCE1 = substring_1(LabInp_Lnk.EE_SSN , 1 , 1);
0102: SCRAMBLE_Lkp_Lnk.SOURCE2 = substring_1(LabInp_Lnk.EE_SSN , 2 , 1);
0103: SCRAMBLE_Lkp_Lnk.SOURCE3 = substring_1(LabInp_Lnk.EE_SSN , 3 , 1);
0104: SCRAMBLE_Lkp_Lnk.SOURCE4 = substring_1(LabInp_Lnk.EE_SSN , 4 , 1);
0105: SCRAMBLE_Lkp_Lnk.SOURCE5 = substring_1(LabInp_Lnk.EE_SSN , 5 , 1);
0106: SCRAMBLE_Lkp_Lnk.SOURCE6 = substring_1(LabInp_Lnk.EE_SSN , 6 , 1);
0107: SCRAMBLE_Lkp_Lnk.SOURCE7 = substring_1(LabInp_Lnk.EE_SSN , 7 , 1);
0108: SCRAMBLE_Lkp_Lnk.SOURCE8 = substring_1(LabInp_Lnk.EE_SSN , 8 , 1);
0109: SCRAMBLE_Lkp_Lnk.SOURCE9 = substring_1(LabInp_Lnk.EE_SSN , 9 , 1);
0110: writerecord 1;
0111: RowRejected0 = 0;
0112: }
0113: }
0114:
0115: finish {
0116: }
0117:
*** End of Internal Generated Transformer Code
##I TFCN 000001 01:46:17(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 01:46:17(001) <main_program> The open files limit is 2048; raising to 4096.
##I TOSH 000002 01:46:18(000) <main_program> orchgeneral: loaded
##I TOSH 000002 01:46:18(001) <main_program> orchsort: loaded
##I TOSH 000002 01:46:19(000) <main_program> orchstats: loaded
##I TFSC 000001 01:46:20(000) <main_program> APT configuration file: /dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 01:46:22(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (LABPXITransformProcJob1_PXI.LABPXITrans_Tmr2)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V110S0_repos_LABPXITrans_Tmr2 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 LabInp_Lnk;
0007: outputname 0 DIIDEN_lkp_Lnk;
0008: outputname 1 SCRAMBLE_Lkp_Lnk;
0009:
0010: global {
0011: // Job parameter declaration
0012: string DeIdentification;
0013: }
0014:
0015: initialize {
0016: // define our row rejected variable
0017: int8 RowRejected0;
0018:
0019: // define our null set variable
0020: int8 NullSetVar0;
0021:
0022: // declare our intermediate variables for this section
0023: string InterVar0_2;
0024: string InterVar0_3;
0025: string InterVar0_4;
0026: string InterVar0_6;
0027: string InterVar0_7;
0028: string InterVar0_8;
0029:
0030: // initialise constant values which require conversion
0031: InterVar0_2 = "";
0032: InterVar0_3 = "N";
0033: InterVar0_4 = "0";
0034: InterVar0_6 = "Y";
0035: InterVar0_7 = "17000101";
0036: InterVar0_8 = "0000";
0037: // Stage variable declaration and initialisation
0038: string StageVar0_IngxRelationStgVar;
0039: StageVar0_IngxRelationStgVar = "";
0040: string StageVar0_GendidStgVar;
0041: StageVar0_GendidStgVar = "";
0042: string StageVar0_IngxRelationStgVar1;
0043: StageVar0_IngxRelationStgVar1 = "";
0044: string StageVar0_GendidStgVar1;
0045: StageVar0_GendidStgVar1 = "";
0046: }
0047:
0048: mainloop {
0049: // initialise our row rejected variable
0050: RowRejected0 = 1;
0051:
0052: // declare our intermediate variables for this section
0053: string InterVar0_0;
0054: string InterVar0_1;
0055: int32 InterVar0_5;
0056:
0057: // evaluate the stage variables first
0058: InterVar0_0 = LabInp_Lnk.INGX_RELATION;
0059: if (notnull(trimc_string(InterVar0_0))) {
0060: InterVar0_1 = LabInp_Lnk.INGX_RELATION;
0061: StageVar0_IngxRelationStgVar = trimc_string(InterVar0_1);
0062: } else {
0063: StageVar0_IngxRelationStgVar = InterVar0_2;
0064: }
0065: //;
0066: if (notnull(LabInp_Lnk.GENDID)) {
0067: InterVar0_0 = LabInp_Lnk.GENDID;
0068: StageVar0_GendidStgVar = InterVar0_0;
0069: } else {
0070: StageVar0_GendidStgVar = InterVar0_2;
0071: }
0072: //;
0073: StageVar0_IngxRelationStgVar1 = substring_1(StageVar0_IngxRelationStgVar , 1 , 1);
0074: InterVar0_0 = LabInp_Lnk.GENDID;
0075: StageVar0_GendidStgVar1 = trimc_string(InterVar0_0);
0076:
0077: // evaluate constraint and columns for link: DIIDEN_lkp_Lnk
0078: if ((DeIdentification == InterVar0_3))
0079: {
0080: DIIDEN_lkp_Lnk.EE_SSN = LabInp_Lnk.EE_SSN;
0081: InterVar0_5 = 9 - string_length(trimc_string(LabInp_Lnk.EE_SSN));
0082: DIIDEN_lkp_Lnk.DIN_PERSON_ID_src = (string_of_substring(InterVar0_4 , InterVar0_5) + trimc_string(LabInp_Lnk.EE_SSN));
0083: InterVar0_5 = 2 - string_length(trimc_string(StageVar0_IngxRelationStgVar));
0084: DIIDEN_lkp_Lnk.DIN_SUFFIX_src = (((string_of_substring(InterVar0_4 , InterVar0_5) + trimc_string(StageVar0_IngxRelationStgVar)) + LabInp_Lnk.DOB) + trimc_string(StageVar0_GendidStgVar));
0085: writerecord 0;
0086: RowRejected0 = 0;
0087: }
0088: // evaluate constraint and columns for link: SCRAMBLE_Lkp_Lnk
0089: if ((DeIdentification == InterVar0_6))
0090: {
0091: SCRAMBLE_Lkp_Lnk.LAB_SERV_FROM_MTH_ID = LabInp_Lnk.LAB_SERV_FROM_MTH_ID;
0092: SCRAMBLE_Lkp_Lnk.EE_SSN = LabInp_Lnk.EE_SSN;
0093: if ((trim_leading_trailing(substring_1(LabInp_Lnk.DOB , 1 ,
![Cool 8)](./images/smilies/icon_cool.gif)
0094: SCRAMBLE_Lkp_Lnk.DOB = InterVar0_8;
0095: } else {
0096: SCRAMBLE_Lkp_Lnk.DOB = LabInp_Lnk.DOB;
0097: }
0098: //;
0099: SCRAMBLE_Lkp_Lnk.INGX_RELATION = StageVar0_IngxRelationStgVar1;
0100: SCRAMBLE_Lkp_Lnk.GENDID = StageVar0_GendidStgVar1;
0101: SCRAMBLE_Lkp_Lnk.SOURCE1 = substring_1(LabInp_Lnk.EE_SSN , 1 , 1);
0102: SCRAMBLE_Lkp_Lnk.SOURCE2 = substring_1(LabInp_Lnk.EE_SSN , 2 , 1);
0103: SCRAMBLE_Lkp_Lnk.SOURCE3 = substring_1(LabInp_Lnk.EE_SSN , 3 , 1);
0104: SCRAMBLE_Lkp_Lnk.SOURCE4 = substring_1(LabInp_Lnk.EE_SSN , 4 , 1);
0105: SCRAMBLE_Lkp_Lnk.SOURCE5 = substring_1(LabInp_Lnk.EE_SSN , 5 , 1);
0106: SCRAMBLE_Lkp_Lnk.SOURCE6 = substring_1(LabInp_Lnk.EE_SSN , 6 , 1);
0107: SCRAMBLE_Lkp_Lnk.SOURCE7 = substring_1(LabInp_Lnk.EE_SSN , 7 , 1);
0108: SCRAMBLE_Lkp_Lnk.SOURCE8 = substring_1(LabInp_Lnk.EE_SSN , 8 , 1);
0109: SCRAMBLE_Lkp_Lnk.SOURCE9 = substring_1(LabInp_Lnk.EE_SSN , 9 , 1);
0110: writerecord 1;
0111: RowRejected0 = 0;
0112: }
0113: }
0114:
0115: finish {
0116: }
0117:
*** End of Internal Generated Transformer Code
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: