Re: Embedded SQL

Good question. I don't think that John's suggestion will work for you. The
nature of dynamic SQL says that your program will build SQL constructs at
execution time. So, to look at the *PGM won't get them. If I can think of a
way, I'll let you know, but, off the cuff, I think that you won't be able
to pick up file references that are opened dynamically by SQL.

Is this one of the prices we pay for the flexibility of Dynamic SQL??

Bob


Bob Slaney/Atlanta/IBM @ IBMUS (Lotus Notes)
VM id: WTSCPOK.RJSLANEY@VM
Internet id: rjslaney@us.ibm.com
Tieline 596-3022 Direct (770)835-3022
Fax tie 596-3912 Direct (770)835-3912

IBM Learning Services
AS/400 Course Materials Development
IBM Corp.
3100 Windy Hill Road
Atlanta, GA 30339
Internal Zip WE3A1

---------------------- Forwarded by Bob Slaney/Atlanta/IBM on 04/14/2000
01:20 PM ---------------------------

John P Carr <jpcarr@tredegar.com>@midrange.com on 04/14/2000 12:39:50 PM

Please respond to RPG400-L@midrange.com

Sent by:  owner-rpg400-l@midrange.com


To:   RPG400-L@midrange.com
cc:
Subject:  Re: Embedded SQL




     On the DSPPGMREF command the parameter OBJTYPE defaults to *PGM
     try using  *ALL  and see what you get.

     John Carr

     DSPPGMREF OBJTYPE values are;

     Single Values
       *ALL
     Other Values
       *PGM
       *SQLPKG
       *SRVPGM
       *MODULE



     From:     Lurton Keel <LKeel@UNARCORACK.com> on 04/14/2000 12:31 PM
     To:  RPG400-L@midrange.com@SMTP@Exchconnect
     cc:

     Subject:  Embedded SQL


     We have a home-grown Cross Reference system and we get most all of
the
     program references except for the files used in SQLRPG/LE programs.
The
     reason we don't is because the files are dynamic and are not listed
in the
     program reference.

     Does anyone know of a way to capture these pgm references short of
parsing
     the RPG source for the FROM clause?





+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---