Re: [U2] [UV] Suppress not found in RetrieVe
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 OFFCMDS-1 = HUSH OFF COUNT NEWACCCMDS-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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, November 15, 2011 2:01 PM To: u2-users@listserver.u2ug.org 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 Thompsonjthompson...@gmail.com To: U2 Users Listu2-users@listserver.u2ug.org 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 Taylorperry.tay...@zirmed.comwrote: Does anyone know of a RetrieVe option that will suppress the ' not found' messages? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV] Suppress not found in RetrieVe
Does anyone know of a RetrieVe option that will suppress the ' not found' messages? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 perry.tay...@zirmed.comwrote: Does anyone know of a RetrieVe option that will suppress the ' not found' messages? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org 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 perry.tay...@zirmed.comwrote: Does anyone know of a RetrieVe option that will suppress the ' not found' messages? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Suppress not found in RetrieVe
I understand the question is for UV, but for UDT fans, there is a UDT.OPTIONS setting in this area: ON If UDT.OPTIONS 55 is on, UniData displays the records it finds, but does not display any informational messages: :LIST TAPES NAME V6670 V7456 V4951 V1249 LIST TAPES NAME V6670 V7456 V4951 V1249 10:41:47 Jun 08 1999 1 TAPES. Tape Name V7456 A Clockwork Orange V1249 Gone With The Wind 2 records listed : OFF If UDT.OPTIONS 55 is off, UniData lists the records it finds, then displays a message that you must press ENTER to display the missing records. After you press ENTER, UniData lists the deleted records you tried to retrieve. :LIST TAPES NAME V6670 V7456 V4951 V1249 LIST TAPES NAME V6670 V7456 V4951 V1249 10:35:59 Jun 08 1999 1 TAPES. Tape Name V7456 A Clockwork Orange V1249 Gone With The Wind 2 records listed Enter CR to print non exist record ids V6670 V4951 (EOF)Enter h for help, CR for next page : Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, November 15, 2011 12:01 PM To: u2-users@listserver.u2ug.org 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 jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org 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 perry.tay...@zirmed.comwrote: Does anyone know of a RetrieVe option that will suppress the ' not found' messages? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Suppress not found in RetrieVe
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, November 15, 2011 2:01 PM To: u2-users@listserver.u2ug.org 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 jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org 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 perry.tay...@zirmed.comwrote: Does anyone know of a RetrieVe option that will suppress the ' not found' messages? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Suppress not found in RetrieVe
What I'm wondering as a higher-level question is: how important are reports that are so volatile that they are invalid between the select and the print? Certainly they're even more invalid between printing and the time someone reads them. Another approach might be to do a COPY or REFORMAT of selected data into a work file and then report on that. With COPY you can use your existing dicts, and with REFORMAT you copy less data ... trade offs. If nothing else, your bottom line numbers would be consistent, if you are even using totals. HTH T From: Perry Taylor 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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Suppress not found in RetrieVe
Hi Perry You could use transaction control, where you prevent deletes until the report is completed. For instance a GL report with Debits and Credits need to balance, you cannot allow the database to change in the middle of the report, so you wrap transaction control around to prevent updates until the report is complete. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
