Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-25 : 07:37:32
|
| KB writes "I am receiving an EBCDIC file and I need to convert it to ASCII in order to load it into a SQL Server DB. I've been searching the web for days now and I cannot find any SQL code to convert this data, nor any "EXE" that will convert it and create a comma, pipe, or tab delimited file.Can you Help? I searched the forums, but I didin't get any hits.Thanks in advance" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-25 : 11:00:08
|
How did yo uge the data down?I'm assuming you got it from the mainframe...and what do you mean...quote:
and create a comma, pipe, or tab delimited file.
Brett8-) |
 |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-02-25 : 11:10:08
|
| A few years back I was working on an ICL Mainframe which used the ebcdic Character set and we had software called winftfi which we used to export our Mainframe data files (ebcdic) to ascii.If it is an ICL mainframe that you are using then you should try their site or which ever company owns them now (I think it might be sun microsystems).In fact here is a site with reference to it http://www.metascybe.co.uk/products/cosi/tech.aspDuane. |
|
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-02-25 : 17:09:26
|
| this might be of use, I didnt look too closely at it thoughsupport.microsoft.com/ default.aspx?scid=kb;EN-US;214649Graham |
|
|
|
|
|
|
ebcdic to ASCII Conversion