By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,319 Members | 2,361 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,319 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jan 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jan 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.