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.