ERROR showing in my job

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
kkumardatastage
Participant
Posts: 84
Joined: Sat Jul 19, 2008 8:50 am

ERROR showing in my job

Post by kkumardatastage »

Hi

Please can any one help me in this issue, I am working on datastage 8.1 version and i am working on a job after compiling the job i got the following error in log Please can any one can help me with this

Error message:
main_program: Syntax error: Error in "group" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Error in binding: Error parsing field type: Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255, got: "0"

Thanks..........
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sounds like somewhere in your job you have a Decimal field with no precision or scale defined, hence the reference to: "0,0" for schema type "decimal".
-craig

"You can never have too many knives" -- Logan Nine Fingers
arnabdey
Participant
Posts: 50
Joined: Wed Jan 10, 2007 5:56 am

Post by arnabdey »

For the given field perhaps you have skipped mentioning the precision and scale fields.... You need to provide a precision and scale values as you have for decimal fields in database
Arnab
Post Reply