RPG/400 Help
The AS/400 system allows you to insert SQL/400 statements into RPG/400
programs. You enter SQL/400 statements on a calculation
specification. The syntax is shown in Figure "Syntax for
Entering SQL/400 Statements into an RPG/400 Program". You must
observe the following rules:
- The starting delimiter /EXEC SQL must be entered into columns 7-15, with
the slash in column 7.
- SQL/400 statements can be started on the same line as the starting
delimiter.
- SQL/400 statements can be continued on any number of subsequent
continuation lines. The continuation line delimiter is the + in
column 7.
- SQL/400 statements cannot go past column 74.
- The ending delimiter /END-EXEC must be entered in columns 7-15, with the
slash in column 7, on a separate line. This signals the end of the
SQL/400 statements. It must be entered by itself, with no SQL/400
statements following it.
You must enter a separate command to process the SQL/400 statements.
Refer to the SQL/400* Programmer's Guide and the
SQL/400* Reference for the descriptions of how to code SQL/400
statements.
For information on restrictions governing SQL statements in RPG/400
programs, see Restrictions.
[ Top of Page | Previous Page | Next Page | Table of Contents ]
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.