IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

TSO IND$FILE from a mainframe PDS to a PC.


IBM Mainframe Forums -> PC Guides & IT News
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 12:49 am
Reply with quote

I need to use IND$FILE to transfer a mainframe PDS down to a PC. I can do it member by member, but I'm hoping someone knows how to do it with one command that will load the PDS members into different files on the PC or even one file that can be parsed.

When I try a GET using the (mainframe.library(*)) syntax it does not like the (*) "denoting all members" parameter. Thanks.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Jul 23, 2010 12:51 am
Reply with quote

Does your 3270 emulator have a scripting langauge available? I would imagine that the process could be scripted.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Jul 23, 2010 12:54 am
Reply with quote

You can't initiate an FTP from your PC???
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 1:22 am
Reply with quote

I don't know if 3270 scripting is present. If so, I'm not familiar in coding it. We use Attachmate EXTRA.

As for FTP, it's a long story but the site with the PDS is a secondary site that is being linked to through another mainframe which is where our 3270 session is hosted.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jul 23, 2010 1:56 am
Reply with quote

Hello,

Your pc most likely has/is a tcp/ip client. FTP is part of this.

Your 3270 connection should play no part in an ftp.

Find the ip address of the lpar with the pds you want to work with and (if you have an id for that system with proper permissions) you can download easily. . .
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 5:08 pm
Reply with quote

I tried using the IP that our EXTRA connection has defined. After initiating FTP I got the following message (I've X'd out the IP):

Connecting to: XXX.XXX.XX.XXX port: 21.
getNextReply error from recv = (1128.769F0442) - EDC8128I Connection refused.
Connection with XXX.XXX.XX.XXX terminated

Am I having firewall issues?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Jul 23, 2010 5:21 pm
Reply with quote

You did not provide enough information to say that you're having firewall issues. Did this FTP get initiated from the mainframe or from your PC? From the EDC8128I message, it appears to be started by your mainframe. If this is the case, be aware that FTP must connect to a server. Most desktop PCs do not run the software that would allow them to act as an FTP server. In general, it is not possible (except in very rare circumstances) to FTP from anything to a desktop PC.
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 5:29 pm
Reply with quote

I was initiating the FTP from a 3270 client on my PC. A 3270 client that was connected to the IP I was trying to FTP from.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Jul 23, 2010 5:32 pm
Reply with quote

I was going to suggest. maybe as a last resort, to try to setup and use the ISPF File Transfer (ISPF 3.7) facility.
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 5:39 pm
Reply with quote

Kevin,

That's where I began from (if you see my first post). I tried that using IND$FILE file transfer. I can download one member at a time from the PDS, but I'd like to download the entire PDS with one command. I was hoping that was possible and someone here could give me syntax help.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Jul 23, 2010 5:41 pm
Reply with quote

Quote:
I was initiating the FTP from a 3270 client on my PC. A 3270 client that was connected to the IP I was trying to FTP from.
This makes absolutely no sense. It does not matter if your 3270 emulator is connected to the mainframe or not. If your are running a batch job on the mainframe to do the FTP, it must connect to a server -- not a desktop PC (not even one running a 3270 emulator).

If you were, indeed, attempting to use FTP on the PC to connect to your mainframe then you do have network issues and need to contact your site support group since they are the only ones who can help you.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Jul 23, 2010 5:45 pm
Reply with quote

They're not the same thing. Beyond that, since I don't have Attachmate, and haven't worked in a shop that has IND$FILE enabled in at least 15 years, I have no further comments.
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 5:49 pm
Reply with quote

TANSTAAFL,

I'm thinking with the 3270 client I have the ability to push or pull files from the lpar IP. Due to firewall issues I can not push (FTP) from the lpar ip to our site here. Make sense?
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 5:55 pm
Reply with quote

Kevin,

If you're still there, I thought 3.7 was the same thing as I was trying. I tried 3.7 option 2 (dataset) and get the response:

no connection

It does not even let me identify the mainframe PDS or the workstation destination.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jul 23, 2010 7:20 pm
Reply with quote

Hello,

It sounds like you are running hard without a direction. . .

Suggest you find the ip address of the ftp service on the mainframe with the pds and make sure you have an id and permissions on that system (if the pds is on shared dasd, there may be other possibilities).

On your pc, open the ftp client and log onto that ftp ip address.

Download the file(s) to your pc.

There would be no jcl on the mainframe.
Back to top
View user's profile Send private message
Ronald Burr

Active User


Joined: 22 Oct 2009
Posts: 293
Location: U.S.A.

PostPosted: Fri Jul 23, 2010 7:42 pm
Reply with quote

Just a suggestion:

a) Use IEBPTPCH to unload the PDS to a flatfile on the mainframe
Code:
//STEP1    EXEC PGM=IEBPTPCH             
//SYSUT1   DD DSN=your.pds,DISP=SHR     
//SYSUT2   DD DSNAME=your.flatfile,     
//            UNIT=DISK,DISP=(NEW,CATLG),
//            SPACE=(CYL,(x,y),RLSE)     
//SYSPRINT DD SYSOUT=*                   
//SYSIN    DD *                         
  PUNCH TYPORG=PO                       
/*                                       


b) Use IND$FILE to download the resulting flatfile to the PC
c) Use "whatever" to parse/process the downloaded flatfile.

Note1: The unloaded flatfile will be RECFM FBA, so column 1 of each record will be a control byte that is NOT part of the unloaded data
Note2: In the flatfile each unloaded member will be preceded by a header ( starting in column 2, of course ) of the form:

MEMBER NAME xxxxxxxx
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Jul 23, 2010 8:23 pm
Reply with quote

The ISPF option:

7 Transfer Download ISPF Client/Server or Transfer data set

requires that you have the ISPF Workstation Agent (WSA) installed, configured, and running on your workstation. The WSA runs on your local workstation and maintains a connection between the workstation and the ISPF host.

See Appendix A. Installing the Client/Server component

and

Download data set to workstation utility (option 3.7)

and, if you want to code some automation using ISPF Services:

z/OS V1R9.0 ISPF Services Guide.
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 8:46 pm
Reply with quote

d.sch,

Thanks. I have a request in with the lpar owner, where the PDS is housed, to let me know if I should be using a different IP (the FTP service)or not. If it's the same then I guess we have a firewall issue here. Not allowing a push into our firewall from this site.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Jul 23, 2010 8:50 pm
Reply with quote

f8ful, you have completely and totally missed the point of Kevin's post. If your PC does not have WSA installed on it, there is no firewall issue -- there is no network issue -- there is an issue on your PC.

Actually, PEBKAC applies here very strongly. You're ignoring what you are being told and going off on your little fantasy, where you think there are network issues without any indication of such.
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 8:54 pm
Reply with quote

Kevin,

Your PDS to flat file sounds doable for sure. I'll hold out at this point for a PDS to "somehow" parsed PC file. We are talking over 700 members at roughly 4000 lines of code apiece.

The 3.7 option is apparently not defined for us as I get "no connnection" when I try to initiate 3.2 option 2 (Data Set Download/upload ISPF library, partitioned, or seq data set).

Getting that established would probably be probelematic since I'm talking outside our organization.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jul 23, 2010 9:07 pm
Reply with quote

Hello,

Quote:
Not allowing a push into our firewall from this site.
If you do this as i suggested, there will be no "push". You would PULL the data from the mainframe.

The only way you could PUSH the data onto your pc with ftp is if your pc was configured as an ftp server not a client. Most organizations do not permit individual pc's to run an ftp server. . .
Back to top
View user's profile Send private message
f8ful

New User


Joined: 02 Nov 2006
Posts: 30

PostPosted: Fri Jul 23, 2010 10:17 pm
Reply with quote

d.sch.

As I said, I have a request in for IP information with the lpar owner. The only way I know to initiate FTP from my PC is through the 3270 client that I have and this would actually be initiating the FTP from the lpar which would constitute the "PUSH". If 3.7 (TSO) is initiating FTP from my PC then I have "no connection".
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jul 23, 2010 10:41 pm
Reply with quote

it always amazes me how much people know,
yet they can't get jack to work.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Jul 23, 2010 10:58 pm
Reply with quote

Hello,

Quote:
The only way I know to initiate FTP from my PC is through the 3270 client that I have
Then it is time to learn more. . . What you know is quite incomplete.

FTP is part of your tcp/ip software. To see this, go to the old command prompt and at the > key ftp and press Enter. You will (should) see ftp> from whence you can run an ftp session "by hand".

Your system most likely has a Windows version of FTP that supports point-and-click. . .

It is possible that your 3270-emulator, ftp, and other features are all part of an overall product, but ftp will run even if the 3270 is not connected.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jul 23, 2010 11:05 pm
Reply with quote

plus, you can obtain the IP address from your emulator.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> PC Guides & IT News Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top