Re: How to set pdq in a 4gl? (no manual and online manual
Posted in 1999
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
--=====================_31256267==_.ALT
Content-Type: text/plain; charset="us-ascii"
At 04:52 PM 12/08/1999 -0500, you wrote:
>how to set pdq in a 4gl? (no manual and online manual doesn't come up!)
>
This worked for me , basically I assigned the sql statement to a string then
I prepare it and execute it. Hope this helps.
let pdq_str = " SET PDQPRIORITY 50 "
whenever error continue
prepare ex_pdq from pdq_str
execute ex_pdq
--=====================_31256267==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
At 04:52 PM 12/08/1999 -0500, you wrote:<br>
>how to set pdq in a 4gl? (no manual and online manual doesn't come
up!)<br>
><br>
This worked for me , basically I assigned the sql statement to a
string then I prepare it and execute it. Hope this helps.<br>
<br>
<font face="Arial, Helvetica" size=4> let pdq_str = "
SET PDQPRIORITY 50 "<br><br>
whenever error continue<br>
<br>
prepare ex_pdq from pdq_str <br>
<br>
execute ex_pdq</font></html>
--=====================_31256267==_.ALT--
Austin Castro wrote:
>
> --=====================_31256267==_.ALT
> Content-Type: text/plain; charset="us-ascii"
>
> At 04:52 PM 12/08/1999 -0500, you wrote:
> >how to set pdq in a 4gl? (no manual and online manual doesn't come up!)
> >
> This worked for me , basically I assigned the sql statement to a
> string then I prepare it and execute it. Hope this helps.
>
> let pdq_str = " SET PDQPRIORITY 50 "
>
> whenever error continue
>
> prepare ex_pdq from pdq_str
>
> execute ex_pdq
Or, in 7.30, you could do:
EXECUTE IMMEDIATE "SET PDQPRIORITY 50"
Or
SQL
SET PDQPRIORITY 50
END SQL
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN
#include <disclaimer.h>