RPGLE free precompiler for SQL (generates CLI)
barrySQL will be referenced as BSQL.
**FREERPGLE support only.- Compiles from the IFS only
- Does not match regular ILE embedded SQL.
- Does not type chech against fields provided
- All BSQL statements begin with
EXEC SQLand do not have an end-of-line delimiter.
- DEFINE - required in all BSQL modules
HEADERSis used to define the prototypes and constants for the DB2 CLI.FIELDSis used to define the required fields for the DB2 CLI. (e.g. env, conn, hdl, stmts)
- CONNECT - connect to the local/remote database
EXEC SQL CONNECT *LOCALto connect to the local database.
- SELECT - Select records from a file
EXEC SQL SELECT ...to start a basic SELECT statement.- When using
SELECT, you must also useCLOSE.
- FETCH - Fetch records and out data into fields
INTO field field fieldto fetch the next record from the previous SELECT into a set of defined fields.
- CLOSE - Close a statement cursor
CLOSEis used to close the most recently openedSELECTstatement.
- UPDATE/DELETE/CREATE - Execute a UPDATE/DELETE/CREATE statement
EXEC SQL UPDATEEXEC SQL DELETEEXEC SQL CREATE- Used to execute statements. Does not require a
CLOSEas does not return results.
- DISCONNECT - Disconnect from database
EXEC SQL DISCONNECTis used to disconnect from the curren 5206 t connection.
- EXECUTE - Execute an SQL statement from a string
EXEC SQL EXECUTE fieldto use a character variable as an SQL string.- Always requires
CLOSE.