467,189 Members | 1,344 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

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

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
  • viewed: 1662
Share:
1 Reply

"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.

Similar topics

3 posts views Thread by dave | last post: by
2 posts views Thread by Gary \(Girish\) | last post: by
10 posts views Thread by Alphonse Giambrone | last post: by
9 posts views Thread by Wayne Smith | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.