default values in schema file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
deepthi
Participant
Posts: 56
Joined: Thu Apr 28, 2005 9:52 am

default values in schema file

Post by deepthi »

Hi

Iam trying to create a generic job which generates sample records using row gen or column gen stage. iam using scheme file for defining metatadata in the stages.
My problem is , i want to give defaults values for some columns. Iam not
able to define default values in the schema files. I still want to keep this job generic

Thanks for your suggestions

Deepthi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Experiment. Add one or more default values in a job, save the table definition, then open the table definition and use the Layout tab to inspect the record schema. Please let us know the answer.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
GJ_Stage
Participant
Posts: 131
Joined: Mon Oct 27, 2008 6:59 am

Post by GJ_Stage »

Try this:

Without Default value

FIELD_NAME:nullable string[4] {null_field=' '}

With Default value

FIELD_NAME:nullable string[4] {default='test', null_field=' '}
deepthi
Participant
Posts: 56
Joined: Thu Apr 28, 2005 9:52 am

Post by deepthi »

I have tried both of the options above. But no luck yet.

Any more clues?
Post Reply