RE: AW: SQL versus READ for sequential processing -- RPG400-L

Got it, thanks.

But the quickest way is to just execute Visual Explain. Then click on the chequered flag. The information on the engine is the last message in the panel on the right. In my case :

QUERY ENGINE USED CQE
REASON SQE WAS NOT USED DERIVED KEY OR SELECT/OMIT

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

Hi David

You need the Database component installed in Navigator first of all.
Once you open it up, click on the database name - often the serial number.

If you just click on the Databases section under you Connection, there should be a "Help for related tasks" link in the lower right panel - open it and look for the one for "Graphically view database queries" - it will take you to a section on working with SQL performance monitors, which is what you want to use.

HTH
Vern

David FOXWELL wrote:

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.

--
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.