473,320 Members | 1,987 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 1995
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Erwin Moller | last post by:
Hi group, Introduction: I need access to database-functionality for a project. The problem is I cannot be sure that a database exists on all places where I need to run the code. I can only...
3
by: Garrek | last post by:
I have a web application that currently runs on a single server and need to move to a load-balanced environment. The system receives content uploaded by users which will have to be shared among...
22
by: EP | last post by:
When running my asp.net hosting service (asp.net without IIS), on server 2003 with IIS not installed, I get the following when trying to process a request. "System.DllNotFoundException: Unable to...
13
by: Thom Little | last post by:
My first ASP.NET application on Visual Studio 2005 and .NET Framework 2.0 The application compiles and executes correctly on the development machine. I then publish it to an empty directory on...
19
by: natG | last post by:
On a warehouse app, our Java clients constantly load/insert rows into the db. I would like to throttle these inserts (1.5 million rows per hr) from the Java app, based on current 'busy state' of...
0
by: Daniele C. | last post by:
Gladius DB is an efficient flatfile database engine written in pure PHP, it is compatible with a subset of intermediate SQL92 and does not need any additional library to work. It perfectly...
19
by: marckatsambis | last post by:
Hi, I'm struggling to find answers on the problem I'm having, and I desperately need some closure :) I have a bunch of background-images in a css file that are visible locally, but when I...
4
by: gwise | last post by:
I'm trying to use LINUXAIO on my EMT64 db2 v9 FP 2 database server, but I keep getting the following error in my db2diag.log. Funny thing, the file is actually in /usr/lib. For some reason DB2...
39
by: Gilles Ganault | last post by:
Hello, I'm no LAMP expert, and a friend of mine is running a site which is a bit overloaded. Before upgrading, he'd like to make sure there's no easy way to improve efficiency. A couple of...
4
by: Man4ish | last post by:
Hi, How can i connect to database(flatfile) on unix server to access the data on local machine(windows/linux) in C++? Thanks in advance. Regards Manish
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.