Help about PDQ
A user asked where to put SET PDQPRIORITY in an Informix-4GL application and reported a syntax error at compile time. Answers: issue the statement anywhere after connecting (non-zero to enable, 0 to disable). Since the 4GL compiler's parser rejects it directly, wrap it in SQL ... END SQL (e.g. SQL SET PDQPRIORITY 10; END SQL), which works in 4GL 7.20 as the user had. Alternatively, for older 4GL, build the statement in a CHAR variable and PREPARE/EXECUTE it, which works in any version.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Where I put the command set PDQ priority in the application 4gl Thanks Wanderlei
Anywhere after connecting to the database You can turn on PDQ setting a value higher than 0 and turn it off setting a value to 0 or low. Best regards, Celso Cabral Coimbra Administrador de Banco de Dados ClearTech Ltda "Trust at the heart of Communications" Tel. (11) 3576-4509 -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de WANDERLEI BARBOZA Enviada em: segunda-feira, 21 de maio de 2012 09:17 Para: ids@iiug.org Assunto: Help about PDQ [27177] Where I put the command set PDQ priority in the application 4gl Thanks Wanderlei ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Anywhere after connecting to the database add the SET PDQPRIORITY <N> command. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, May 21, 2012 at 8:17 AM, WANDERLEI BARBOZA < wanderlei.barboza@interaconsultoria.com.br> wrote: > Where I put the command set PDQ priority in the application 4gl > > Thanks > Wanderlei > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340a998be65504c08d2bf2
Wanderlei, if you mean compiling errors, just put the statement between SQL...
.END SQL, like this:
SQL
SET PDQPRIORITY 10;END SQL
That should allow any sql between the two clauses, I mean, compiler will not
raise any error on this.
Hope it helps.
Best Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Database Administrator
(cel) +55 11 7603-0358
> To: ids@iiug.org
> From: ccoimbra@cleartech.com.br
> Subject: RES: Help about PDQ [27178]
> Date: Mon, 21 May 2012 08:22:31 -0400
>
> Anywhere after connecting to the database
>
> You can turn on PDQ setting a value higher than 0 and turn it off setting a
> value to 0 or low.
>
> Best regards,
>
> Celso Cabral Coimbra
> Administrador de Banco de Dados
> ClearTech Ltda
> "Trust at the heart of Communications"
> Tel. (11) 3576-4509
>
> -----Mensagem original-----
> De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de WANDERLEI
> BARBOZA
> Enviada em: segunda-feira, 21 de maio de 2012 09:17
> Para: ids@iiug.org
> Assunto: Help about PDQ [27177]
>
> Where I put the command set PDQ priority in the application 4gl
>
> Thanks
> Wanderlei
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Bom dia Alexandre,
A mensagem que esta aparecendo quando tentamos compilar o programa é "sintax
error" e não compila
Obs: a versão que utilizamos é 10.00 FC11x6
Grato
Wanderlei
-----Mensagem Original-----
From: "Alexandre Marini" alexandre@briug.org
Date: Tue, 22 May 2012 08:37:17 -0300
To: ids@iiug.org
Subject: RE: RES: Help about PDQ [27190]
> Wanderlei, if you mean compiling errors, just put the statement between
SQL...
> .END SQL, like this:
>
> SQL
> SET PDQPRIORITY 10;> END SQL
>
> That should allow any sql between the two clauses, I mean, compiler will not
> raise any error on this.
>
> Hope it helps.
> Best Regards.
>
> Alexandre Marini
> IBM Informix Certified Professional v10 / v11.50 / v11.70
>
> IBM Information Management Informix Technical Professional
>
> IBM Infosphere DataStage Technical Professional
> Database Administrator
> (cel) +55 11 7603-0358
>
> > To: ids@iiug.org
> > From: ccoimbra@cleartech.com.br
> > Subject: RES: Help about PDQ [27178]
> > Date: Mon, 21 May 2012 08:22:31 -0400
> >
> > Anywhere after connecting to the database
> >
> > You can turn on PDQ setting a value higher than 0 and turn it off setting a
> > value to 0 or low.
> >
> > Best regards,
> >
> > Celso Cabral Coimbra
> > Administrador de Banco de Dados
> > ClearTech Ltda
> > "Trust at the heart of Communications"
> > Tel. (11) 3576-4509
> >
> > -----Mensagem original-----
> > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de WANDERLEI
> > BARBOZA
> > Enviada em: segunda-feira, 21 de maio de 2012 09:17
> > Para: ids@iiug.org
> > Assunto: Help about PDQ [27177]
> >
> > Where I put the command set PDQ priority in the application 4gl
> >
> > Thanks
> > Wanderlei
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Wanderlai:
The important version is your version of 4GL not of the engine. Run "c4gl
-V" to see the version.
Anyway, if you are still running a (very) old version of 4GL that does not
support the SQL...END SQL syntax, you can prepare and execute the SET
PDQPRIORITY statement. That will work with any version of 4GL.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, May 22, 2012 at 8:02 AM, wanderlei.barboza <
wanderlei.barboza@interaconsultoria.com.br> wrote:
> Bom dia Alexandre,
> A mensagem que esta aparecendo quando tentamos compilar o programa é
> "sintax
> error" e não compila
> Obs: a versão que utilizamos é 10.00 FC11x6
>
> Grato
> Wanderlei
> -----Mensagem Original-----
> From: "Alexandre Marini" alexandre@briug.org
> Date: Tue, 22 May 2012 08:37:17 -0300
> To: ids@iiug.org
> Subject: RE: RES: Help about PDQ [27190]
>
> > Wanderlei, if you mean compiling errors, just put the statement between
> SQL...
> > .END SQL, like this:
> >
> > SQL
> > SET PDQPRIORITY 10;> > END SQL
> >
> > That should allow any sql between the two clauses, I mean, compiler will
> not
> > raise any error on this.
> >
> > Hope it helps.
> > Best Regards.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Infosphere DataStage Technical Professional
> > Database Administrator
> > (cel) +55 11 7603-0358
> >
> > > To: ids@iiug.org
> > > From: ccoimbra@cleartech.com.br
> > > Subject: RES: Help about PDQ [27178]
> > > Date: Mon, 21 May 2012 08:22:31 -0400
> > >
> > > Anywhere after connecting to the database
> > >
> > > You can turn on PDQ setting a value higher than 0 and turn it off
> setting
> a
> > > value to 0 or low.
> > >
> > > Best regards,
> > >
> > > Celso Cabral Coimbra
> > > Administrador de Banco de Dados
> > > ClearTech Ltda
> > > "Trust at the heart of Communications"
> > > Tel. (11) 3576-4509
> > >
> > > -----Mensagem original-----
> > > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de
> WANDERLEI
> > > BARBOZA
> > > Enviada em: segunda-feira, 21 de maio de 2012 09:17
> > > Para: ids@iiug.org
> > > Assunto: Help about PDQ [27177]
> > >
> > > Where I put the command set PDQ priority in the application 4gl
> > >
> > > Thanks
> > > Wanderlei
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae934099f9c82d004c09f3971
Wanderlei, como eu lhe disse, basta colocar a cláusula SET PDQPRIORITY entre
os comandos SQL.... END SQL,
qualquer código dentro desta seção será ignorado pelo parser do compilador, e
não gera erro 201.
Aliás, estas cláusulas podem ser utilizadas para qualquer comando sql, ou seja,
sempre que você encontrar erro 201 ao tentar executar cláusulas sql em
programas 4gl, basta utilizar este recurso.
Att.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Database Administrator
> To: ids@iiug.org
> From: wanderlei.barboza@interaconsultoria.com.br
> Subject: RE: RES: Help about PDQ [27191]
> Date: Tue, 22 May 2012 08:02:48 -0400
>
> Bom dia Alexandre,
> A mensagem que esta aparecendo quando tentamos compilar o programa é "sintax
> error" e não compila
> Obs: a versão que utilizamos é 10.00 FC11x6
>
> Grato
> Wanderlei
> -----Mensagem Original-----
> From: "Alexandre Marini" alexandre@briug.org
> Date: Tue, 22 May 2012 08:37:17 -0300
> To: ids@iiug.org
> Subject: RE: RES: Help about PDQ [27190]
>
> > Wanderlei, if you mean compiling errors, just put the statement between
> SQL...
> > .END SQL, like this:
> >
> > SQL
> > SET PDQPRIORITY 10;> > END SQL
> >
> > That should allow any sql between the two clauses, I mean, compiler will
not
> > raise any error on this.
> >
> > Hope it helps.
> > Best Regards.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Infosphere DataStage Technical Professional
> > Database Administrator
> > (cel) +55 11 7603-0358
> >
> > > To: ids@iiug.org
> > > From: ccoimbra@cleartech.com.br
> > > Subject: RES: Help about PDQ [27178]
> > > Date: Mon, 21 May 2012 08:22:31 -0400
> > >
> > > Anywhere after connecting to the database
> > >
> > > You can turn on PDQ setting a value higher than 0 and turn it off setting
> a
> > > value to 0 or low.
> > >
> > > Best regards,
> > >
> > > Celso Cabral Coimbra
> > > Administrador de Banco de Dados
> > > ClearTech Ltda
> > > "Trust at the heart of Communications"
> > > Tel. (11) 3576-4509
> > >
> > > -----Mensagem original-----
> > > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de
> WANDERLEI
> > > BARBOZA
> > > Enviada em: segunda-feira, 21 de maio de 2012 09:17
> > > Para: ids@iiug.org
> > > Assunto: Help about PDQ [27177]
> > >
> > > Where I put the command set PDQ priority in the application 4gl
> > >
> > > Thanks
> > > Wanderlei
> > >
> > >
> > >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> > >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hi Art Kagel
INFORMIX-4GL Version 7.20.UE1
Thanks
Wanderlei
-----Mensagem Original-----
From: "Art Kagel" art.kagel@gmail.com
Date: Tue, 22 May 2012 09:33:31 -0300
To: ids@iiug.org
Subject: Re: RES: Help about PDQ [27192]
> Wanderlai:
>
> The important version is your version of 4GL not of the engine. Run "c4gl
> -V" to see the version.
>
> Anyway, if you are still running a (very) old version of 4GL that does not
> support the SQL...END SQL syntax, you can prepare and execute the SET
> PDQPRIORITY statement. That will work with any version of 4GL.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other organization with which I am associated either explicitly,
> implicitly, or by inference. Neither do those opinions reflect those of
> other individuals affiliated with any entity with which I am affiliated nor
> those of the entities themselves.
>
> On Tue, May 22, 2012 at 8:02 AM, wanderlei.barboza <
> wanderlei.barboza@interaconsultoria.com.br> wrote:
>
> > Bom dia Alexandre,
> > A mensagem que esta aparecendo quando tentamos compilar o programa é
> > "sintax
> > error" e não compila
> > Obs: a versão que utilizamos é 10.00 FC11x6
> >
> > Grato
> > Wanderlei
> > -----Mensagem Original-----
> > From: "Alexandre Marini" alexandre@briug.org
> > Date: Tue, 22 May 2012 08:37:17 -0300
> > To: ids@iiug.org
> > Subject: RE: RES: Help about PDQ [27190]
> >
> > > Wanderlei, if you mean compiling errors, just put the statement between
> > SQL...
> > > .END SQL, like this:
> > >
> > > SQL
> > > SET PDQPRIORITY 10;> > > END SQL
> > >
> > > That should allow any sql between the two clauses, I mean, compiler will
> > not
> > > raise any error on this.
> > >
> > > Hope it helps.
> > > Best Regards.
> > >
> > > Alexandre Marini
> > > IBM Informix Certified Professional v10 / v11.50 / v11.70
> > >
> > > IBM Information Management Informix Technical Professional
> > >
> > > IBM Infosphere DataStage Technical Professional
> > > Database Administrator
> > > (cel) +55 11 7603-0358
> > >
> > > > To: ids@iiug.org
> > > > From: ccoimbra@cleartech.com.br
> > > > Subject: RES: Help about PDQ [27178]
> > > > Date: Mon, 21 May 2012 08:22:31 -0400
> > > >
> > > > Anywhere after connecting to the database
> > > >
> > > > You can turn on PDQ setting a value higher than 0 and turn it off
> > setting
> > a
> > > > value to 0 or low.
> > > >
> > > > Best regards,
> > > >
> > > > Celso Cabral Coimbra
> > > > Administrador de Banco de Dados
> > > > ClearTech Ltda
> > > > "Trust at the heart of Communications"
> > > > Tel. (11) 3576-4509
> > > >
> > > > -----Mensagem original-----
> > > > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de
> > WANDERLEI
> > > > BARBOZA
> > > > Enviada em: segunda-feira, 21 de maio de 2012 09:17
> > > > Para: ids@iiug.org
> > > > Assunto: Help about PDQ [27177]
> > > >
> > > > Where I put the command set PDQ priority in the application 4gl
> > > >
> > > > Thanks
> > > > Wanderlei
> > > >
> > > >
> > > >
> > >
> >
> >
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > > >
> > >
> >
> >
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --14dae934099f9c82d004c09f3971
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
If memory serves, 4GL v7.20 should support the SQL .... END SQL syntax.
So, either:
SQL
SET PDQPRIORITY 50
END SQL
-or-
DEFINE stmt CHAR(100)
....
LET stmt = "SET PDQPRIORITY 50"
PREPARE p_stmt FROM stmt
EXECUTE p_stmt;
...
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, May 22, 2012 at 8:57 AM, wanderlei.barboza <
wanderlei.barboza@interaconsultoria.com.br> wrote:
> Hi Art Kagel
> INFORMIX-4GL Version 7.20.UE1
>
> Thanks
> Wanderlei
> -----Mensagem Original-----
> From: "Art Kagel" art.kagel@gmail.com
> Date: Tue, 22 May 2012 09:33:31 -0300
> To: ids@iiug.org
> Subject: Re: RES: Help about PDQ [27192]
>
> > Wanderlai:
> >
> > The important version is your version of 4GL not of the engine. Run "c4gl
> > -V" to see the version.
> >
> > Anyway, if you are still running a (very) old version of 4GL that does
> not
> > support the SQL...END SQL syntax, you can prepare and execute the SET
> > PDQPRIORITY statement. That will work with any version of 4GL.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> > other organization with which I am associated either explicitly,
> > implicitly, or by inference. Neither do those opinions reflect those of
> > other individuals affiliated with any entity with which I am affiliated
> nor
> > those of the entities themselves.
> >
> > On Tue, May 22, 2012 at 8:02 AM, wanderlei.barboza <
> > wanderlei.barboza@interaconsultoria.com.br> wrote:
> >
> > > Bom dia Alexandre,
> > > A mensagem que esta aparecendo quando tentamos compilar o programa é
> > > "sintax
> > > error" e não compila
> > > Obs: a versão que utilizamos é 10.00 FC11x6
> > >
> > > Grato
> > > Wanderlei
> > > -----Mensagem Original-----
> > > From: "Alexandre Marini" alexandre@briug.org
> > > Date: Tue, 22 May 2012 08:37:17 -0300
> > > To: ids@iiug.org
> > > Subject: RE: RES: Help about PDQ [27190]
> > >
> > > > Wanderlei, if you mean compiling errors, just put the statement
> between
> > > SQL...
> > > > .END SQL, like this:
> > > >
> > > > SQL
> > > > SET PDQPRIORITY 10;> > > > END SQL
> > > >
> > > > That should allow any sql between the two clauses, I mean, compiler
> will
> > > not
> > > > raise any error on this.
> > > >
> > > > Hope it helps.
> > > > Best Regards.
> > > >
> > > > Alexandre Marini
> > > > IBM Informix Certified Professional v10 / v11.50 / v11.70
> > > >
> > > > IBM Information Management Informix Technical Professional
> > > >
> > > > IBM Infosphere DataStage Technical Professional
> > > > Database Administrator
> > > > (cel) +55 11 7603-0358
> > > >
> > > > > To: ids@iiug.org
> > > > > From: ccoimbra@cleartech.com.br
> > > > > Subject: RES: Help about PDQ [27178]
> > > > > Date: Mon, 21 May 2012 08:22:31 -0400
> > > > >
> > > > > Anywhere after connecting to the database
> > > > >
> > > > > You can turn on PDQ setting a value higher than 0 and turn it off
> > > setting
> > > a
> > > > > value to 0 or low.
> > > > >
> > > > > Best regards,
> > > > >
> > > > > Celso Cabral Coimbra
> > > > > Administrador de Banco de Dados
> > > > > ClearTech Ltda
> > > > > "Trust at the heart of Communications"
> > > > > Tel. (11) 3576-4509
> > > > >
> > > > > -----Mensagem original-----
> > > > > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de
> > > WANDERLEI
> > > > > BARBOZA
> > > > > Enviada em: segunda-feira, 21 de maio de 2012 09:17
> > > > > Para: ids@iiug.org
> > > > > Assunto: Help about PDQ [27177]
> > > > >
> > > > > Where I put the command set PDQ priority in the application 4gl
> > > > >
> > > > > Thanks
> > > > > Wanderlei
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --14dae934099f9c82d004c09f3971
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f83a129164c1004c09fa1dc