Re: [CMS-PIPELINES] Selecting multiple record chunks

[Paul Gilmartin]

On 2018-03-02, at 15:18:04, Rob van der Heij wrote:
> ...
> I'm happy you like the book. If you know the "Author's Edition" then the new
> z/VM 6.4 will feel very similar, ...
>  
Yaaay!  Thanks!

Now it needs only to percolate to the TSO instance.

Someone commented on another list that he moved recent CMS pipelines to z/OS
and it simply worked.  Astonishing!  He must at least have re-linked it.  I'm
still skeptical.

-- gil

Re: [CMS-PIPELINES] Selecting multiple record chunks

[Rob van der Heij]

> So in the syntax diagram I think that would fall under:
> Pick ... "List" :  ..."Test": ..."RangeString"

I think the Piper meant to say

 | pick from 5.2 == ,99, count 4

The entire argument for 'pick' in this case is a 'Fromto:' fragment, since
it has both FROM and COUNT. The 'List:' fragment matches the "5.2 == ,99"
So once 'pick' has found a record with the '99' at the right place, records
are selected by counting them.

> The "Author's Edition" and the new IBM z/VM 6.4 CMS Pipelines "Users Guide
> and Reference" certainly do contain the most interesting
> information, versus the older IBM z/VM 6.1 CMS Pipelines "Reference" manual.

I'm happy you like the book. If you know the "Author's Edition" then the new
z/VM 6.4 will feel very similar, and I can be blamed for the mistakes. The
various revision codes show a lot has changed in comparison with z/VM 6.3

Sir Rob the Plumber

Re: [CMS-PIPELINES] Selecting multiple record chunks

[Stanislawski, Shawn (National VM Capability)]

Beautiful!
So in the syntax diagram I think that would fall under:
Pick ... "List" :  ..."Test": ..."RangeString"

The "Author's Edition" and the new IBM z/VM 6.4 CMS Pipelines "Users Guide and 
Reference" certainly do contain the most interesting information, versus the 
older IBM z/VM 6.1 CMS Pipelines "Reference" manual.

--Shawn S.


-Original Message-
From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On 
Behalf Of John P. Hartmann
Sent: Friday, March 02, 2018 1:08 PM
To: CMS-PIPELINES@VM.MARIST.EDU
Subject: Re: [CMS-PIPELINES] Selecting multiple record chunks

pick from 5.2 == /99/ for 4

On 03/02/2018 06:31 PM, Stanislawski, Shawn (National VM Capability) wrote:
> I've got some data, within it reside multiple record chunks that I want.
> The desired record chunks are randomly spaced within the data.  The desired 
> record chunks are composed of 4 consecutive records.
> The record chunks all start with records whose column 5 & 6 contain the 
> characters "99", and then just include the next 3 records (which may or may 
> not contain "99" at column 5 & 6).
> Outside of the desired record chunks no other records contain characters "99" 
> in column 5 & 6.
> The four records of each record chunk are consecutive in the data, but have 
> no common elements or other relation.  And the fifth record could be 
> anything: there's no dedicated end string (even within the 4 records 
> themselves).
>
> I've included a sampling of data below.
> Records 3, 10, 18 contain "99" at column 5 & 6.
> So the desired output would contain only records 
> 3,4,5,6,10,11,12,13,18,19,20,21
>
> Any ideas?
>
>
> 4L3XEBFVWYR6
> 5O1SLFG7AILX
> 4BW699ETK82T
> S9SK9DIER6L5
> G3AHUKPA4H3I
> Q8ZLYL8G46JY
> COB8GJK1AE5N
> 78MKNQJ8MA6S
> 917JZQ33CXOI
> OQN699MQ60GQ
> Z8VOSOZH6V7L
> VC9V78SK49YS
> L0PI3TLT7PGC
> GFI4QQB1OPA6
> YUBSPLB73SFG
> O7NNK3B20GJD
> 3YPU0MCNSMZN
> R4C899NNU9UB
> FIZK74USTG8F
> OF88HQGAOL3S
> I4O29VT3BMG6
> HPXNGMQQK01G
> CUBL7RY00CIQ
> OBR4YA3Y9GF8
> D28H3IA7PKAX
>
>
> --Shawn S.
>

Re: [CMS-PIPELINES] Selecting multiple record chunks

[Michael Harding]

Simple case of "sipping" pipeline:

'PIPE (End ?)',
'<' infile,
'|pck:rexx *.1:',
'|Cons',
'?Literal /* */ Signal On error;',
'Do forever; "Peekto";',   /* test if any input */
'"CallPipe *:||FromTarget Pick 5.2 == /99/ || take 4|| *:";',
'End; Error: Exit Rc*(Rc<>12)',
'|pck:'

--
Mike Harding
z/VM System Support

mhard...@us.ibm.com
mikehard...@mindless.com
(925) 672-3922 | (925) 672-4403 (h)
(925) 323-2070 (m)
/sp


CMSTSO Pipelines Discussion List  wrote on
03/02/2018 09:31:01 AM:

> From: "Stanislawski, Shawn (National VM Capability)" 
> To: CMS-PIPELINES@VM.MARIST.EDU
> Date: 03/02/2018 09:32 AM
> Subject: Selecting multiple record chunks
> Sent by: CMSTSO Pipelines Discussion List 
>
> I've got some data, within it reside multiple record chunks that I want.
> The desired record chunks are randomly spaced within the data.  The
> desired record chunks are composed of 4 consecutive records.
> The record chunks all start with records whose column 5 & 6 contain
> the characters "99", and then just include the next 3 records (which
> may or may not contain "99" at column 5 & 6).
> Outside of the desired record chunks no other records contain
> characters "99" in column 5 & 6.
> The four records of each record chunk are consecutive in the data,
> but have no common elements or other relation.  And the fifth record
> could be anything: there's no dedicated end string (even within the
> 4 records themselves).
>
> I've included a sampling of data below.
> Records 3, 10, 18 contain "99" at column 5 & 6.
> So the desired output would contain only records 3,4,5,6,10,11,12,
> 13,18,19,20,21
>
> Any ideas?
>
>
> 4L3XEBFVWYR6
> 5O1SLFG7AILX
> 4BW699ETK82T
> S9SK9DIER6L5
> G3AHUKPA4H3I
> Q8ZLYL8G46JY
> COB8GJK1AE5N
> 78MKNQJ8MA6S
> 917JZQ33CXOI
> OQN699MQ60GQ
> Z8VOSOZH6V7L
> VC9V78SK49YS
> L0PI3TLT7PGC
> GFI4QQB1OPA6
> YUBSPLB73SFG
> O7NNK3B20GJD
> 3YPU0MCNSMZN
> R4C899NNU9UB
> FIZK74USTG8F
> OF88HQGAOL3S
> I4O29VT3BMG6
> HPXNGMQQK01G
> CUBL7RY00CIQ
> OBR4YA3Y9GF8
> D28H3IA7PKAX
>
>
> --Shawn S.

[CMS-PIPELINES] Selecting multiple record chunks

[Stanislawski, Shawn (National VM Capability)]

I've got some data, within it reside multiple record chunks that I want.
The desired record chunks are randomly spaced within the data.  The desired 
record chunks are composed of 4 consecutive records.  
The record chunks all start with records whose column 5 & 6 contain the 
characters "99", and then just include the next 3 records (which may or may not 
contain "99" at column 5 & 6).
Outside of the desired record chunks no other records contain characters "99" 
in column 5 & 6.
The four records of each record chunk are consecutive in the data, but have no 
common elements or other relation.  And the fifth record could be anything: 
there's no dedicated end string (even within the 4 records themselves).

I've included a sampling of data below.  
Records 3, 10, 18 contain "99" at column 5 & 6.
So the desired output would contain only records 3,4,5,6,10,11,12,13,18,19,20,21

Any ideas?


4L3XEBFVWYR6
5O1SLFG7AILX
4BW699ETK82T
S9SK9DIER6L5
G3AHUKPA4H3I
Q8ZLYL8G46JY
COB8GJK1AE5N
78MKNQJ8MA6S
917JZQ33CXOI
OQN699MQ60GQ
Z8VOSOZH6V7L
VC9V78SK49YS
L0PI3TLT7PGC
GFI4QQB1OPA6
YUBSPLB73SFG
O7NNK3B20GJD
3YPU0MCNSMZN
R4C899NNU9UB
FIZK74USTG8F
OF88HQGAOL3S
I4O29VT3BMG6
HPXNGMQQK01G
CUBL7RY00CIQ
OBR4YA3Y9GF8
D28H3IA7PKAX


--Shawn S.