Assigning Env Variable value to a column in PX transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Merly
Participant
Posts: 5
Joined: Tue Jan 23, 2007 9:52 pm
Location: Bangalore

Assigning Env Variable value to a column in PX transformer

Post by Merly »

Hi,

I am trying to assign the value of an environment variable to a column in a parallel transformer stage. I had defined the env variable as a job parameter and selected the same as the value for the column in the Xform stage. When i try to compile the PX job its giving an error.

Any help towards resolving the same would be highly appreciated.

Thanks,
Merly
Top
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Welcome Aboard !

I have a couple of questions for you

- What is the error you are getting?
- How have you given reference to the Environment variables?
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Top
Merly
Participant
Posts: 5
Joined: Tue Jan 23, 2007 9:52 pm
Location: Bangalore

Post by Merly »

I defined the environment variable as a job parameter. In the transformer while doing the mapping for the field 'LST_UPDT_ID' i am mapping its value as $APT_ORACLE_LOAD_OPTIONS.
While compiling its gives the following compilation error. The problem doesn't arise if i give a normal job parameter instead of env vriable (defined as job parameter.).
********************************************************
Output from transformer compilation follows:

##I TFCN 000001 11:23:13(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 11:23:13(001) <main_program> The open files limit is 10000; raising to 2147483647.
##I TOSH 000002 11:23:13(002) <main_program> orchgeneral: loaded
##I TOSH 000002 11:23:13(003) <main_program> orchsort: loaded
##I TOSH 000002 11:23:13(004) <main_program> orchstats: loaded
##I TFSC 000001 11:23:13(007) <main_program> APT configuration file: /opt/Ascential/DataStage/Configurations/IVM_default.apt
##I TFSC 000000 11:23:13(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 (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##I TFPM 000201 11:23:14(000) <APT_CombinedOperatorController,0> APT_PMPlayer: new Player running, PID = 4047068
##I TFOP 000094 11:23:14(001) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 11:23:14(002) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 11:23:14(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##I TCOS 000021 11:23:14(001) <main_program> Echo:
transform -inputschema record
(
PRD_NBR:nullable int64;
STR_NBR:nullable int64;
PRD_SLS_DT:nullable timestamp;
CTRY_CD:nullable string[max=2];
SLS_QTY:nullable int64;
SLS_AMT:nullable int64;
LST_UPDT_ID:nullable string[max=30];
LST_UPDT_DTTM:nullable timestamp;
BRG_STAT_CD:nullable string[max=1];
)
-outputschema record
(
PRD_NBR:nullable int64;
STR_NBR:nullable int64;
PRD_SLS_DT:nullable timestamp;
CTRY_CD:nullable string[max=2];
SLS_QTY:nullable int64;
SLS_AMT:nullable int64;
LST_UPDT_ID:nullable string[max=30];
LST_UPDT_DTTM:nullable timestamp;
BRG_STAT_CD:nullable string[max=1];
)
-expressionfile RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx
-flag compile
-compiler '/usr/vacpp/bin/xlC_r'
-compileopt '-O -c -qspill=32704'
-linker '/usr/vacpp/bin/xlC_r'
-linkopt '-G'
-name V0S4_SQLLoadTest2_Transformer_4
-dir /home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O
.
##I TCOS 000022 11:23:14(003) <main_program> Explanation:
Step has 1 operator.
???, invoked with args: -inputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; ) -outputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; ) -expressionfile RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx -flag compile -compiler /usr/vacpp/bin/xlC_r -compileopt -O -c -qspill=32704 -linker /usr/vacpp/bin/xlC_r -linkopt -G -name V0S4_SQLLoadTest2_Transformer_4 -dir /home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O

Step has 0 data entities.
.
##I TCOS 000023 11:23:14(004) <main_program> Dump:
{
text="transform -inputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )\n-outputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )\n-expressionfile RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx\n-flag compile\n-compiler '/usr/vacpp/bin/xlC_r'\n-compileopt '-O -c -qspill=32704'\n-linker '/usr/vacpp/bin/xlC_r'\n-linkopt '-G'\n-name V0S4_SQLLoadTest2_Transformer_4\n-dir /home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O",
line=1, column=1, name="", qualname="",
op={
text="transform -inputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )\n-outputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )\n-expressionfile RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx\n-flag compile\n-compiler '/usr/vacpp/bin/xlC_r'\n-compileopt '-O -c -qspill=32704'\n-linker '/usr/vacpp/bin/xlC_r'\n-linkopt '-G'\n-name V0S4_SQLLoadTest2_Transformer_4\n-dir /home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O",
line=1, column=1, name=transform, qualname=transform,
wrapout={},
wrapperfile=transform, kind=non_wrapper_cdi_op, exec_mode=none,
args="'record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )'-outputschema'record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )'-expressionfile'RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx'-flag'compile'-compiler'/usr/vacpp/bin/xlC_r'-compileopt'-O -c -qspill=32704'-linker'/usr/vacpp/bin/xlC_r'-linkopt'-G'-name'V0S4_SQLLoadTest2_Transformer_4'-dir'/home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O'"
}
}
.
##W TFCP 000000 11:23:14(005) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##E TFCP 000001 11:23:14(006) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 8].
##E TFCP 000012 11:23:14(007) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 8].
##E TFCP 000001 11:23:14(008) <transform> Error when checking composite operator: Unexpected tokens: ; [line 34,character 22].
##E TFCP 000027 11:23:14(009) <transform> Error when checking composite operator: Expected an operand; [line 34, character 20].
##E TFCP 000038 11:23:14(010) <transform> Error when checking composite operator: Expected semi-colon; [line 34, character 22].
##E TFSR 000019 11:23:14(011) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 11:23:14(012) <main_program> Creation of a step finished with status = FAILED. (SQLLoadTest2.Transformer_4)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S4_SQLLoadTest2_Transformer_4 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink7;
0007: outputname 0 DSLink2;
0008:
0009: global {
0010: // Job parameter declaration
0011: ustring $APT_ORACLE_LOAD_OPTIONS;
0012: ustring DSJobStartTimestamp;
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_0;
0024:
0025: // initialise constant values which require conversion
0026: InterVar0_0 = "C";
0027: }
0028:
0029: mainloop {
0030: // initialise our row rejected variable
0031: RowRejected0 = 1;
0032:
0033: // evaluate columns (no constraints) for link: DSLink2
0034: DSLink2.LST_UPDT_ID = $APT_ORACLE_LOAD_OPTIONS;
0035: DSLink2.LST_UPDT_DTTM = timestamp_from_ustring(DSJobStartTimestamp);
0036: DSLink2.BRG_STAT_CD = InterVar0_0;
0037: writerecord 0;
0038: RowRejected0 = 0;
0039: }
0040:
0041: finish {
0042: }
0043:
*** End of Internal Generated Transformer Code
*************************************************************

Thanks,
Aneesh.
Top
Merly
Participant
Posts: 5
Joined: Tue Jan 23, 2007 9:52 pm
Location: Bangalore

Post by Merly »

narasimha wrote:Welcome Aboard !

I have a couple of questions for you

- What is the error you are getting?
- How have you given reference to the Environment variables?
I defined the environment variable as a job parameter. In the transformer while doing the mapping for the field 'LST_UPDT_ID' i am mapping its value as $APT_ORACLE_LOAD_OPTIONS.
While compiling its gives the following compilation error. The problem doesn't arise if i give a normal job parameter instead of env vriable (defined as job parameter.).
********************************************************
Output from transformer compilation follows:

##I TFCN 000001 11:23:13(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 11:23:13(001) <main_program> The open files limit is 10000; raising to 2147483647.
##I TOSH 000002 11:23:13(002) <main_program> orchgeneral: loaded
##I TOSH 000002 11:23:13(003) <main_program> orchsort: loaded
##I TOSH 000002 11:23:13(004) <main_program> orchstats: loaded
##I TFSC 000001 11:23:13(007) <main_program> APT configuration file: /opt/Ascential/DataStage/Configurations/IVM_default.apt
##I TFSC 000000 11:23:13(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 (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##I TFPM 000201 11:23:14(000) <APT_CombinedOperatorController,0> APT_PMPlayer: new Player running, PID = 4047068
##I TFOP 000094 11:23:14(001) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 11:23:14(002) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 11:23:14(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##I TCOS 000021 11:23:14(001) <main_program> Echo:
transform -inputschema record
(
PRD_NBR:nullable int64;
STR_NBR:nullable int64;
PRD_SLS_DT:nullable timestamp;
CTRY_CD:nullable string[max=2];
SLS_QTY:nullable int64;
SLS_AMT:nullable int64;
LST_UPDT_ID:nullable string[max=30];
LST_UPDT_DTTM:nullable timestamp;
BRG_STAT_CD:nullable string[max=1];
)
-outputschema record
(
PRD_NBR:nullable int64;
STR_NBR:nullable int64;
PRD_SLS_DT:nullable timestamp;
CTRY_CD:nullable string[max=2];
SLS_QTY:nullable int64;
SLS_AMT:nullable int64;
LST_UPDT_ID:nullable string[max=30];
LST_UPDT_DTTM:nullable timestamp;
BRG_STAT_CD:nullable string[max=1];
)
-expressionfile RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx
-flag compile
-compiler '/usr/vacpp/bin/xlC_r'
-compileopt '-O -c -qspill=32704'
-linker '/usr/vacpp/bin/xlC_r'
-linkopt '-G'
-name V0S4_SQLLoadTest2_Transformer_4
-dir /home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O
.
##I TCOS 000022 11:23:14(003) <main_program> Explanation:
Step has 1 operator.
???, invoked with args: -inputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; ) -outputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; ) -expressionfile RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx -flag compile -compiler /usr/vacpp/bin/xlC_r -compileopt -O -c -qspill=32704 -linker /usr/vacpp/bin/xlC_r -linkopt -G -name V0S4_SQLLoadTest2_Transformer_4 -dir /home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O

Step has 0 data entities.
.
##I TCOS 000023 11:23:14(004) <main_program> Dump:
{
text="transform -inputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )\n-outputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )\n-expressionfile RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx\n-flag compile\n-compiler '/usr/vacpp/bin/xlC_r'\n-compileopt '-O -c -qspill=32704'\n-linker '/usr/vacpp/bin/xlC_r'\n-linkopt '-G'\n-name V0S4_SQLLoadTest2_Transformer_4\n-dir /home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O",
line=1, column=1, name="", qualname="",
op={
text="transform -inputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )\n-outputschema record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )\n-expressionfile RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx\n-flag compile\n-compiler '/usr/vacpp/bin/xlC_r'\n-compileopt '-O -c -qspill=32704'\n-linker '/usr/vacpp/bin/xlC_r'\n-linkopt '-G'\n-name V0S4_SQLLoadTest2_Transformer_4\n-dir /home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O",
line=1, column=1, name=transform, qualname=transform,
wrapout={},
wrapperfile=transform, kind=non_wrapper_cdi_op, exec_mode=none,
args="'record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )'-outputschema'record ( PRD_NBR: nullable int64; STR_NBR: nullable int64; PRD_SLS_DT: nullable timestamp; CTRY_CD: nullable string[max=2]; SLS_QTY: nullable int64; SLS_AMT: nullable int64; LST_UPDT_ID: nullable string[max=30]; LST_UPDT_DTTM: nullable timestamp; BRG_STAT_CD: nullable string[max=1]; )'-expressionfile'RT_SC1285/V0S4_SQLLoadTest2_Transformer_4.trx'-flag'compile'-compiler'/usr/vacpp/bin/xlC_r'-compileopt'-O -c -qspill=32704'-linker'/usr/vacpp/bin/xlC_r'-linkopt'-G'-name'V0S4_SQLLoadTest2_Transformer_4'-dir'/home/apps/IVM/IVMDev/IVMDevprj/RT_BP1285.O'"
}
}
.
##W TFCP 000000 11:23:14(005) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##E TFCP 000001 11:23:14(006) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 8].
##E TFCP 000012 11:23:14(007) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 8].
##E TFCP 000001 11:23:14(008) <transform> Error when checking composite operator: Unexpected tokens: ; [line 34,character 22].
##E TFCP 000027 11:23:14(009) <transform> Error when checking composite operator: Expected an operand; [line 34, character 20].
##E TFCP 000038 11:23:14(010) <transform> Error when checking composite operator: Expected semi-colon; [line 34, character 22].
##E TFSR 000019 11:23:14(011) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 11:23:14(012) <main_program> Creation of a step finished with status = FAILED. (SQLLoadTest2.Transformer_4)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S4_SQLLoadTest2_Transformer_4 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink7;
0007: outputname 0 DSLink2;
0008:
0009: global {
0010: // Job parameter declaration
0011: ustring $APT_ORACLE_LOAD_OPTIONS;
0012: ustring DSJobStartTimestamp;
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_0;
0024:
0025: // initialise constant values which require conversion
0026: InterVar0_0 = "C";
0027: }
0028:
0029: mainloop {
0030: // initialise our row rejected variable
0031: RowRejected0 = 1;
0032:
0033: // evaluate columns (no constraints) for link: DSLink2
0034: DSLink2.LST_UPDT_ID = $APT_ORACLE_LOAD_OPTIONS;
0035: DSLink2.LST_UPDT_DTTM = timestamp_from_ustring(DSJobStartTimestamp);
0036: DSLink2.BRG_STAT_CD = InterVar0_0;
0037: writerecord 0;
0038: RowRejected0 = 0;
0039: }
0040:
0041: finish {
0042: }
0043:
*** End of Internal Generated Transformer Code
*************************************************************

Thanks,
Merly.
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I am not near the product at the moment, but I am pretty sure there is a transform function in px transformer to get the enviornment variable. Use that, instead of going down the job parameter path.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
pneumalin
Premium Member
Premium Member
Posts: 125
Joined: Sat May 07, 2005 6:32 am

Post by pneumalin »

You cannot refer the env variable (Startign from $) in Derivation Editor pf Transformer. You get compilation error if you do that.
So far, I am not aware of any function available in Tranformer will help you retrieve the value of an env variable. The only option for you is probably call this job from a sequence and pass down the value to the local job parameter of this job from sequence, and you can refer that job parameter in your Tranformer. Hope it helps!
Top
pneumalin
Premium Member
Premium Member
Posts: 125
Joined: Sat May 07, 2005 6:32 am

Post by pneumalin »

Brian was right! There is GetEnvironment in Utility will help you get the value of any environment variable. Go to Utility ->GetEnvironment in derivation editor, and provide the syntax like GetEnvironment("APT_CONFIG_FILE") will do the trick for you... My previous method will also do this for you if you use job sequence to maintain the job parameter.
Top
Merly
Participant
Posts: 5
Joined: Tue Jan 23, 2007 9:52 pm
Location: Bangalore

Post by Merly »

pneumalin wrote:Brian was right! There is GetEnvironment in Utility will help you get the value of any environment variable. Go to Utility ->GetEnvironment in derivation editor, and provide the syntax like GetEnvironment("APT_CONFIG_FILE") will do the trick for you... My previous method will also do this for you if you use job sequence to maintain the job parameter.
Thanks Brian and pneumalin. It works. Thanks for your help!
Top
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Merly - Its time to mark the topic as resolved.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Top
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Now DSguru2b gets to be called as Brian :wink:
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

... but 'e's not the Messiah...

:lol:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Pay attention, next month Ill go by some other name :wink:
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
vijayrc
Participant
Posts: 197
Joined: Sun Apr 02, 2006 10:31 am
Location: NJ

Post by vijayrc »

pneumalin wrote:Brian was right! There is GetEnvironment in Utility will help you get the value of any environment variable. Go to Utility ->GetEnvironment in derivation editor, and provide the syntax like GetEnvironment("APT_CONFIG_FILE") will do the trick for you... My previous method will also do this for you if you use job sequence to maintain the job parameter.
I'm in similar boat, but I want to use a User defined Project level Environment Varibale to be used in a Transformer CONSTRAINT....how do I go about this..
Thanks,
Vijay
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Same command.
And a friendly reminder, "No Hijacking of threads."
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
vijayrc
Participant
Posts: 197
Joined: Sun Apr 02, 2006 10:31 am
Location: NJ

Post by vijayrc »

DSguru2B wrote:Same command.
And a friendly reminder, "No Hijacking of threads."
Thanks..Will try it out.
And didn't mean to Hijack this thread, as this thread is marked 'RESOLVED' and I didn't want to open a new topic on the same subject :P

Thanks again and the trick worked with GetEnvironment() Utility in Tx Function. You guys rock
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”