Page 1 of 1

EBCDIC data transfer to DB2 UDB ASCII

PostPosted: Fri Sep 22, 2017 5:37 pm
by atcs_user
Hi All,

I need support to load a text file that is downloaded from Mainframe. This text file needs to be uploaded to DB2 UDB 9.7 version ASCII codepage. I have some data in text file that is stored in Comp-3 format. Comp-3 is not recognisable in ASCII. So system is rejecting it.

I am attaching the data template, data DDL, and data file for your reference.

any help will be appreciated a lot.

thanks
Roop

Re: EBCDIC data transfer to DB2 UDB ASCII

PostPosted: Fri Sep 22, 2017 5:48 pm
by enrico-sorichetti
I have some data in text file that is stored in Comp-3 format.


then You do not have a <text> file
the general consensus is that a text file is human readable char by char

You will have to convert Your data to a TRUE text file

Re: EBCDIC data transfer to DB2 UDB ASCII

PostPosted: Sat Sep 23, 2017 4:31 pm
by NicC
You will have to convert Your data to a TRUE text file

and do this on the mainframe before downloading your data set.