Re: AS/400 FTP to z/OS
QUOTE SITE WRAP Will allow the ftp to wrap the incoming record(s) into multiple records in the z/OS legacy dataset. Of course, you can't stitch them back together again, to determine the original records on the AS/400. Going into a UNIX file would preserve the original record structure. But processing it may be a bit difficult. Especially in something like COBOL. -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell john.mck...@healthmarkets.com * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM > -Original Message- > From: IBM Mainframe Discussion List > [mailto:ibm-m...@bama.ua.edu] On Behalf Of John Kington > Sent: Monday, February 22, 2010 1:44 PM > To: IBM-MAIN@bama.ua.edu > Subject: Re: AS/400 FTP to z/OS > > George, > > >I've got a vendor that is FTP'ing a file size of 96K and I > was wondering > >if any of the listeners in this group know how to handle a > record size > >that large? As always your help is appreciated... > > The only think I can think of at the moment is to ftp it to a > hfs dataset. You could then chunk it up later to fit within > the lrecl limit. > > Regards, > John > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html > > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: AS/400 FTP to z/OS
On 22 February 2010 14:30, George Rodriguez
wrote:
> I've got a vendor that is FTP'ing a file size of 96K and I was wondering
> if any of the listeners in this group know how to handle a record size
> that large? As always your help is appreciated...
All AS/400 files are "database files", and they have structure
(schema) information that goes with the raw data. An AS/400 FTP server
needs to be able to translate a database file to some streamable
format, and that's probably where you need to start, i.e. talk to your
AS/400 people about the data layout.
Well, there are also hfs-like ("IFS") files on the box, and
transferring the data their first may be another direction to look at.
Still, you need the structure information. There are AS/400 tools to
map such structure to C structs, and I'm sure also to COBOL and other
languages.
The good news perhaps is that the database files are in EBCDIC. (The
IFS stuff is in Unicode.)
Tony H.
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: AS/400 FTP to z/OS
>Smart thinking, it didn't even dawn on me to use hfs. Is there a manual >that I can read to learn how? These are the type of datasets used by Unix System Services. You should be using these already in some fashion. Zman is right in asking if the file is truely one long string of bytes (record). I would try to see what the file really looks like first. Since you say it is an invoice, I suspect there are multiple records (line breaks) in the file. Regards, John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: AS/400 FTP to z/OS
It's my guess that it's an invoice and what we will need to do is break it apart for each school and ship their piece to each school. Thanks, George Rodriguez Specialist II - IT Solutions Application Support / Quality Assurance PX - 47652 (561) 357-7652 (office) (561) 707-3496 (mobile) School District of Palm Beach County 3348 Forest Hill Blvd. Room B-332 West Palm Beach, FL. 33406-5869 Florida's Only A-Rated Urban District For Five Consecutive Years -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of zMan Sent: Monday, February 22, 2010 2:48 PM To: IBM-MAIN@bama.ua.edu Subject: Re: AS/400 FTP to z/OS On Mon, Feb 22, 2010 at 2:44 PM, John Kington wrote: > George, > > >I've got a vendor that is FTP'ing a file size of 96K and I was wondering > >if any of the listeners in this group know how to handle a record size > >that large? As always your help is appreciated... > > The only think I can think of at the moment is to ftp it to a hfs dataset. > You could then chunk it up later to fit within the lrecl limit. > Yeah, what's the real requirement? Do you really need a file with a 96K record in it? What kind of data is it? How will it be processed on z/OS? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- --Palm Beach County Schools- Rated "A" by the Florida Department of Education 2005-2009 -Home of Florida's first LEED Gold Certified School- ---http://www.palmbeachschools.org- The District of Palm Beach County is an Equal Education Opportunity Provider and Employer. Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: AS/400 FTP to z/OS
Smart thinking, it didn't even dawn on me to use hfs. Is there a manual that I can read to learn how? Thanks, George Rodriguez Specialist II - IT Solutions Application Support / Quality Assurance PX - 47652 (561) 357-7652 (office) (561) 707-3496 (mobile) School District of Palm Beach County 3348 Forest Hill Blvd. Room B-332 West Palm Beach, FL. 33406-5869 Florida's Only A-Rated Urban District For Five Consecutive Years -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John Kington Sent: Monday, February 22, 2010 2:44 PM To: IBM-MAIN@bama.ua.edu Subject: Re: AS/400 FTP to z/OS George, >I've got a vendor that is FTP'ing a file size of 96K and I was wondering >if any of the listeners in this group know how to handle a record size >that large? As always your help is appreciated... The only think I can think of at the moment is to ftp it to a hfs dataset. You could then chunk it up later to fit within the lrecl limit. Regards, John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- --Palm Beach County Schools- Rated "A" by the Florida Department of Education 2005-2009 -Home of Florida's first LEED Gold Certified School- ---http://www.palmbeachschools.org- The District of Palm Beach County is an Equal Education Opportunity Provider and Employer. Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: AS/400 FTP to z/OS
On Mon, Feb 22, 2010 at 2:44 PM, John Kington wrote: > George, > > >I've got a vendor that is FTP'ing a file size of 96K and I was wondering > >if any of the listeners in this group know how to handle a record size > >that large? As always your help is appreciated... > > The only think I can think of at the moment is to ftp it to a hfs dataset. > You could then chunk it up later to fit within the lrecl limit. > Yeah, what's the real requirement? Do you really need a file with a 96K record in it? What kind of data is it? How will it be processed on z/OS? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: AS/400 FTP to z/OS
George, >I've got a vendor that is FTP'ing a file size of 96K and I was wondering >if any of the listeners in this group know how to handle a record size >that large? As always your help is appreciated... The only think I can think of at the moment is to ftp it to a hfs dataset. You could then chunk it up later to fit within the lrecl limit. Regards, John -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
AS/400 FTP to z/OS
I've got a vendor that is FTP'ing a file size of 96K and I was wondering if any of the listeners in this group know how to handle a record size that large? As always your help is appreciated... George Rodriguez Specialist II - IT Solutions Application Support / Quality Assurance PX - 47652 (561) 357-7652 (office) (561) 707-3496 (mobile) School District of Palm Beach County 3348 Forest Hill Blvd. Room B-332 West Palm Beach, FL. 33406-5869 Florida's Only A-Rated Urban District For Five Consecutive Years -- --Palm Beach County Schools- Rated "A" by the Florida Department of Education 2005-2009 -Home of Florida's first LEED Gold Certified School- ---http://www.palmbeachschools.org- The District of Palm Beach County is an Equal Education Opportunity Provider and Employer. Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
