SQLRPGLE Select Statement for db. Series AS4. 00. In order to create an RPGLE source member that can use embedded SQL, you must use a source type of SQLRPGLE. To compile an SQLRPGLE source member, use the Create SQL ILE RPG Object CRTSQLRPGI command. If you are using PDM, option 1. MODULE object. If you are issuing the command manually, use the OBJTYPE parameter to indicate PGM or ODULE. Sample SQLRPGLE program to Read data from db. Select and Fetch SQL Statementsd Data. DS ds. d cmp 2s 0. Id 5s 0. Name 3. Date 8s 0. Salary 1. Set SQL options. Hp 50G Civil Engineering Programs. SET OPTION. commitone. Read one Record from the SQL table using unique keys. Select d. 1cmp,d. Data. DS. from qgplmydata where d. Id. dsply emp. Name. Date. dsply emp. Salary. Read more than one record from the SQL table. Declare the cursor. Declare C1 cursor for. Select d. 1cmp,d. We are working toward converting our system from a S36 to an AS400 S36E. On the way we are attempting to create DDS specifications for our files and. I am working with a Windows based server and an AS400 datasource. I am wanting to create a databse stored procedure on the 400 with which I can A Pass in. Nfpa 72 2013 Handbook. Sample As400 Programs' title='Sample As400 Programs' />Open the cursor. Open C1. Fetch data in a loop. Dou sqlcod lt 0. Fetch C1 INTO Data. DS. If sqlcod lt 0. Leave. Endif. dsply cmp. Id. dsply emp. Name. Date. dsply emp. Salary. Enddo. Close the cursor. Close C1. nlr n. Search the worlds information, including webpages, images, videos and more. Google has many special features to help you find exactly what youre looking for. Host Variables. Host variables are always preceded in SQL by a colon. Since your RPGLE program is the host of these SQL statements, the term host variable refers to any variable declared in the RPGLE program. We can use these variables when we execute SQL as parameters or as return values.