Re: Split a large file into two parts

2007-08-07 Thread Joel C. Ewing
Ted MacNEIL wrote: Because of the record lenght, I'm not able to use the tso edit function. Why not? ISPF EDIT supports up to 250. ... It would require his TSO session to allocate virtual memory in excess of 75 MB for Edit to load his file into memory. Although Dave indicated the problem

Split a large file into two parts

2007-08-06 Thread Dave Guthrie
I have a 500,000 record text file with a record length of 150 bytes. I'm tring to find some way of splitting it in two. Because of the record lenght, I'm not able to use the tso edit function. I'm sure I have the solution somewhere. Thanks, Dave

Re: Split a large file into two parts

2007-08-06 Thread John Kington
Dave, I have a 500,000 record text file with a record length of 150 bytes.I'm tring to find some way of splitting it in two. Because of the record lenght, I'm not able to use the tso edit function. I'm sure I have the solution somewhere. Thanks, Dave I would use IDCAMS repro. repro

Re: Split a large file into two parts

2007-08-06 Thread John P Kalinich
Dave Guthrie of the IBM Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU wrote on 08/06/2007 08:48:16 AM: I have a 500,000 record text file with a record length of 150 bytes.I'm tring to find some way of splitting it in two. Because of the record lenght, I'm not able to use the tso edit

Re: Split a large file into two parts

2007-08-06 Thread CICS Guy
Sort has several features, by count, by key and a sort of every other. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Dave Guthrie Sent: Monday, August 06, 2007 9:48 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Split a large file into two

Re: Split a large file into two parts

2007-08-06 Thread Reda, John
[mailto:[EMAIL PROTECTED] On Behalf Of John P Kalinich Sent: Monday, August 06, 2007 9:58 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Split a large file into two parts Dave Guthrie of the IBM Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU wrote on 08/06/2007 08:48:16 AM: I have a 500,000 record text

Re: Split a large file into two parts

2007-08-06 Thread Hunkeler Peter (KIUK 3)
I use Syncsort to do this. SORT FIELDS=COPY,STOPAFT=25 OUTFIL FILES=01 END SORT FIELDS=COPY,SKIPREC=25 OUTFIL FILES=01 END The above needs two passes over the input data set. This will do it in one pass: //ICETOOL1 EXEC PGM=ICETOOL

Re: Split a large file into two parts

2007-08-06 Thread Reda, John
PROTECTED] On Behalf Of Reda, John Sent: Monday, August 06, 2007 10:09 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Split a large file into two parts Your solution will work but it requires 2 passes of the data. Try this instead, it only requires 1 pass. SORT FIELDS=COPY OUTFIL FILES=01,ENDREC

Re: Split a large file into two parts

2007-08-06 Thread John P Kalinich
John Reda of the IBM Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU wrote on 08/06/2007 09:30:54 AM: I need to amend my post, it should be: SORT FIELDS=COPY OUTFIL FILES=01,ENDREC=25 OUTFIL FILES=02,STARTREC=250001 I spotted this after reading Peter Hunkeler's post. John Reda

Re: Split a large file into two parts

2007-08-06 Thread Frank Yaeger
Dave Guthrie wrote on 08/06/2007 06:48:16 AM: I have a 500,000 record text file with a record length of 150 bytes.I'm tring to find some way of splitting it in two. Because of the record lenght, I'm not able to use the tso edit function. I'm sure I have the solution somewhere. Dave, Here's a

Re: Split a large file into two parts

2007-08-06 Thread wtrovijo
I have a 500,000 record text file with a record length of 150 bytes. I'm tring to find some way of splitting it in two. Because of the record lenght, I'm not able to use the tso edit function. I'm sure I have the solution somewhere. Thanks, Dave If you have DFSORT try this:

Re: Split a large file into two parts

2007-08-06 Thread Ted MacNEIL
Because of the record lenght, I'm not able to use the tso edit function. Why not? ISPF EDIT supports up to 250. - Too busy driving to stop for gas! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email

Re: Split a large file into two parts

2007-08-06 Thread John P Kalinich
Ted MacNeil of the IBM Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU wrote on 08/06/2007 11:38:23 AM: Because of the record lenght, I'm not able to use the tso edit function. Why not? ISPF EDIT supports up to 250. Edit supports lrecl up to 32760. Regards, John K

Re: Split a large file into two parts

2007-08-06 Thread Kelman, Tom
Of John P Kalinich Sent: Monday, August 06, 2007 11:51 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Split a large file into two parts Ted MacNeil of the IBM Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU wrote on 08/06/2007 11:38:23 AM: Because of the record lenght, I'm not able to use the tso

Re: Split a large file into two parts

2007-08-06 Thread John P Kalinich
-Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of John P Kalinich Sent: Monday, August 06, 2007 11:51 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Split a large file into two parts Ted MacNeil of the IBM Mainframe Discussion List IBM

Re: Split a large file into two parts

2007-08-06 Thread Veilleux, Jon L
I can create and edit an lrecl 32760 file. It doesn't like VBS. Jon L. Veilleux [EMAIL PROTECTED] (860) 636-2683 This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this

Re: Split a large file into two parts

2007-08-06 Thread Kelman, Tom
Tom Kelman wrote: Then why when I try to edit or browse an SMF file on disk (LRECL=32760) do I get the message Invalid Record Length. I just tried it. John Kalinich wrote: Maybe it is variable spanned format? Regards, John K Yes, it is VBS. Then why doesn't the error

Re: Split a large file into two parts

2007-08-06 Thread Veilleux, Jon L
Tom Kelman wrote: Then why when I try to edit or browse an SMF file on disk (LRECL=32760) do I get the message Invalid Record Length. I just tried it. John Kalinich wrote: Maybe it is variable spanned format? Regards, John K Yes, it is VBS. Then why doesn't the error

Re: Split a large file into two parts

2007-08-06 Thread John P Kalinich
Tom Kelman of the IBM Mainframe Discussion List IBM-MAIN@BAMA.UA.EDU wrote on 08/06/2007 01:27:18 PM: Tom Kelman wrote: Then why when I try to edit or browse an SMF file on disk (LRECL=32760) do I get the message Invalid Record Length. I just tried it. John Kalinich wrote:

Re: Split a large file into two parts

2007-08-06 Thread Rick Fochtman
-snip--: Then why when I try to edit or browse an SMF file on disk (LRECL=32760) do I get the message Invalid Record Length. I just tried it. -unsnip- Probably because most SMF files are VBS-format, which, to my

Re: Split a large file into two parts

2007-08-06 Thread Richard Peurifoy
Kelman, Tom wrote: Then why when I try to edit or browse an SMF file on disk (LRECL=32760) do I get the message Invalid Record Length. I just tried it. If you are talking about the file created by the SMFDUMP program, it creates files with an LRECL of 32767. The BLKSIZE is 32760 and they are

Re: Split a large file into two parts

2007-08-06 Thread Clark Morris
On 6 Aug 2007 11:27:35 -0700, in bit.listserv.ibm-main you wrote: Tom Kelman wrote: Then why when I try to edit or browse an SMF file on disk (LRECL=32760) do I get the message Invalid Record Length. I just tried it. John Kalinich wrote: Maybe it is variable spanned format?