SQLRPGLE

From MidrangeWiki
Revision as of 10:44, 29 June 2005 by TomHolden (talk | contribs)
Jump to: navigation, search

RPG IV with Embedded SQL

Introduction to RPG IV with Embedded SQL

SQL is a powerful tool in any programmer's skill set. It is possible to leverage this tool from within RPG (& other languages). The source member type for these programs is SQLRPGLE. Here is an example of an embedded SQL statement:

     C/EXEC SQL
     C+ SELECT * FROM mylib/myfile
     C/END-EXEC
SQL Directives
Directive Function performed
SELECT The Select directive is used to extract data from a Physical file or Table