Author |
Message |
Topic: Deleting consecutive records using Sort/Fileaid |
newuser
Replies: 2
Views: 2899
|
Forum: Utilities Posted: Wed Jun 22, 2005 12:28 pm Subject: Deleting consecutive records using Sort/Fileaid |
This is simply great, Kolusu ! Exactly the solution I was looking for...I tried in a similar site for the solution, but didnot have luck there.
I tried your 2 simple steps and it works like a charm ... |
Topic: Deleting consecutive records using Sort/Fileaid |
newuser
Replies: 2
Views: 2899
|
Forum: Utilities Posted: Wed Jun 22, 2005 11:07 am Subject: Deleting consecutive records using Sort/Fileaid |
Hello,
Just trying my luck in this forum for a sort/fileaid solution.
I have Syncsort, Fileaid. Unfortunately I dont have DFSORT. I prefer not to use SAS, EZtrieve,rexx etc.
I have a dataset ... |
Topic: Retrieve Data from a relative location - rexx/utilities |
newuser
Replies: 1
Views: 1340
|
Forum: TSO and ISPF Posted: Tue Aug 03, 2004 4:13 pm Subject: Retrieve Data from a relative location - rexx/utilities |
Hi,
I need to read a file and check if the string '000300002000' is present anywhere in the record. If the string is present, then I need to navigate forward 249 bytes from this(start of 00030000200 ... |
Topic: Cobol Internal Sort on Multiple Record Layouts |
newuser
Replies: 1
Views: 1861
|
Forum: Application Programming Posted: Fri Sep 26, 2003 9:13 am Subject: Cobol Internal Sort on Multiple Record Layouts |
Hello,
I need to sort an input file on 2 fields. The input file is fixed length 25000 byte.
The problem I have is some of the records span multiple lines, say multiple records.
I need to keep tho ... |
Topic: Another VBM question: Include/OMIT condition |
newuser
Replies: 10
Views: 7022
|
Forum: Utilities Posted: Thu Aug 14, 2003 1:38 pm Subject: Another VBM question: Include/OMIT condition |
Thank You Frank. Your answer prompted to try with VLSHRT option with synctool. (Removed $ortparm, vltestI statements) And looks like it works...I tried two different files and the output is as expecte ... |
Topic: Another VBM question: Include/OMIT condition |
newuser
Replies: 10
Views: 7022
|
Forum: Utilities Posted: Wed Aug 13, 2003 4:56 pm Subject: Another VBM question: Include/OMIT condition |
Nope..No luck...
Also, in my previous post, eventhough the COPY is giving zero returncode, I dont think it is doing anything that is in the CTL1 cards as is evident from the messges..
Gave up on ... |
Topic: Create a new record from VBM file |
newuser
Replies: 5
Views: 3904
|
Forum: Utilities Posted: Wed Aug 13, 2003 4:52 pm Subject: Create a new record from VBM file |
As Cogito provided, just coded as,
//OUTREC=(1,5,C'Header...'
Not sure, but I am getting X'01' for machine control character, which is what I wanted and so.....Don't know, what val ... |
Topic: Create a new record from VBM file |
newuser
Replies: 5
Views: 3904
|
Forum: Utilities Posted: Wed Aug 13, 2003 1:11 pm Subject: Create a new record from VBM file |
Kolusu,
My input file is VBM 214 format. I tried coding the Header statement, but it abended saying "Incompatible RECFM"
//STEP0100 EXEC PGM=SORT
//SYSPR ... |
Topic: Another VBM question: Include/OMIT condition |
newuser
Replies: 10
Views: 7022
|
Forum: Utilities Posted: Wed Aug 13, 2003 12:28 pm Subject: Another VBM question: Include/OMIT condition |
Thanks Kolusu,
I also figured the same...Used the $0RTPARM dd as:
//STEP0100 EXEC PGM=SYNCTOOL
//*
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//IN DD ... |
Topic: Another VBM question: Include/OMIT condition |
newuser
Replies: 10
Views: 7022
|
Forum: Utilities Posted: Tue Aug 12, 2003 4:00 pm Subject: Another VBM question: Include/OMIT condition |
Hi,
I have coded the following Synctool step.
//STEP0100 EXEC PGM=SYNCTOOL,PARM='VLTESTI=1'
//*
//TOOLMSG ... |
Topic: Create a new record from VBM file |
newuser
Replies: 5
Views: 3904
|
Forum: Utilities Posted: Tue Aug 12, 2003 3:31 pm Subject: Create a new record from VBM file |
Hi there,
How do i create a new record to an input file which is VBM format?
I know the contents of the new record, which is constant always. The record is:
HEADER OF THE FILE
I kno ... |
Topic: Delete x previous records based on condition |
newuser
Replies: 5
Views: 3334
|
Forum: Utilities Posted: Mon Jul 28, 2003 5:54 pm Subject: Delete x previous records based on condition |
slade,
No...there is no identifiers for the 2 records just above the SUMMARY record..But I will always have SUMMARY as the identifier in the first position of the record for the SUMMARY record...I ... |
Topic: Delete x previous records based on condition |
newuser
Replies: 5
Views: 3334
|
Forum: Utilities Posted: Mon Jul 28, 2003 3:00 pm Subject: Delete x previous records based on condition |
Hello,
My input file has layout like:
Record1AAAAAAAAAAAAAAAAAAA
BBBBBBBBBBBBBBBBBBBBBBBBB
CCCCCCCCCCCCCCCCCCCCCC
DDDDDDDDDDDDDDDDDDDDDD
1111111111111111111111111111
2222222222222222222 ... |
Topic: Split and change data unconditionally |
newuser
Replies: 3
Views: 3154
|
Forum: Utilities Posted: Mon Jul 21, 2003 12:23 pm Subject: Split and change data unconditionally |
Thanks Frank for the outrec solution.
The problem just got bigger! The input file has Header and Trailer record. Header record is the first record, Trailer record is the last record of the input f ... |
Topic: Split and change data unconditionally |
newuser
Replies: 3
Views: 3154
|
Forum: Utilities Posted: Fri Jul 18, 2003 3:50 pm Subject: Split and change data unconditionally |
Hello,
I am using the following sort to split the iinput file to 4 output files:
//STEP0100 EXEC PGM=SORT
//* ... |
|