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

[Kevin CH]

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]

"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