Re: Embedded SQL

[John P Carr <jpcarr@xxxxxxxxxxxx>]

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