By Using Row generator stage to genrate a test data

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
samyamkrishna
Premium Member
Premium Member
Posts: 258
Joined: Tue Jul 04, 2006 10:35 pm
Location: Toronto

Re: By Using Row generator stage to genrate a test data

Post by samyamkrishna »

Is there any specific reason you are using teh schema file. to generate test data.
reddy82
Participant
Posts: 29
Joined: Wed Feb 21, 2007 3:40 am
Location: mumbai
Contact:

Post by reddy82 »

we have to produce the tset data according to schema file for testing purpose
Reddy
dreamcafe
Participant
Posts: 1
Joined: Sun Feb 08, 2009 9:44 am

Post by dreamcafe »

Hi, reddy82. I think you should define the column properties list to generate the testing data.

For example.

record nullable {final_delim=end, delim=';', quote=none, null_field="s"}
(
ACTION: not_nullable string[MAX=1] {cycle={value='a'}};
TEST1 : not_nullable string[MAX=2] {cycle={value='b', value='bb'}};
TEST2 : not_nullable string[MAX=3] {alphabet='abcdef'};
TEST3 : not_nullable string[MAX=4] {alphabet='abcdefhij'};
MSISDN: not_nullable string[MAX=100] {alphabet='abcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'};
)
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Leave out not_nullable from the field definitions. Leave out nullable from the record declaration. Both are incorrect. Field are not nullable unless marked nullable. Records can not be nullable.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply