DSXchange

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:

First step would be to determine exactly what this "box character" is, typically by checking with a hex editor to get the hex/octal value, many of which are free downloads.

i belive because of space the box character is comming just need to know the solution how to remove that

You need to know what the character is before you can remove or otherwise handle it properly. And do not use private email to ask for help when people here are obviously trying to do exactly that.

i dont have premium membership so i cant read ur post thats y i asked to end it on my mail ID

You can see everything I posted.

NO

Good Lord. YES, you can.

Regardless, you need to let us know what the actual value of the "box" is, then people can help. Maybe saying it three times will be the charm.

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.

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.

'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.

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.

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.

Thanks Craig, this is resolved for me.

Me too. Don't know if worked out for Sagar.

Me too. Don't know if worked out for Sagar.