Re: Does a program contain embedded SQL?

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

There's a command PRTSQLINF, that creates a spool file giving you
information about SQL contained in a program.

But a quick search didn't turn up an API.

Charles

On Fri, Oct 31, 2008 at 2:51 PM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx> wrote:
> Obviously I'm no expert, but I looked at one of mine.  Neither the object attribute, which is RPGLE, nor DSPPGM nor DSPOBJD revealed anything that even hinted at SQL.  But those were the only commands I tried, and didn't look at any API's.
>
> Jerry C. Adams
> IBM System i Programmer/Analyst
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Beck
> Sent: Friday, October 31, 2008 1:37 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Does a program contain embedded SQL?
>
> Does anyone know how to tell by only looking at the object if a program contains embedded SQL?
>
> I looked through the API's but didn't see much, I hope I am just missing the obvious.
>
> Chris
>
>
> This email transmission and any documents, files or previous
> email messages attached to it may contain information that is
> confidential or legally privileged. If you are not the intended
> recipient, you are hereby notified that any disclosure, copying,
> printing, distributing or use of this transmission is strictly
> prohibited. If you have received this transmission in error,
> please immediately notify the sender by telephone or return
> email and delete the original transmission and its attachments
> without reading or saving in any manner.
>
> The Evangelical Lutheran Good Samaritan Society.
>
> --
> 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.