Page 1 of 1
Server Sort Stage
Posted: Mon Jun 13, 2011 6:39 am
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??
Posted: Mon Jun 13, 2011 6:59 am
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.
Posted: Mon Jun 13, 2011 7:06 am
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??
Posted: Mon Jun 13, 2011 7:23 am
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?
Posted: Mon Jun 13, 2011 7:25 am
by halpavan2
Still showing the same error that i pointed out
Posted: Mon Jun 13, 2011 7:27 am
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?