EBCDIC data transfer to DB2 UDB ASCII



IBM's flagship relational database management system

EBCDIC data transfer to DB2 UDB ASCII

Postby atcs_user » Fri Sep 22, 2017 5:37 pm

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
You do not have the required permissions to view the files attached to this post.
atcs_user
 
Posts: 1
Joined: Fri Sep 22, 2017 4:02 pm
Has thanked: 0 time
Been thanked: 0 time

Re: EBCDIC data transfer to DB2 UDB ASCII

 

Re: EBCDIC data transfer to DB2 UDB ASCII

Postby enrico-sorichetti » Fri Sep 22, 2017 5:48 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2797
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 148 times

Re: EBCDIC data transfer to DB2 UDB ASCII

Postby NicC » Sat Sep 23, 2017 4:31 pm

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

and do this on the mainframe before downloading your data set.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2823
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 118 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post