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 like to be
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
steve.gen...@westernsouthernlife.com
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 CMS-PIPELINES@VM.MARIST.EDU
I'm running the following pipe:
29 *-* 'pipe',
'sql
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/',
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
CMSTSO Pipelines Discussion List CMS-PIPELINES@VM.MARIST.EDU wrote on
07/20/2015 11:14:32 AM:
From: Paul Gilmartin paulgboul...@aim.com
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
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: