Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

TSO IND$FILE from a mainframe PDS to a PC.
Goto page 1, 2, 3  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
View previous topic :: :: View next topic  
Author Message
f8ful

New User


Joined: 02 Nov 2006
Posts: 28

PostPosted: Fri Jul 23, 2010 12:49 am    Post subject: TSO IND$FILE from a mainframe PDS to a PC.
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

Moderator Team Head


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

PostPosted: Fri Jul 23, 2010 12:51 am    Post subject: Reply to: TSO IND$FILE from a mainframe PDS to a PC.
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

Moderator Team Head


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

PostPosted: Fri Jul 23, 2010 12:54 am    Post subject: Reply to: TSO IND$FILE from a mainframe PDS to a PC.
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: 28

PostPosted: Fri Jul 23, 2010 1:22 am    Post subject:
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

Site Director


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

PostPosted: Fri Jul 23, 2010 1:56 am    Post subject:
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: 28

PostPosted: Fri Jul 23, 2010 5:08 pm    Post subject:
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: 7913
Location: Bellevue, IA

PostPosted: Fri Jul 23, 2010 5:21 pm    Post subject:
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: 28

PostPosted: Fri Jul 23, 2010 5:29 pm    Post subject:
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

Moderator Team Head


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

PostPosted: Fri Jul 23, 2010 5:32 pm    Post subject: Reply to: TSO IND$FILE from a mainframe PDS to a PC.
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: 28

PostPosted: Fri Jul 23, 2010 5:39 pm    Post subject:
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: 7913
Location: Bellevue, IA

PostPosted: Fri Jul 23, 2010 5:41 pm    Post subject:
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

Moderator Team Head


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

PostPosted: Fri Jul 23, 2010 5:45 pm    Post subject: Reply to: TSO IND$FILE from a mainframe PDS to a PC.
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: 28

PostPosted: Fri Jul 23, 2010 5:49 pm    Post subject:
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: 28

PostPosted: Fri Jul 23, 2010 5:55 pm    Post subject:
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

Site Director


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

PostPosted: Fri Jul 23, 2010 7:20 pm    Post subject:
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    Post subject:
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

Moderator Team Head


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

PostPosted: Fri Jul 23, 2010 8:23 pm    Post subject: Reply to: TSO IND$FILE from a mainframe PDS to a PC.
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: 28

PostPosted: Fri Jul 23, 2010 8:46 pm    Post subject:
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: 7913
Location: Bellevue, IA

PostPosted: Fri Jul 23, 2010 8:50 pm    Post subject:
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: 28

PostPosted: Fri Jul 23, 2010 8:54 pm    Post subject:
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News All times are GMT + 6 Hours
Goto page 1, 2, 3  Next
Page 1 of 3

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us