Hi, how can I take a table in my Windows NT 4 UDB 7.2.4 database and transfer it to my exact same table on my database running on S/390 v7.1?

In other words, how can take a table from a PC environment and transfer it to the mainframe side which the mainframe side would understand the PC format? Any examples of files or JCLs would be appreciated.

Thanks.

I can think of two options :

1) Export the Windows DB2 Table in ixf format and use IMPORT Command to get the data into DB2 for OS/390

2) Use Crossloader on the mainframe to 'pull' data from Windows .

The former one requires DB2 Connect ...

Sathyaram

If you are talking about data and this is the only software you have. Then the easy way is to :

Export you data to a csv flat file.
FTP the csv file to a Mainframe PDS using TCP/IP.
Use that PDS as input to your OS/390 load utility.

Good Luck.

p.s. If you have more IBM software let us know and their could be several more solutions.

Just curious MrBill,
did Version 7 on zOS support load from a delimited file ?

Cheers
Sathyaram

MrBill, would you have an example of the export command you would use on the PC and an example of the LOAD command you would use in your JCL?

Thanks.

Sorry for the confusion.
I went back to see how we have it running and I will list all the steps.
This is going form udb on nt to db2 on z/os.

1) we use QMF for windows to do the extract to a flat file. scheduled as qmf batch.
2) we save one copy as a csv and one copy as a txt.
3) the csv copy goes to our backup udb on nt.
4) the txt file is ftp to the mainframe
5) standard os/390 load utility is used.

I am currently converting this process to the warehouse manager. makes it a lot easier.

So I'm better off to continue the way that I operate.

I use Microsoft Quickwin version 3.00 which has spufiwin version 2.00 from IBM integrated to extract my data from the DB2 UDB v7.2.4 to a flat file and from their I FTP the file to the mainframe. From their I can just run a simple load. I want to get rid of Spufiwin since it's dated back 1994 and I wanted to use something more efficient.

Thanks for your help.