View previous topic :: View next topic
|
Author |
Message |
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Hi,
We are migrating the Cobol programs form Z/OS to unix, and in Z/OS we are using the DSNTIUAL utility to download and upload the data from/into table, but this utility is not working in unix,
My question is, is there any utility for downloading/uploading data from/into table in unix through JCL.
Thanks in advance.
Srinath |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello Srinath and welcome to the forum,
Suggest you talk with the unix dba as to how the data needs to be formatted to load on the unix system and which unix database utility is used to load the data.
On unix you will possibly use a "script" instead of jcl to run the batch load.
The way we did this (not using db2, but another database system) was to unload the data on the mainframe, ftp the files to the unix system, and then load the data on the unix system. |
|
Back to top |
|
|
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Hi Dick Scherrer,
Thanks for your reply,
but in our case we are not using scripts we are using JCL's, can you please suggest me the unix utilities for download/upload.
Thanks again!!!
Srinath D |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You are using mainframe jcl on an aix unix system? When we migrated work from the mainframe to aix, all we used on aix was shell scripts.
If you are running mainframe jcl on aix unix, someone who knows that configuration will need to help.
Suggest you start with your aix dbas. |
|
Back to top |
|
|
srinathds83
New User
Joined: 17 Jul 2007 Posts: 41 Location: pune
|
|
|
|
Hi Dick Scherrer,
Thanks a lot for the quick reply...
Srinath |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome - good luck
d |
|
Back to top |
|
|
lokanathareddy
New User
Joined: 05 Mar 2005 Posts: 11 Location: pune
|
|
|
|
Hello Srinath,
Even i am also looking for the same utility. My requirement is bit different. I want to use same utility to load/unload in mainframes and Microfocus/DB2/Unix.
Lokanath. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Quote: |
Anudeep is irritating |
What kind of signature is this? |
|
Back to top |
|
|
|