How to move a record format to a data structure. Here is an example of how to move a file record format to a data structure.
Furthermore, the code will show how to define two (actually three) data structures based on the same file without the need to use Prefixes. This way you can have two sets of data that come from the same file.
SQLRPGLE Insert Statement for db2 in iSeries (AS400) An SQL INSERT statement adds one or more records to any single table in a relational database.
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 14 will create a bound program, and option 15 will create a *MODULE object.
RPG. SQL. Ile rpg programming: tips and techniques.