hi,
i am developing a parallel job to use Runtime Collumn Propagation using Shema file. i am struck at specifying the Description for the Collumns in schema file. Could any one please help me out on this issue. Thanks in advance.
Field Decription in Schema file
Moderators: chulett, rschirm, roy
Re: Field Decription in Schema file
mrajesh99 wrote:hi,
i am developing a parallel job to use Runtime Collumn Propagation using Shema file. i am struck at specifying the Description for the Collumns in schema file. Could any one please help me out on this issue. Thanks in advance.
How can we assume your issue?Please point out the problem.
Kiran Vaduguri
As soon as the fear approaches near, attack and destroy it.
As soon as the fear approaches near, attack and destroy it.
Field Decription in Schema file
Hi Kiran,
thanks for reply. i am developing a job to produce some test data for our project. i am using Collumn generator with runtime collumn propagation enabled and am getting the table definition from the Orchestrate schema file. i have developed the schema file and managed to generate some test data. i want to add comments to the collumn(Description at collumn level) definition in the schema file. i had a look at the DS documentation but couldnt find any information. pls let me know of anyworkaround.
thanks for reply. i am developing a job to produce some test data for our project. i am using Collumn generator with runtime collumn propagation enabled and am getting the table definition from the Orchestrate schema file. i have developed the schema file and managed to generate some test data. i want to add comments to the collumn(Description at collumn level) definition in the schema file. i had a look at the DS documentation but couldnt find any information. pls let me know of anyworkaround.
Re: Field Decription in Schema file
Hi Rajesh,mrajesh99 wrote:i had a look at the DS documentation but couldnt find any information. pls let me know of anyworkaround.
From the documentation
You can include comments in schema definition files. A comment is
started by a double slash //, and ended by a newline.
The following examples show various different data definitions:
record (dateField1:date; ) // single date
record (dateField2[10]:date; ) // 10-element date vector
record (dateField3[]:date; ) // variable-length date vector
record (dateField4:nullable date;) // nullable date
Thanks,
Mohan.A.Jasti.
Mohan.A.Jasti.
-
- Premium Member
- Posts: 22
- Joined: Wed Jul 23, 2008 5:59 pm
- Contact:
Re: Field Decription in Schema file
Hi Rajesh,
We have got the same problem, and just wonder if you have solved it. Basically, we want to specifiy column descriptions on a schema file for XML transformation.
For instance:
A schema file:
record (id:string[5] // /client/text()
** This doesn't work for us. I just used it to describe the problem.
can be transfered to DataStage as:
Column Name ................ Description
id /client/text()
Any idea?
Thanks
We have got the same problem, and just wonder if you have solved it. Basically, we want to specifiy column descriptions on a schema file for XML transformation.
For instance:
A schema file:
record (id:string[5] // /client/text()
** This doesn't work for us. I just used it to describe the problem.
can be transfered to DataStage as:
Column Name ................ Description
id /client/text()
Any idea?
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use /* C-style comments */ in schema files.
However, there is no mechanism for transferring these to DataStage as part of the import process. This would need to be a manual process of transcription.
However, there is no mechanism for transferring these to DataStage as part of the import process. This would need to be a manual process of transcription.
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.
-
- Premium Member
- Posts: 22
- Joined: Wed Jul 23, 2008 5:59 pm
- Contact:
Hi Ray,ray.wurlod wrote:Use /* C-style comments */ in schema files.
However, there is no mechanism for transferring these to DataStage as part of the import process. This would need to be a manual process of transcription.
Thanks for the reply.
Does that mean there is not way to pass column descriptions to DataStage from a schema at Version 8.X or 8.1?
Regards,
Max