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
 

 

SAS PROC CPORT, PKZIP, and FTP zip file to PC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Charles Wolters

New User


Joined: 30 Mar 2011
Posts: 48
Location: United States

PostPosted: Wed Dec 14, 2011 2:56 am    Post subject: SAS PROC CPORT, PKZIP, and FTP zip file to PC
Reply with quote

I have a huge SAS data set (over 27 million records) on mainframe. Here are the steps I undertook to ultimately get the SAS data set on my PC.

1. Created SAS transport file on mainframe using PROC CPORT.

2. Used PKZIP utility in a batch job to compress SAS transport file

3. Used the Reflections FTP tool (by ATTACHMATE) to transfer zipped data set to my PC. Set the transfer method to binary.

4. Used the Microsoft Extraction Wizard to unzip the transferred data set.

The attempt to unzip the data was unsuccessful. I first called SAS tech support and they had no knowledge of PKZIP but said that for the transfer of a SAS transport file (unzipped) the transfer method should have been binary (which it was).

I called PKZIP technical support and they could find no problems with my program statements. I did specify BINARY as to the type of data set being compressed and they thought that appropriate. They were not familiar with the Reflections FTP tool and suggested I do the FTP in a batch job.

I called ATTACHMATE tech support and they don't have any knowledge of PKZIP but they are still looking into the problem.

Does anyone have any insight on what needs to be done so that my data set can be successfully unzipped? I would be happy to send code from any of the steps if it would aid in finding a solution but every step executed successfully (except the last). I used the "Drop and Drag" approach for the Reflections FTP but did not save the script generated by the tool. I did see the statement "Transmission Successful" .

Charles Wolters
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: Wed Dec 14, 2011 3:24 am    Post subject:
Reply with quote

Hello,

Quote:
The attempt to unzip the data was unsuccessful.
How was this "unsuccessful"? Posting "it didn't work" is basically lost time. . . If someone is to be able to help, you have to provide whatever disgnostic info is available.

Might there be insufficient space on the target system?

What happens if you only process the first few % of the file? The last few % of the file? Do these de-compress successfully? What happens if you transfer a small amount via the the COMMAND prompt ftp (rather than the Reflections tool)? Can you successfully decompress the file on the same system it was compressed?
Back to top
View user's profile Send private message
Charles Wolters

New User


Joined: 30 Mar 2011
Posts: 48
Location: United States

PostPosted: Wed Dec 14, 2011 3:51 am    Post subject: Re: PROC CPORT, PKZIP, and FTP zipped file
Reply with quote

Yes, I think trying the process with a smaller number of records would be a good step. The error message box from the Extraction tool is very terse and the real problem might be insufficient space as you point out.

I have set up the FTP batch program and am now checking with the PC technicians to see that a connection on my PC will be open before I submit.

Trying to unzip the SAS transport file on the mainframe, using a SAS procedure to transform the SAS transport file to a SAS data set and seeing if that is successful would be a worthwhile endeavor. Since the SAS guys know nothing about PKZIP and the PKZIP guys don't know any SAS something could turn up.

I will keep you posted on the results of your suggestions.

Charles
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: Wed Dec 14, 2011 3:56 am    Post subject: Reply to: SAS PROC CPORT, PKZIP, and FTP zip file to PC
Reply with quote

Good luck - someone will usually be here if there discoveries to talk about icon_smile.gif

d
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: Wed Dec 14, 2011 4:58 am    Post subject: Reply to: SAS PROC CPORT, PKZIP, and FTP zip file to PC
Reply with quote

PKZIP is extremely sensitive to extraneous data within a zip archive file. What did you use for the RECFM/LRECL of your zip dataset?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7905
Location: Bellevue, IA

PostPosted: Wed Dec 14, 2011 4:59 am    Post subject:
Reply with quote

Why the zip? Why not just transfer the SAS transport file?
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Dec 14, 2011 12:29 pm    Post subject:
Reply with quote

Why not use on the pc side PKWARE unzip, instead of Microsoft Extraction Wizard. My guess is that MEW uses another zip algoritm, and mainly is used for zipped folders.
Back to top
View user's profile Send private message
Charles Wolters

New User


Joined: 30 Mar 2011
Posts: 48
Location: United States

PostPosted: Wed Dec 14, 2011 8:03 pm    Post subject: Re: SAS PROC CPORT, PKZIP, and FTP zip file to PC
Reply with quote

For block size I specified 27,998 but I did not specify a RECFM parameter. When I went back to the PKZIP manual, I found that the default RECFM was U for undefined. The documentation states that when the RECFM is U the blocksize parameter is ignored. Do you believe this will create problems?

Charles
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Dec 14, 2011 8:08 pm    Post subject:
Reply with quote

Of course. On pc's the OS's dont use RECFM or LRECL or whatever.
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: Wed Dec 14, 2011 11:12 pm    Post subject: Reply to: SAS PROC CPORT, PKZIP, and FTP zip file to PC
Reply with quote

I'd suggest RECFM=VB and an LRECL of 32760.
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

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
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
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


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