How to load EBCDIC file to db using TPT?

Tools

How to load EBCDIC file to db using TPT?

Is there any possible to load IBM EBCDIC file using TPT? There is a EBCDIC file in the mainframe, we are trying to load the file to teradata which installed in the Linux server, is there any possible using TPT connected to mainframe and load the file directly?

If can't connect to mainframe directly and load the file, is there any possible load binary EBCDIC file using TPT in the linux server?

Thanks in advance. 

Tags (1)
4 REPLIES
Teradata Employee

Re: How to load EBCDIC file to db using TPT?

Hi, did you succeed yet?

I'm trying to to the same thing, but I keep on getting the same weird TPT error.

This is what I did:

I wrote a TPT test script that successfully loads 2 columns.

Now according to the TPT documentation, to change it into a TPT script that loads a EBCDIC file 3 things needs to be done:

1. Make sure your 'EBCDIC' charset is installed and activated on your db.

2. At the begining of the TPT script right above the 'DEFINE JOB' clause  add this command: 'USING CHARACTER SET EBCDIC273_0E'.

3. Create the correct EBCDIC file. I used 'UltraEdit' to create it.

Now when I run my TPT skript I keep on getting this error:

TPT10508: RDBMS error 8017: Òêà@õóàÖ╔äk@ÎüóóªûÖä@ûÖ@┴ââûñòú@ëó@ëòÑüôëäK

I know 'RDBMS error 8017' looks like a logon problem, but I'm pretty sure that my logon is OK, because my TPT script was working before.

The rest of the error message I can't read because it looks like data junk.

Can anybody please help me out here?

Thanks

Marcus

Teradata Employee

Re: How to load EBCDIC file to db using TPT?

On which version of z/OS are you running?

(We only support loading EBCDIC data on the mainframes.)

-- SteveF
Teradata Employee

Re: How to load EBCDIC file to db using TPT?

I'm not using a mainframe.

I need to load a given EBCDIC file into Teradata on a network attached client. The EBCDIC file does not contain any packed columns, but does have columns with signed values.

I'm using TPT V13.10 on my TD notebook (or on TD VM Linux) and my test db is a remote TD 14.00 VM.

If it's not possible with TPT how about ML or FL?

Teradata Employee

Re: How to load EBCDIC file to db using TPT?

All of our load products can only load EBCDIC data from MVS/zOS.

-- SteveF