Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
sagar deshmukh
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Post
by sagar deshmukh »
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.
-
Sreenivasulu
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Post
by Sreenivasulu »
Convert from ebcidic to dos (ie. the equivalent of unixtodos command')
Regards
Sreeni
-
sagar deshmukh
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Post
by sagar deshmukh »
Hi, I am really sorry , I am not aware of this..How to do this?
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
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).
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
sagar deshmukh
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Post
by sagar deshmukh »
sorry for the 20 previously mentioned..just downloaded another hex editor here its showing 00..this is the hex value
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
OK... so what are you going to try next?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
sagar deshmukh
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
Post
by sagar deshmukh »
convert(char(00),"", ABCD)
This is working, thanks for your help.