A Rexx interface to SQL databases

Version 2.5

10 October 2006

SQLPREPARE(statement name,sql statement)

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.

Arguments:

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