DSXchange

Hi,

I have a job where I am pulling data from VSAM using ODBC then trasformer and then finally loading into Teradata DB.

for one of the column i am getting BOX character, In hex editor the value of BOX character is 20.

I tried below functions, but nothing is working for me please help me out.

function tried : Convert(CHAR(13),"",YourField)

Thanks
Sagar.

Convert from ebcidic to dos (ie. the equivalent of unixtodos command')

Regards
Sreeni

Hi, I am really sorry , I am not aware of this..How to do this?

If it is a "20" why did you use "13" in the Convert? And that "box" is a 20 in decimal? Hex? For the former use CHAR(20), the latter CHAR(32).

sorry for the 20 previously mentioned..just downloaded another hex editor here its showing 00..this is the hex value

OK... so what are you going to try next?

convert(char(00),"", ABCD)

This is working, thanks for your help.