Home » Infrastructure » Other Operating Systems » transfer data from MVS file to Oracle
transfer data from MVS file to Oracle [message #99324] Wed, 14 May 2003 08:54 Go to next message
shireese statin
Messages: 1
Registered: May 2003
Junior Member
How do I transfer data from an MVS file directly to a Sun Oracle Database?
Re: transfer data from MVS file to Oracle [message #99327 is a reply to message #99324] Thu, 15 May 2003 06:47 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Use TSO FTP (interactively) or JCL code as shown below:

//STEPNAME EXEC PGM=FTP
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
unix.host.name (EXIT=8
userid password
put 'MY.DATASET(MEMEBER) /tmp/unix.member.name
get 'MY.FILE.NAME' /tmp/unix.file.name
quit
/*

Best regards.

Frank
Previous Topic: Autoconnect from REXX script
Next Topic: Is anyone running Oracle on Z/OS 1.3 or above?
Goto Forum:
  


Current Time: Thu Mar 28 12:01:25 CDT 2024