Problem viewing the sequential file
Moderators: chulett, rschirm, roy
Problem viewing the sequential file
Hi All,
Well i have this job where i get the sequential file which is created in the server job . this file has delimiter as , and quotes as " on the server side
but when i try to view this file in the parallel job with the delimiter as comma and quotes as double i see that few of the fields as displayed with the double quotes .
how do i get rid of these double quotes here in the pararrel job?
Could somebody plz help me with this issue
Thanks in advance
Well i have this job where i get the sequential file which is created in the server job . this file has delimiter as , and quotes as " on the server side
but when i try to view this file in the parallel job with the delimiter as comma and quotes as double i see that few of the fields as displayed with the double quotes .
how do i get rid of these double quotes here in the pararrel job?
Could somebody plz help me with this issue
Thanks in advance
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Re: Problem viewing the sequential file
What are the datatypes of those few fields?sshettar wrote: but when i try to view this file in the parallel job with the delimiter as comma and quotes as double i see that few of the fields as displayed with the double quotes .
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Hi,
How do you see this info with a regular text editor outside DS?
How do you see this info with a regular text editor outside DS?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
We had a similar problem...
Hi all,
We had a problem similar to this. The main issue was that our data could legitimately hold quotes as part of the field. What we did was to take Ken Bland's advice and make our delimiter the pipe symbol ( | ) and then change the text delimiter on the file to be three zeroes ( 000 ). He also suggested checking the box that makes the first row the field names. When we did this, all our problems of this annoying ilk went away.
Give it a shot!
Bestest,
We had a problem similar to this. The main issue was that our data could legitimately hold quotes as part of the field. What we did was to take Ken Bland's advice and make our delimiter the pipe symbol ( | ) and then change the text delimiter on the file to be three zeroes ( 000 ). He also suggested checking the box that makes the first row the field names. When we did this, all our problems of this annoying ilk went away.
Give it a shot!
Bestest,
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
clarification
Just to allay confusion before it starts:
I meant to say that the delimiter is the pipe symbol ( | ) and the quote character would be three zeroes ( 000 ). Just in case you need to know where these settings are, they are found in the Sequential file stage --> Inputs --> Format. The check box for 'First line is column names' is on the left, and the other two fields are on the right.
Hope this helps!
I meant to say that the delimiter is the pipe symbol ( | ) and the quote character would be three zeroes ( 000 ). Just in case you need to know where these settings are, they are found in the Sequential file stage --> Inputs --> Format. The check box for 'First line is column names' is on the left, and the other two fields are on the right.
Hope this helps!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
Do the data fields contain double double-quotation marks? Physically view the file outside of datastage and confirm.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Re: clarification
And just to further allay confusion for anyone who's never played with those settings before - setting the quote character to three zeroes doesn't mean it will use three zeros. It is the secret signal to DataStage to not use (or expect) any quote characters in the file.jdmiceli wrote:Just to allay confusion before it starts:
I meant to say that the delimiter is the pipe symbol ( | ) and the quote character would be three zeroes ( 000 ).
![Wink :wink:](./images/smilies/icon_wink.gif)
Any quotes, if present, would then be treated as part of the data.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
And to clarify chuletts allaying of confusion, 000 is the ASCII decimal value for NULL. In the good old days of serial communications, you would use a keyboard to type values over the serial line. When you needed to send a high or low ASCII character, you would hold down your ALT key and type in the 3-digit ASCII value of the character you want. We could sent bell characters (ding) that way, hangups, whatever.
To get a capital A, hold down your ALT key and type 065 on your keyboard and then release the ALT key. Viola, a letter A pops up. You can do this today to get any low/high-ASCII character typed anywhere.
To get a capital A, hold down your ALT key and type 065 on your keyboard and then release the ALT key. Viola, a letter A pops up. You can do this today to get any low/high-ASCII character typed anywhere.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
000 is the ASCII decimal value for NUL. This is not the same thing as NULL, which is represented differently by different vendors. For example, within DataStage an out-of-band NULL is represnted by -128.
0000 is the Unicode decimal value for NUL.
You can also specify non-printing delimiter or quote characters using a three digit decimal ASCII code or a four digit hexadecimal Unicode code.
0000 is the Unicode decimal value for NUL.
You can also specify non-printing delimiter or quote characters using a three digit decimal ASCII code or a four digit hexadecimal Unicode code.
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.