Server Sort Stage

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
halpavan2
Participant
Posts: 31
Joined: Fri Apr 18, 2008 5:44 am
Location: Hyderabad

Server Sort Stage

Post by halpavan2 »

Hello I am trying to use sort stage to sort data in a fixed width file , I havent specified any delimiter as a fixed width file does not have one.... the job is failing with error

Error in retrieving stage property values
DSTAGE-SORT-0048`:`Invalid value for stage property 'Column Seperator'

Can anyone please help on what I should be specifying the column seperator as??
pavan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Are you doing something with the collating sequence map file? The error relates to the structure of that file, not anything about your stream data.
-craig

"You can never have too many knives" -- Logan Nine Fingers
halpavan2
Participant
Posts: 31
Joined: Fri Apr 18, 2008 5:44 am
Location: Hyderabad

Post by halpavan2 »

Hi Craig nope done nothing with that ... thought the error was because i did not specify a column seperator in the stage ... cn you please throw some light into the issue you think it to be??
pavan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well, the stage certainly seems to think you are using a map file. What happens if you specify a value (any value) for that property?
-craig

"You can never have too many knives" -- Logan Nine Fingers
halpavan2
Participant
Posts: 31
Joined: Fri Apr 18, 2008 5:44 am
Location: Hyderabad

Post by halpavan2 »

Still showing the same error that i pointed out :(
pavan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Are you current on your fixpacks? Checked with your official support provider? Without access to your job, not sure what else to suggest. Is this your first time using that stage?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply