CMSTSO Pipelines Discussion List wrote on
07/20/2015 11:30:18 AM:
> From: "Gentry, Steve"
> To: CMS-PIPELINES@VM.MARIST.EDU
> Date: 07/20/2015 11:30 AM
> Subject: Re: Capturing output from a pipe
> Sent by: CMSTSO Pipelines Discussion List
>
> Correct, sort of. I want to programmatically captu
Correct, sort of. I want to programmatically capture those messages. I just
did a cut-n-paste from the console log to the email to show as an example.
-Original Message-
From: CMSTSO Pipelines Discussion List [mailto:CMS-PIPELINES@VM.MARIST.EDU] On
Behalf Of Michael Harding
Sent: Monda
quot;Gentry, Steve"
To: CMS-PIPELINES@VM.MARIST.EDU
Date: 20-07-15 19:35
Subject: [CMS-PIPELINES] Capturing output from a pipe
Sent by:CMSTSO Pipelines Discussion List
I'm running the following pipe:
29 *-* 'pipe',
'sql select TA
CMSTSO Pipelines Discussion List wrote on
07/20/2015 11:14:32 AM:
> From: Paul Gilmartin
> To: CMS-PIPELINES@VM.MARIST.EDU
> Date: 07/20/2015 11:14 AM
> Subject: Re: Capturing output from a pipe
> Sent by: CMSTSO Pipelines Discussion List
>
> On 2015-07-20 12:04, Gentry, Steve wrote:
> > I thou
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 normal after the pipe is done.
>
If the SQL pipe is embedded in an EXEC, you should be able to
SPOOL
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 normal after the pipe is done.
HYPER: I didn't know you could do this.
-Original Message-
From: CMSTSO Pipelines Discussion List [mailto:
On 2015-07-20 11:34, Gentry, Steve wrote:
> I'm running the following pipe:
> 29 *-* 'pipe',
>'sql select TABLETYPE',
>...
>
> And I'm getting the errors below displayed on the console:
>
> FPLSQL354E Return code -1060 from SQL, detected in module SQLRR003
> ...
>
> I'd
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/',