That has been a longstanding UV enhancement request.
I don't understand what their aversion is.
You can surround the select with HUSH ON, HUSH OFF.
Make sure VOC HUSH <4> contains a "K" for "Keep select list active".
Example:
PA or in a pgm:
SELECT VOC CMDS = "SELECT VOC"
HUSH ON CMDS<-1>= "HUSH ON"
SELECT NEWACC CMDS<-1> = "SELECT NEWACC NOPAGE"
HUSH OFF CMDS<-1> = "HUSH OFF"
COUNT NEWACC CMDS<-1> = "COUNT NEWACC"
EXECUTE CMDS
Tony & David,
There are plenty of reasons you might have this situation besides
unstable data that shouldbe be held constant for the duration of a report.
And even with unstable data, there are plenty of reas
An example:
SELECT FILE1 SAVING FOREIGN.KEY
SELECT FILE2 REQUIRE.SELECT
Or a select list built one month and processed the next.
Or say you have a fast moving, volatile file where you have multiple
phantoms processing the same inbox.
The fact that some records appear & disappear is just fine, and doesn't
necessarily warrant a panic screenS full of messages about not being
able to find things in a select list.
UD figured that out. I wish they'd do the same with UV.
On 11/15/2011 1:52 PM, Perry Taylor wrote:
That's the idea. The problem I have is records are being deleted from the file
at all times of the day. What happens is the initial select picks up records
that get deleted before they are output. I was hoping there was some option
that would suppress these messages. If there is not I'll probably have to
rewrite this query in BASIC where I have control.
Perry
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wjhonson
Sent: Tuesday, November 15, 2011 2:01 PM
To: [email protected]
Subject: Re: [U2] [UV] Suppress "not found" in RetrieVe
I think he means as in
SELECT VOC SAMPLE 100
LIST CUSTOMER
'A' not found
'F2' not found
....
And I don't know a way to suppress the messages, but I know a way to not GET
the messages :)
Try this
SELECT VOC SAMPLE 100
SELECT CUSTOMER
do other selects or other processing now and you won't get that message
-----Original Message-----
From: John Thompson<[email protected]>
To: U2 Users List<[email protected]>
Sent: Tue, Nov 15, 2011 10:57 am
Subject: Re: [U2] [UV] Suppress "not found" in RetrieVe
Do you mean on a SELECT or LIST? (Maybe I'm asking the obvious)
On Tue, Nov 15, 2011 at 1:43 PM, Perry Taylor<[email protected]>wrote:
Does anyone know of a RetrieVe option that will suppress the '"xxxx" not
found' messages?
Thanks.
Perry
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.com<http://www.zirmed.com/>
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
