Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / May 2006

Tip: Looking for answers? Try searching our database.

How to upload a sql file as a member of a data set in db2

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin CH - 04 May 2006 17:33 GMT
Hi,

The topic pretty much says it all.  The terminal emulation program is
PCOMM connecting to a mainframe.  I can send files as sequential data
sets, but not "DATASET(MEMBER)"
The TSO error message is "incorrect option specified"

TIA.
Rhino - 04 May 2006 18:06 GMT
> Hi,
>
> The topic pretty much says it all.  The terminal emulation program is
> PCOMM connecting to a mainframe.  I can send files as sequential data
> sets, but not "DATASET(MEMBER)"
> The TSO error message is "incorrect option specified"

I have had very little contact with the mainframe in several years now but,
back when I was mostly a mainframe guy, I used to use the SEND and RECEIVE
commands to transfer files between PCs and mainframes. For instance, this
line:

"RECEIVE A:\CLIST\ALFPRINT    B:'TSO1234.CLIST(ALFPRINT)'           ASCII
CRLF"

would download a member, ALFPRINT, from a PDS named TSO1234.CLIST and store
it on the A: disk of my PC in a directory called CLIST.

This line:

"SEND A:\CLIST\ALFPRINT     B:'TSO1234.CLIST(ALFPRINT)'                ASCII
CRLF"

would send a file name ALFPRINT in a directory called CLIST on the A: drive
of my PC, to be stored in a PDS named TSO1234.CLIST with the member name
ALFPRINT.

The SEND and RECEIVE commands have been around for many years and I believe
they are still available. You simply have to execute SEND and RECEIVE
commands until you have done what you want to do. You can easily put them in
scripts that include the instructions to create the directories or datasets
if you like.

I'm not saying that this is the only way to transfer files or even the best
way. However, this way *should* work in your environment.

--
Rhino
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.