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

[Thomas]

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

[Phil Sherman]

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
Thomas wrote:

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