By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,333 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,333 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

May 4 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Kevin CH" <hi**********************@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
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
May 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.