469,949 Members | 2,168 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,949 developers. It's quick & easy.

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

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
1 1891
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.

Similar topics

8 posts views Thread by Erwin Moller | last post: by
3 posts views Thread by Garrek | last post: by
13 posts views Thread by Thom Little | last post: by
19 posts views Thread by marckatsambis | last post: by
4 posts views Thread by gwise | last post: by
39 posts views Thread by Gilles Ganault | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.