Re: SQL pgm (QSQROUTE)

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