• Subject: Re: SQL pgm (QSQROUTE)
  • From: Vern Hamberg <hambergv@xxxxxxxxxxxxxx>
  • Date: Sun, 19 Oct 1997 21:54:36 -0500

Mark,

At 10:48 PM 10/18/97, you wrote:
>Vern,
>
>>At 08:41 PM 10/14/97, you wrote:
>>> Does anyone know what the QSQROUTE pgm does?  I saw a call to it in an OPM
>>>RPG pgm right after some embedded SQL.
>>
>>The SQL Programming (V3R6) manual, in Appendix E. Analyzing Job Trace
>>Information, talks about the modules that may show up in a trace report. On
>>page E-6, QSQROUTE is described as "The first called SQL routine—for
>>embedded SQL. When browsing a trace report on the screen, use the search
>>facility to locate this module first."
>>
>>It appears the QSQXCUTE is the equivalent for interactive SQL.
>
> My question is: Why would someone do an explicit call to any of these
>modules when they get executed by the system automatically?

I believe these explicit calls are added to the RPG source by the SQL
precompiler.
>From what I've seen and read, the /exec-sql, etc., embedded lines get
converted to comments by the precompiler. Then, where needed, QSQROUTE is
inserted by the same precompiler, with appropriate parameters. The
precompiler also adds the SQLCA data area.

Is this what you have, or is someone actually using this call?

Cheers

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].