how to remove box character insequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
how to remove box character insequential file
i am reading a cvs file into a sequential file. but i am getting box character in the output.please let me know if i need to apply any setting for this. :idea:
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Hi, sorry to post in an open post but I have the exact same issue and the Hex character is '0D'.
Job design..
Database----------->Xfm----------------->seqfile
The database gets populated with mainframe file and the hex character is coming from that mainframe file. I do not have control over how the file gets populated to the database.
Job design..
Database----------->Xfm----------------->seqfile
The database gets populated with mainframe file and the hex character is coming from that mainframe file. I do not have control over how the file gets populated to the database.
Hi, sorry to post in an open post but I have the exact same issue and the Hex character is '0D'.
Job design..
Database----------->Xfm----------------->seqfile
The database gets populated with mainframe file and the hex character is coming from that mainframe file. I do not have control over how the file gets populated to the database.
Job design..
Database----------->Xfm----------------->seqfile
The database gets populated with mainframe file and the hex character is coming from that mainframe file. I do not have control over how the file gets populated to the database.
'0D' is a carriage return, usually a record terminator mismatch DOS to UNIX. Use Convert to remove them:
If they are in data fields. If it is only at the end of the last field, change from UNIX to DOS terminators in the stage reading the file.
Code: Select all
Convert(CHAR(13),"",YourField)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Re: how to remove box character insequential file
Are you getting any NLS warnings? If you have NLS-enabled DataStage installation, then try the ISO8859-1+MARKS UTF map on the source Sequential File.sagar deshmukh wrote:i am reading a cvs file into a sequential file. but i am getting box character in the output.please let me know if i need to apply any setting for this.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant