How to Capture job parameters during runtime..?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai
How to Capture job parameters during runtime..?
Hi,
During runtime, Is there any way to capture job parameters and pass those job parameters from source file to Target file...?
Regards,
JIM
During runtime, Is there any way to capture job parameters and pass those job parameters from source file to Target file...?
Regards,
JIM
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The crucial bit appears to be "capture". Does that mean "read them from a file"? If so, by what thought process are they being called "parameters"? Are they "job parameters" or something else?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai
In most of stages ...where you specify property value ..there is provision to include job parameters as value..
For example in transformer you can pass job parameter to output column definition by going to derivation and by right clicking and selectiong job parameters.
refer documentation docs for more details
Regards
Sandeep Ranade
For example in transformer you can pass job parameter to output column definition by going to derivation and by right clicking and selectiong job parameters.
refer documentation docs for more details
Regards
Sandeep Ranade
In most of stages ...where you specify property value ..there is provision to include job parameters as value..
For example in transformer you can pass job parameter to output column definition by going to derivation and by right clicking and selectiong job parameters.
refer documentation docs for more details
Regards
Sandeep Ranade
For example in transformer you can pass job parameter to output column definition by going to derivation and by right clicking and selectiong job parameters.
refer documentation docs for more details
Regards
Sandeep Ranade
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai
As mentioned,I have used this pass job parameter in transformer.
My jobparameter is $GLB_ETL_BATCH with Default value as ETLBATCH.
However I am getting Job compile error as...
Output from transformer compilation follows:
##I TFCN 000001 13:23:50(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 13:23:50(001) <main_program> The open files limit is 100; raising to 65536.
##I TOSH 000002 13:23:50(002) <main_program> orchgeneral: loaded
##I TOSH 000002 13:23:50(003) <main_program> orchsort: loaded
##I TOSH 000002 13:23:51(000) <main_program> orchstats: loaded
##I TFSC 000001 13:23:51(003) <main_program> APT configuration file: /datastage/dsadm/Ascential/DataStage/Configurations/default.apt
##I TFSC 000000 13:23:51(004) <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 TFOP 000094 13:23:51(000) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 13:23:51(001) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 13:23:51(005) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W TFCP 000000 13:23:52(001) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##E TFCP 000001 13:23:52(002) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 7].
##E TFCP 000012 13:23:52(003) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 7].
##E TFCP 000001 13:23:52(004) <transform> Error when checking composite operator: Unexpected tokens: ; [line 28,character 20].
##E TFCP 000027 13:23:52(005) <transform> Error when checking composite operator: Expected an operand; [line 28, character 18].
##E TFCP 000038 13:23:52(006) <transform> Error when checking composite operator: Expected semi-colon; [line 28, character 20].
##E TFSR 000019 13:23:52(007) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 13:23:52(008) <main_program> Creation of a step finished with status = FAILED. (etlbatch.Transformer_4)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S4_etlbatch_Transformer_4 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink409;
0007: outputname 0 DSLink6;
0008:
0009: global {
0010: // Job parameter declaration
0011: string $GLB_ETL_BATCH;
0012: }
0013:
0014: initialize {
0015: // define our row rejected variable
0016: int8 RowRejected0;
0017:
0018: // define our null set variable
0019: int8 NullSetVar0;
0020:
0021: }
0022:
0023: mainloop {
0024: // initialise our row rejected variable
0025: RowRejected0 = 1;
0026:
0027: // evaluate columns (no constraints) for link: DSLink6
0028: DSLink6.ETL_BATCH = $GLB_ETL_BATCH;
0029: writerecord 0;
0030: RowRejected0 = 0;
0031: }
0032:
0033: finish {
0034: }
0035:
*** End of Internal Generated Transformer Code
My jobparameter is $GLB_ETL_BATCH with Default value as ETLBATCH.
However I am getting Job compile error as...
Output from transformer compilation follows:
##I TFCN 000001 13:23:50(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 13:23:50(001) <main_program> The open files limit is 100; raising to 65536.
##I TOSH 000002 13:23:50(002) <main_program> orchgeneral: loaded
##I TOSH 000002 13:23:50(003) <main_program> orchsort: loaded
##I TOSH 000002 13:23:51(000) <main_program> orchstats: loaded
##I TFSC 000001 13:23:51(003) <main_program> APT configuration file: /datastage/dsadm/Ascential/DataStage/Configurations/default.apt
##I TFSC 000000 13:23:51(004) <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 TFOP 000094 13:23:51(000) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 13:23:51(001) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 13:23:51(005) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W TFCP 000000 13:23:52(001) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##E TFCP 000001 13:23:52(002) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 7].
##E TFCP 000012 13:23:52(003) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 7].
##E TFCP 000001 13:23:52(004) <transform> Error when checking composite operator: Unexpected tokens: ; [line 28,character 20].
##E TFCP 000027 13:23:52(005) <transform> Error when checking composite operator: Expected an operand; [line 28, character 18].
##E TFCP 000038 13:23:52(006) <transform> Error when checking composite operator: Expected semi-colon; [line 28, character 20].
##E TFSR 000019 13:23:52(007) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 13:23:52(008) <main_program> Creation of a step finished with status = FAILED. (etlbatch.Transformer_4)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S4_etlbatch_Transformer_4 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink409;
0007: outputname 0 DSLink6;
0008:
0009: global {
0010: // Job parameter declaration
0011: string $GLB_ETL_BATCH;
0012: }
0013:
0014: initialize {
0015: // define our row rejected variable
0016: int8 RowRejected0;
0017:
0018: // define our null set variable
0019: int8 NullSetVar0;
0020:
0021: }
0022:
0023: mainloop {
0024: // initialise our row rejected variable
0025: RowRejected0 = 1;
0026:
0027: // evaluate columns (no constraints) for link: DSLink6
0028: DSLink6.ETL_BATCH = $GLB_ETL_BATCH;
0029: writerecord 0;
0030: RowRejected0 = 0;
0031: }
0032:
0033: finish {
0034: }
0035:
*** End of Internal Generated Transformer Code
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai