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
 

 

Having ftp issues with vb files.

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

New User


Joined: 26 Jul 2006
Posts: 30
Location: Des Moines, Iowa

PostPosted: Fri Oct 09, 2009 8:42 pm    Post subject: Having ftp issues with vb files.
Reply with quote

We are trying to develop a process for moving long-term archived files from the mainframe to the LAN for storage. The problem arises where we might need to copy a file back to the mainframe for data recovery.

I've attempted to use the Micro Focus Mainframe Access (MFA) Drag N Drop tool to move files, but am having issues copying files back to the mainframe. Also this tool is limited in that it can only work with DASD-based data.

I CAN use FTP to access tape-based datasets. An interesting point is that once the variable-blocked files have been downloaded, I can use them inside Mainframe Express projects without any apparent problems.

When I try to FTP the files back to the mainframe, then compare the newly copied file against the original (using a DASD-based copy) using SuperCE I'm seeing differences that appear to be in the record descriptor word for each record.

I do use syntax QUOTE SITE to pass the file attributes to the mainframe before doing the PUT operation from the PC.

Please note that I can move fixed block records up, down, etc., without any sort of issue.

I'm hoping that someone will have experience doing what I'm trying to do.

Thanks in advance for your consideration!

Dave
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


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

PostPosted: Fri Oct 09, 2009 8:47 pm    Post subject:
Reply with quote

Are you transferring the variable blocked data in binary or text mode? Is your FTP configured to preserve trailing blanks? And do you have trailing blanks in your variable length blocks?

Fixed data transfers are never an issue -- they're easy (pretty much). Since the mainframe and PC use radically different methods to handle variable length data, however, that's where you can run into major issues.

The fastest, easiest solution might be to use TRSMAIN to terse the data (which creates fixed length data no matter the input) and transfer the tersed data file.
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 Oct 09, 2009 8:49 pm    Post subject: Reply to: Having ftp issues with vb files.
Reply with quote

What options that specifically relate to VB datasets do you have specified in your process?
Back to top
View user's profile Send private message
dchristensen

New User


Joined: 26 Jul 2006
Posts: 30
Location: Des Moines, Iowa

PostPosted: Fri Oct 09, 2009 9:03 pm    Post subject:
Reply with quote

I'm using BINARY to transfer the data.

The attributes I use when I enter the QUOTE SITE are:
RECFM=VB
LRECL=15830
BLKSIZE=27998
TR
PRI=35000
SEC=2000

Dave
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Fri Oct 09, 2009 9:13 pm    Post subject:
Reply with quote

You need QUOTE SITE RDW on both FTP transfers, I beileve. I've never really used QUOTE SITE RDW much so I'm not sure of the details (possibly you'll need QUOTE LOCSITE RDW on the transfer to the PC?) but I do know just doing a binary transfer will strip off the RDW fields.
Back to top
View user's profile Send private message
dchristensen

New User


Joined: 26 Jul 2006
Posts: 30
Location: Des Moines, Iowa

PostPosted: Fri Oct 09, 2009 9:17 pm    Post subject:
Reply with quote

Thanks!

I'll give that a try and let you know how it worked out.
Back to top
View user's profile Send private message
dchristensen

New User


Joined: 26 Jul 2006
Posts: 30
Location: Des Moines, Iowa

PostPosted: Fri Oct 09, 2009 10:57 pm    Post subject: Update
Reply with quote

I've now completed the download and upload back to the mainframe. I think I still have an issue with SuperCE telling me that the files have differences. A simple comparison of attributes is showing the number of tracks being different between files.

Original file: 35,022 tracks
Latest uploaded file: 40.403 tracks
Back to top
View user's profile Send private message
dchristensen

New User


Joined: 26 Jul 2006
Posts: 30
Location: Des Moines, Iowa

PostPosted: Fri Oct 09, 2009 11:02 pm    Post subject:
Reply with quote

I'm going to try to upload a document that will show screen clips of screens where I'm browsing the files on the mainframe.
Back to top
View user's profile Send private message
dchristensen

New User


Joined: 26 Jul 2006
Posts: 30
Location: Des Moines, Iowa

PostPosted: Fri Oct 09, 2009 11:08 pm    Post subject:
Reply with quote

Okay. I'm at a loss. How do I attach a document?
Back to top
View user's profile Send private message
dchristensen

New User


Joined: 26 Jul 2006
Posts: 30
Location: Des Moines, Iowa

PostPosted: Fri Oct 09, 2009 11:40 pm    Post subject: Update
Reply with quote

Okay. I tried both ways for the upload. First with the RDW parm and second without. I can report that I lost record integrity both times.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Sat Oct 10, 2009 12:48 am    Post subject:
Reply with quote

I tried it and lost the RDW as well. However, the RDW is preserved when I added to my FTP JCL:
Code:
//SYSFTPD  DD   *
RDW TRUE
/*
but I haven't figured out how to bring the file back yet -- the new file has another RDW in front of the old RDW and the new one is exactly 4 more than the old RDW ('0088'x became '008C'x, '0150'x became '0154'x).

Experimentation continues.
Back to top
View user's profile Send private message
dchristensen

New User


Joined: 26 Jul 2006
Posts: 30
Location: Des Moines, Iowa

PostPosted: Mon Oct 12, 2009 5:05 pm    Post subject: Reply to: Having ftp issues with vb files.
Reply with quote

Thanks for the info, Robert.

I'll be continuing my efforts today. Thus far, I have been only working with the command line FTP client on my XP-based PC. I will keep you posted.

Thanks again!

Dave
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 Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm


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