DSXchange

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

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,
Aneesh.

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.

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.

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!

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.

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!

Merly - Its time to mark the topic as resolved.

Now DSguru2b gets to be called as Brian

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

Pay attention, next month Ill go by some other name

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

Same command.
And a friendly reminder, "No Hijacking of threads."

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

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