Error while importing

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
nynali
Participant
Posts: 31
Joined: Thu May 03, 2007 11:52 pm
Location: Hyderabad

Error while importing

Post by nynali »

Please let me know hoe to handle this kind of error?

When validating import/export function: APT_GFIX_Decimal::validateParameters: the decimal "text" format is variable length, and no external length is specified;
you should possibly specify an appropriate "width" property; external format: {text, padchar=32, nofix_zero, precision=2, scale=0, round=trunc_zero, ascii}.

I have a MF file which has a field whose value looks as '0A' while browsing but actually that field is Signed NUmeric field[S9(02)] i.e., when browsed using a copybook the actual value is 1.I NDMed this file to UNIX in ASCII mode then used the same as input in DS job Sequential stage and I have defined the field as DECIMAL(2,0) but it is throwing the above error.
Please help me on this.
nynali
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You need to specify that the file has fixed width format.
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