A Rexx interface to SQL databases

Version 2.5

10 October 2006

SQLPREPARE(statement name,sql statement)

Allocates a work area to a SQL statement and prepares the statement for processing.

If the statement is a DDL or DML statement then it must be executed by a subsequent call. For DDL, INSERT, UPDATE and DELETE commands, the statement must be executed by calling SQLEXECUTE. For a SELECT command, the statement must be executed as a cursor. This requires calling SQLOPEN followed by multiple calls to SQLFETCH and optionally calling SQLCLOSE.


statement name
A name to identify the sql statement.

sql statement
Any valid DDL or DML statement. For DML statements, the statement may contain placemarkers to which values may be bound.
The format of these placemarkers is implementation dependant.

success: zero
failure: a negative number

Copyright © Mark Hessling 1997-2006 <>

Return to Table of Contents
Last updated 10 October 2006