Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Load EBCDIC data from text file

Posted on 2004-10-22
Medium Priority
Last Modified: 2012-06-22
I am receiving a data file in EBCDIC format via FTP.  I need to load the data into SQL Server tables.  What tools/techniques can I use to accomplish this?
Question by:KSleeper
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 70

Expert Comment

by:Scott Pletcher
ID: 12385052
There is plenty of software external to SQL Server that can convert EBCDIC to ASCII.  

In fact, most mainframe and AS/400 (two main sources of EBCDIC data, I suspect) transfer tools have an option to automatically convert for you during transfer.

I would definitely look into methods outside of SQL Server rather than trying to do something within SQL.

Expert Comment

ID: 12412054
What is the source of the data?

Are you using FTP to retrieve the data from an AS400?  There may be other options, ie ODBC which will convert the data for you.

Author Comment

ID: 12412808
The data is being delivered via FTP by the mainframe.    At this point, I only have a text file (in EBCDIC format) to work with.
LVL 70

Accepted Solution

Scott Pletcher earned 500 total points
ID: 12422088
Have the FTP from the mainframe automatically convert the file to ASCII.  That should be possible, and if you can do it on the mainframe side, it will be very fast.

Assisted Solution

SashP earned 500 total points
ID: 12539946

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question