Re: Could not do a physical-order read to fetch ne

Posted in 2018

MUKESH — Fri, 27 Apr 2018 15:37:14 — source: IIUG Forums & Mailing Lists

So a simple procedure like below will work right CREATE PROCEDURE public.sysdbopen() SET LOCK MODE TO WAIT 60;END PROCEDURE; do we need to manually execute the procedure or else automatically will it call once the user connects to the database?

↪ replying to MUKESH

Paul Watson — Fri, 27 Apr 2018 15:41:45 — source: IIUG Forums & Mailing Lists

Works by magic on a new connection -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MUKESH TANUKU Sent: Friday, April 27, 2018 10:37 AM To: ids@iiug.org Subject: Re: Could not do a physical-order read to fetch ne [41070] So a simple procedure like below will work right CREATE PROCEDURE public.sysdbopen() SET LOCK MODE TO WAIT 60;END PROCEDURE; do we need to manually execute the procedure or else automatically will it call once the user connects to the database? **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.