Re: [CMS-PIPELINES] GLOBALV

2017-12-21 Thread Gentry, Steve
variable, but there is nothing to pick it up and put it into the pipe. On Thu, 21 Dec 2017 at 18:00, Gentry, Steve < steve.gen...@westernsouthernlife.com> wrote: > I'm not understanding something. > Why does this work: GLOBALV SELECT SQL/DS LIST > > And this doesn't

Re: [CMS-PIPELINES] GLOBALV

2017-12-21 Thread Gentry, Steve
> You can do things with "command" like this: > 'PIPE command GLOBALV SELECT $$RDRLIS STACK RDATETYP | append stack | ...' > > If you write a REXX filter, the value() function may be useful to do > what you need. > > Rob > > > On 21 December 2

[CMS-PIPELINES] GLOBALV

2017-12-21 Thread Gentry, Steve
Hi. Is it possible to issue the GLOBALV command from pipes? Or is there a STAGE to retrieve the info? I've tried a number of combination of commands with no luck. Those include "| CMS GLOBALV . . . ." , "| CP GLOBALV . . . ." , "| COMMAND GLOBALV . . . . " and a couple of things with S

Re: [CMS-PIPELINES] FPLSPX1086E Improper operand for string comparison

2017-06-27 Thread Gentry, Steve
Just tried again from the a command line. The '#' (w/o quotes) might be causing the problem. CP is interpreting it as an end of line and I'm guessing the 0 (zero) doesn't get prefixed with the '#' Steve -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.

Re: [CMS-PIPELINES] FPLSPX1086E Improper operand for string comparison

2017-06-27 Thread Gentry, Steve
It works for me in an EXEC as well. I get similar errors when I run it from the command line. -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Ackerman, Alan Sent: Tuesday, June 27, 2017 1:53 PM To: CMS-PIPELINES@VM.MARIST.EDU S

[CMS-PIPELINES] XML pretty print

2017-03-28 Thread Gentry, Steve
Does anyone have a REXX program and/or a PIPE that will output XML pretty print, that they can share? Thanks, Steve

[CMS-PIPELINES] spec question

2017-03-02 Thread Gentry, Steve
I need to put leading zeroes into a number field. Can I do that with SPEC ? For example: specs w1 1 w2 7 w3 11 w4 16.6 right w5 23.6 right w6 nw W4 starts out as 1,3,5,11,44, 123 and so on. The output I'd like to see is 01 03 05 11 44 000123 Thanks, Steve

Re: [CMS-PIPELINES] pipe stage max record length

2016-12-30 Thread Gentry, Steve
@VM.MARIST.EDU Subject: Re: pipe stage max record length CMS does not let you. The file on disk is just storage. You should be able to 'block cms4' and remember to unblock when you use the data. Rob van der Heij z/VM Development Gentry, Steve --- [CMS-PIPELINES] pipe stage max rec

[CMS-PIPELINES] pipe stage max record length

2016-12-30 Thread Gentry, Steve
I received the following error message: FPLDBK078E Record Length 77409 is too much. So I did some experimenting and I suspect the max record length for a stage is 64k. Is there a way to increase this max record length? Splitting the large record into smaller records is not an option. I'm running

Re: [CMS-PIPELINES] the STACK stage

2016-06-24 Thread Gentry, Steve
Paul Gilmartin Sent: Friday, June 24, 2016 11:59 AM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: the STACK stage On 2016-06-24, at 08:19, Gentry, Steve wrote: > I'm not getting the results I'd expect when STACK is the first in a pipeline. > What I thought would happen is the entire S

Re: [CMS-PIPELINES] the STACK stage

2016-06-24 Thread Gentry, Steve
Functioning as designed. 8-) Thanks, Rob -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Rob van der Heij Sent: Friday, June 24, 2016 10:29 AM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: the STACK stage > I'm not getting the re

[CMS-PIPELINES] the STACK stage

2016-06-24 Thread Gentry, Steve
I'm not getting the results I'd expect when STACK is the first in a pipeline. What I thought would happen is the entire STACK is read into the stream and then proceed onto the next stage. This is not happening. Here is my code: 'PIPE stack' , '| take 1' , '| spec 33.8 1' , '| var EXP

Re: [CMS-PIPELINES] About DELAY after SET TIMEZONE

2016-04-10 Thread Gentry, Steve
Could you give more detail on how you would schedule this event? If you're using a scheduler product of some kind, a good scheduler would update the status as to whether or not an event was run (and a few other things). So, turning the clock back, an hour in your example, wouldn't be a problem

[CMS-PIPELINES] CMS PIPE output

2015-12-28 Thread Gentry, Steve
I'm trying to suppress the output from the following code examples. Example 1: I use the HOLE stage RelList='C E F G H I J K L M N O P Q R T U' 'pipe var RelList' , '| split ' , '| spec /RELEASE/ 1 W1 nw /(detach/ nw' , '| CMS' , '| HOLE' Example 2: I remove the HOLE s

Re: [CMS-PIPELINES] CSV data specs

2015-08-20 Thread Gentry, Steve
I had a similar need this week. So thanks for asking Vincent. My data was in the format of 004239,110392,"Vincent, James S.",1-614-249-5547 Only those fields that have a comma within are surrounded by double quotes. I wish it would have been like Rich had suggested - it would have been

Re: [CMS-PIPELINES] Capturing output from a pipe

2015-07-20 Thread Gentry, Steve
from a pipe Sent by: CMSTSO Pipelines > Discussion List > > On 2015-07-20 12:04, Gentry, Steve wrote: > > I thought of both of these: > > SPOOL, couldn't figure out how to do this dynamically. I'd only > want to do this before this pipe starts and return it to

Re: [CMS-PIPELINES] Capturing output from a pipe

2015-07-20 Thread Gentry, Steve
Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Paul Gilmartin Sent: Monday, July 20, 2015 1:42 PM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: Capturing output from a pipe On 2015-07-20 11:34, Gentry, Steve wrote: > I'm running the following pipe: > 29 *-* 'pipe

[CMS-PIPELINES] Capturing output from a pipe

2015-07-20 Thread Gentry, Steve
I'm running the following pipe: 29 *-* 'pipe', 'sql select TABLETYPE', 'from system.syscatalog', "where creator='SYSTEM'", "AND TNAME='SYSCATALOG'", '|not chop 2', '|change /V/1/', '|change /R/0/',

Re: [CMS-PIPELINES] CP command result partial

2015-06-30 Thread Gentry, Steve
Works ok for me. Of course, I substituted valid DASD addresses for my shop. -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Alain Benveniste Sent: Tuesday, June 30, 2015 10:07 AM To: CMS-PIPELINES@VM.MARIST.EDU Subject: CP comm

Re: [CMS-PIPELINES] Conditional reblocking. Or something like that.

2015-05-06 Thread Gentry, Steve
Do they need to be written to two separate files? -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Mark Boonie Sent: Wednesday, May 06, 2015 3:50 PM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Conditional reblocking. Or something lik

Re: [CMS-PIPELINES] SPECS again

2015-04-30 Thread Gentry, Steve
On 30 April 2015 at 22:07, Gentry, Steve < steve.gen...@westernsouthernlife.com> wrote: > Ergo for last 3 words: "word -3;-2;-1" > > -Original Message- > From: CMSTSO Pipelines Discussion List > [mailto:CMS-PIPELINES@VM.MARIST.EDU] > On Behalf Of

Re: [CMS-PIPELINES] SPECS again

2015-04-30 Thread Gentry, Steve
that the last two words is "word -2;-1" On 30 April 2015 at 21:21, Gentry, Steve < steve.gen...@westernsouthernlife.com> wrote: > Thanks. > > -Original Message- > From: CMSTSO Pipelines Discussion List > [mailto:CMS-PIPELINES@VM.MARIST.EDU] > O

Re: [CMS-PIPELINES] SPECS again

2015-04-30 Thread Gentry, Steve
spec On Apr 30, 2015 9:16 PM, "Gentry, Steve" < steve.gen...@westernsouthernlife.com> wrote: > In some recent discussions on this list we had discussed the SPEC stage. > And, I thought, in one of the discussions a solution was presented on > how to get the last word in a

[CMS-PIPELINES] SPECS again

2015-04-30 Thread Gentry, Steve
In some recent discussions on this list we had discussed the SPEC stage. And, I thought, in one of the discussions a solution was presented on how to get the last word in a string of words. In the example below I'd like to get the word fox. pipe literal the quick fox | spec lastword | cons Of c

Re: [CMS-PIPELINES] SPEC and PAD

2015-04-23 Thread Gentry, Steve
like "spec" is still pretty concise. You normally don't have to know it all to make use of it. I've used the structured data and 407 support quite a lot, but a lot can be learned when you need it. Things get easier once you realize that any time that you invest in learn

Re: [CMS-PIPELINES] SPEC and PAD

2015-04-22 Thread Gentry, Steve
of carrying the tools. 8-) -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of John P. Hartmann Sent: Wednesday, April 22, 2015 3:37 PM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: SPEC and PAD On 04/22/2015 09:08 PM, Gentry, Steve wrot

Re: [CMS-PIPELINES] SPEC and PAD

2015-04-22 Thread Gentry, Steve
e, not necessarily those of my employer. -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Gentry, Steve Sent: Wednesday, April 22, 2015 14:09 To: CMS-PIPELINES@VM.MARIST.EDU Subject: SPEC and PAD I've found that SPEC has a PAD option/

[CMS-PIPELINES] SPEC and PAD

2015-04-22 Thread Gentry, Steve
I've found that SPEC has a PAD option/function. From what I've read it is used to pad a field with a leading character. I have a word, in a stream, that can be up to 8 characters long, however, if it isn't 8 characters, I'd like to append a dot/period to complete the 8 characters. I can use th

Re: [CMS-PIPELINES] CONSOLE / CMS and CMS multitasking

2015-04-22 Thread Gentry, Steve
"I've been thinking" too funny, my boss says this a lot. It usually means more work for me. Steve -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of John P. Hartmann Sent: Wednesday, April 22, 2015 12:06 PM To: CMS-PIPELINES@VM.

Re: [CMS-PIPELINES] trying to catch the results from a QUERY.

2015-04-13 Thread Gentry, Steve
CONIO to IUCV to capture the SECUSER output from the LLICPDM user. On Mon, Apr 13, 2015 at 9:54 AM, Gentry, Steve < steve.gen...@westernsouthernlife.com> wrote: > I'm issuing the following command: > 'PIPE CP SEND LLICPDM QUERY | > QUERYPDM DATA A' >

[CMS-PIPELINES] trying to catch the results from a QUERY.

2015-04-13 Thread Gentry, Steve
I'm issuing the following command: 'PIPE CP SEND LLICPDM QUERY | > QUERYPDM DATA A' While the command does work, it returns the information to the console and does not put it in the file. This has to do with query PDMGRP4 printers and I'm suspecting because of this the results don't get

[CMS-PIPELINES] VAR vs. STEM and CONS

2015-04-07 Thread Gentry, Steve
On z/VM , I am running the following pipe: 'PIPE ( endchar ? NOMSGLEVEL 7 LISTERR) SQL NOIND', 'SELECT NAME', 'FROM EMPLOYEE_DIRECTORY', "WHERE USER_ID = '"ud_user"'", '| spec 3-* 1' , '| strip' , '| xlate lower' , '| o: fanout ',

Re: [CMS-PIPELINES] getting the last word

2015-03-03 Thread Gentry, Steve
-Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Gentry, Steve Sent: Tuesday, March 03, 2015 12:32 PM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: getting the last word That works. Thanks. -Original Message- From: CMSTSO Pipeline

Re: [CMS-PIPELINES] getting the last word

2015-03-03 Thread Gentry, Steve
, "Gentry, Steve" < steve.gen...@westernsouthernlife.com> wrote: > I have a variable with words in it and I want to get the last word in > the string. > I came up with the following solution although I don't think it is > very elegant (because of the multi

[CMS-PIPELINES] getting the last word

2015-03-03 Thread Gentry, Steve
I have a variable with words in it and I want to get the last word in the string. I came up with the following solution although I don't think it is very elegant (because of the multiple stages). 'PIPE stem dirstem.' , '| find BUILD' , '| split' , '| take last' , '| var LastW

Re: [CMS-PIPELINES] queue question

2015-02-27 Thread Gentry, Steve
| ... Rob On 26 February 2015 at 22:25, Gentry, Steve < steve.gen...@westernsouthernlife.com> wrote: > (CMS specific - if that matters) > Somewhere recently, I came across a PIPE example that allowed the > QUEUE() to be used in a PIPE. I didn't know this could be done, I t

[CMS-PIPELINES] queue question

2015-02-26 Thread Gentry, Steve
(CMS specific - if that matters) Somewhere recently, I came across a PIPE example that allowed the QUEUE() to be used in a PIPE. I didn't know this could be done, I tried it, etc. I've slept since then. I can't remember the format of the PIPE to do this and I can't remember the name of the EXE

Re: [CMS-PIPELINES] CMS PIPE Help

2014-10-15 Thread Gentry, Steve
Dave, for me, this link required a logon to Share to access. Steve -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Dave Jones Sent: Wednesday, October 15, 2014 1:35 PM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: [CMS-PIPELINES]

Re: [CMS-PIPELINES] Assert failure?

2014-09-08 Thread Gentry, Steve
I do something similar but I do a "PIPE CMS PING . . . ." and put the results in a stem for further processing. Steve -Original Message- From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On Behalf Of Bob Cronin Sent: Monday, September 08, 2014 2:35 PM To: CMS-P

Re: [CMS-PIPELINES] variable length fields

2014-08-26 Thread Gentry, Steve
, 2014 at 12:46 PM, Gentry, Steve < steve.gen...@westernsouthernlife.com> wrote: > I've run a db2 select within a pipe and I get two words back. Both words > have a length field in front of it, in hex. The length of the length > field in the first word is 4 bytes long. Th

[CMS-PIPELINES] variable length fields

2014-08-26 Thread Gentry, Steve
I've run a db2 select within a pipe and I get two words back. Both words have a length field in front of it, in hex. The length of the length field in the first word is 4 bytes long. The length of the length field for the second word is 2 bytes long. So, this is sort of how it looks: THIS

Re: [CMS-PIPELINES] need a SPECS guru

2014-06-27 Thread Gentry, Steve
my record in the stream, sort on date, and ignore all records before the dummy. PS It would be cheating to remind you of the AFTER option on LISTFILE ;-) On 27 June 2014 16:14, Gentry, Steve wrote: > In a CMS environment, I have a list of files, created by LISTFILE. > The format of the f

[CMS-PIPELINES] need a SPECS guru

2014-06-27 Thread Gentry, Steve
In a CMS environment, I have a list of files, created by LISTFILE. The format of the file_type, in this list, will be DATE('S') mmdd I want to take a predetermined date, already in DATE('S') format, and compare it to the above mentioned file_type. If the file type date is less than or eq

Re: [CMS-PIPELINES] pipe question

2013-10-30 Thread Gentry, Steve
U] On Behalf Of Paul Gilmartin Sent: Wednesday, October 30, 2013 4:57 PM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: pipe question On 2013-10-30 14:35, Gentry, Steve wrote: > Yes. Here's the method I ended up using. Provide by a member on another list. > > ... > '|

Re: [CMS-PIPELINES] pipe question

2013-10-30 Thread Gentry, Steve
tober 30, 2013 4:32 PM To: CMS-PIPELINES@VM.MARIST.EDU Subject: Re: pipe question Wouldn't that be: "| PICK 2-3 >>= /00/ ", "| PICK 2-3 <<= /24/ ", "| ... Shimon On Wed, Oct 30, 2013 at 7:55 PM, Gentry, Steve < steve.gen...@westernsouthernlif

[CMS-PIPELINES] pipe question

2013-10-30 Thread Gentry, Steve
I have an input stream with various types of data. I want to select off those records that have 00 thru 24 starting in position 2 and pass those records onto the next stage. They are time stamps in the format hh:mm:ss Can anyone provide a snippet of code to do this? I can think of a cou