RE: AW: SQL versus READ for sequential processing

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Whoah up there.

Birgitta says that if I use LFs I'm condamned to useing CQE, and your saying that even if I change to DDL there may be no difference?

How exactly do I use the database monitor in iNav?

-----Message d'origine-----
De : rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Vern Hamberg
Envoyé : samedi 11 octobre 2008 17:50
À : RPG programming on the AS400 / iSeries
Objet : Re: AW: SQL versus READ for sequential processing

You should run a database monitor to verify which engine ran you query.
You can do this from Navigator quite easily, from the SQL statement processor. There will be information there about all manner of things, including which engine. Read the help text to learn what you are looking at and where to find the information.

Just because a table was created with DDL, there is no guarantee that SQE will be used to run the query - the way a table is created is NOT one of the criteria for which engine is used.

Regards
Vern

Åke Olsson wrote:
> Not that in my example the table used for the SQL test was created with SQL Create Table. It should have used the SQE.
>
> It ran slowly anyway.
>
>
> Med vänlig hälsning / Best regards
> Åke Olsson
>
> Pdb DataSystem AB
> Box 433   SE 551 16  Jönköping   Sweden   visit: Brunnsgatan 11
> phone: +46 (0)36 342976   mobile: +46 (0)705 482976 fax: +46 (0)36 34 29 29
> ake.olsson@xxxxxx    www.pdb.se
>
> This e-mail and any attachments may contain confidential and
> privileged information. If you are not the intended recipient, please
> notify the sender immediately by return e-mail, delete this e-mail and
> destroy any copies. Any dissemination or use of this information by a
> person other than the intended recipient is unauthorized and may be
> illegal.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.