DSXchange

Hi All,

When I am passing the data from one sequential file to another thro' transformer ,this character  is getting appended to one of colum.

I am wondering why?

thanks

Hi,

Is this happening to the last column?
Are there any transformation being performed on the column involved?

Regards,

Is there any warning when you try viewing data from source sequential file?

Regards
Saravanan

Check whether you have a tab char in the column. Or you may have a null value in that char.

It looks like you might have specified Windows-type termination when writing and then you are reading it with Unix-type termination.

Thanks for responses,

My Ans to Q asked :

Q: Is this happening to the last column?
Are there any transformation being performed on the column involved?

Ans: No this Happening at first column of Target Sequientail file however the source column from where it is coming is last one.

Following transformation is being performed:-

if char(10) then char(127): DSLink3.colB else 0 (using stage variable).

Q:Is there any warning when you try viewing data from source sequential file?

No and No warning also while viewing the Target Sequential file.

Q:Check whether you have a tab char in the column. Or you may have a null value in that char

Ans: I have Tab char and Not nullable in the all the columns of all the files.

Q:It looks like you might have specified Windows-type termination when writing and then you are reading it with Unix-type termination.

Ans: Both the places are Unix-type termination.

Hope this shall help in dignosis.

Thanks
Prahsant

if char(10) then char(127): DSLink3.colB else 0 (using stage variable).

char(127) is - you are getting what you are putting in the column.
Is that what you meant to do?

Regards,