EBCDIC data transfer to DB2 UDB ASCII

IBM's flagship relational database management system
Post Reply Previous topicNext topic
atcs_user
Posts: 1
Joined: Fri Sep 22, 2017 4:02 pm
Skillset: COBOL, DB2, JCL, MVS
Referer: Through a Mainframe friend

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.
Top
enrico-sorichetti
Global moderator
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Skillset: tso,rexx,assembler,pl/i,storage,mvs,os/390,z/os,
Referer: www.ibmmainframes.com

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
Top
NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “DB2”