Field Decription in Schema file

mrajesh99 · Post by **mrajesh99** » Mon Aug 17, 2009 8:09 pm

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.

kiran259 · Post by **kiran259** » Mon Aug 17, 2009 11:42 pm

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.

mrajesh99 · Post by **mrajesh99** » Mon Aug 17, 2009 11:54 pm

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.

Jasti · Post by **Jasti** » Tue Aug 18, 2009 1:08 am

mrajesh99 wrote:i had a look at the DS documentation but couldnt find any information. pls let me know of anyworkaround.

Hi Rajesh,
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

edmtenzing · Post by **edmtenzing** » Sun Nov 08, 2009 3:50 pm

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

ray.wurlod · Post by **ray.wurlod** » Sun Nov 08, 2009 3:59 pm

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.

edmtenzing · Post by **edmtenzing** » Sun Nov 08, 2009 4:14 pm

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.

Hi Ray,
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

DSXchange