Hi,
I have a question....
I have to import a Orchestrate schema definition to Data Stage
Example :
record
(
npa : string;
nxx : string;
tel_ln_no : string;
inrec : *;
)
In the above example How can I handle the inRec: *; portion while importing it to Datastage ?????....
Thanks in advance
Ram
Importing of a Orchestrate schema into a DS inRec: *;
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Importing of a Orchestrate schema into a DS inRec: *;
inrec: * is a schema variable that denotes any set of fields (including an empty one). If your record schema contains only npa, nxx and tel_ln_no get rid oftrammohan wrote:Hi,
I have a question....
I have to import a Orchestrate schema definition to Data Stage
Example :
record
(
npa : string;
nxx : string;
tel_ln_no : string;
inrec : *;
)
In the above example How can I handle the inRec: *; portion while importing it to Datastage ?????....
Thanks in advance
Ram
inrec:*;
and import the record schema using the DS Manager.
Vitali.
Re: Importing of a Orchestrate schema into a DS inRec: *;
So in summary, it is a way to declare Orchestrate Propagated columns?
-T.J.
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).
Re: Importing of a Orchestrate schema into a DS inRec: *;
Yes. According to the Orchestrate documentation:Teej wrote:So in summary, it is a way to declare Orchestrate Propagated columns?
-T.J.
Operators use schema variables to transfer an entire record of an input data set to the output data set.
Operators that do not use schema variables drop unused fields from the
records of an input data set.
Vitali.
Ram,trammohan wrote:How can I define the inRec :*; in Data stage schema
Schema variables cannot be used in the Data Stage table definitions. They are used in Orchestrate operators.
Here's an example of using schema variables in an Orchestrate custom operator (buildop):
Code: Select all
$operator schema_var
$class schema_var_op
$input master_in auto record (i:int32; j:int32; inrec:*;)
$output master_out auto record (sum:int32; outrec:*;)
$action
sum = master_in.i + master_in.j;
$end
To run this operator
1. Create a file schema_var.opd with the content shown above. Put it into your DS project buildop directory.
2. Compile the schema_var buildop:
buildop -f -v schema_var.opd
3. Create a PX job with a generic stage. Something like:
Row Generator --> Generic (schema_var) --> Peek
Specify schema_var as the Operator property in the generic stage.
Alternatively you can run the following osh script:
osh "
generator
-schema record (
i:int32;
j:int32;
)
-records 10
|
schema_var
|
peek
-name
"
Regards,
Vitali.