Load Flatfile in UDB (Server) from z/OS-Mainframe

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thomas - 11 Jan 2006 13:32 GMT

Hello out there!

Is there anybody who can help me?
I generated some datas in three flatfiles on our z/OS-Mainframe. But
these datas should be used in a UDB-database on a server.
Has anybody an idea, how I can do the upload direct, quick, easy and
comfortable?
I know, one way is to transfer the files via FTP to the server and then
to realize the upload with an UDB-tool.
But in an other application I realized the upload in an serverbased
Oracle-database directly via mainframe-JCL and -tool, witch is very
comfortable.
This and the fact that UDB is also an IBM-product is why I hope there
is a tool like that.

Thank you for your help

Reply to this Message

Phil Sherman - 12 Jan 2006 16:14 GMT

Your flat files are using the EBCDIC character set which will not be
easy to load without performing an FTP which should convert the data to
ASCII. If you have UDB Connect available, then you can setup the z/OS
database as directly accessible from UDB. Once that is done, the
following SQL should populate your UDB database:

insert into udb_table_name (column_names)
select .... from ......;

Phil Sherman

> Hello out there!
>
[quoted text clipped - 12 lines]
>
> Thank you for your help

Reply to this Message