Delimiter for Sequential file with pipe & comma in data
Moderators: chulett, rschirm, roy
Delimiter for Sequential file with pipe & comma in data
Hi,
We usually use Pipe seperated sequential file.
In this case we have source data containing both pipe and comma.
i tried different options available as delimiter in sequential file but nothing seems to work.
I have implemented earlier Ctrl-Y char(25) as delimiting characters in my transformer earlier. But sequential file does not allow this.
Help on this is appreciated on this.
We usually use Pipe seperated sequential file.
In this case we have source data containing both pipe and comma.
i tried different options available as delimiter in sequential file but nothing seems to work.
I have implemented earlier Ctrl-Y char(25) as delimiting characters in my transformer earlier. But sequential file does not allow this.
Help on this is appreciated on this.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why do you believe that the Sequential File stage does not allow using Ctrl-Y as the field delimiter? How have you tried to enter that value into the Field Delimiter property?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Yes i tried.ray.wurlod wrote:Why do you believe that the Sequential File stage does not allow using Ctrl-Y as the field delimiter? How have you tried to enter that value into the Field Delimiter property?
For Ctrl-Y i have to type in char(25)
And the delimiter allows only one character there.
Please help.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Delimiter for Sequential file with pipe & comma in d
Pandeesh, we're responding to this statement.highpoint wrote:I have implemented earlier Ctrl-Y char(25) as delimiting characters in my transformer earlier. But sequential file does not allow this.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I read the ascii help on this.ray.wurlod wrote:Next time you're in that screen read the help on entering ASCII codes for non-printing characters.
And i tried using the delimiter string option in format tab of sequential file.
I tried using char(25) , 'char(25)'
But i dont see Ctrl-Y in the output of my file.
Please help.
Would appreciate reply on my question.ray.wurlod wrote:something that was moved to another thread.
Looks like my thread is being hijacked. :D
I have tried using 025, 222 for all this it fails with the following error:
DST_BenefitPlanLoad_MBR_PAY_DSGN_STEP_SUM_DIM_ins: Error when checking operator: "delim_string" property must have a string value; text: delim_string=222
When i use char(222) or @FM then the job runs fine but the data on unix shows char(222) or @FM instead of special character respectively.
I am trying to come up with a standard for using delimiting character which we can use in all the sequential files without worrying what our data may contain.
Would really appreciate your help on this.
DST_BenefitPlanLoad_MBR_PAY_DSGN_STEP_SUM_DIM_ins: Error when checking operator: "delim_string" property must have a string value; text: delim_string=222
When i use char(222) or @FM then the job runs fine but the data on unix shows char(222) or @FM instead of special character respectively.
I am trying to come up with a standard for using delimiting character which we can use in all the sequential files without worrying what our data may contain.
Would really appreciate your help on this.
You should be entering that as the Delimiter property, not the Delimiter String.highpoint wrote:I have tried using 025, 222 for all this it fails with the following error:
DST_BenefitPlanLoad_MBR_PAY_DSGN_STEP_SUM_DIM_ins: Error when checking operator: "delim_string" property must have a string value; text: delim_string=222
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 31
- Joined: Mon Jun 28, 2010 5:15 am
- Location: pune