Database Interface Commands

As discussed earlier, database interfaces have direct connections to database servers (ODBC, Oracle etc.). Any commands not recognised as interface commands are passed through to the database as SQL, e.g. insert, update. If such commands are not understood by the database parser as SQL, an SQL database parsing error is typically recorded.

Interfaces which are not database interfaces have no database connection, so neither SQL nor the commands listed below will be understood, with the exception of the select command which is always implemented as a standard interface command.

fetch

fetch {into} <client_variable> ...

Fetch a row of data. This typically follows a select command, reads a row of data returning it to the client (Fire) to be stored in client variables.

multifetch

multifetch {<n>} {into} <client_array> ...

Fetch multiple rows of data. This typically follows a select command, reads all rows (or a specific number of rows <n>) of data returning them to the client (Fire) to be stored in client arrays.

plsql

plsql <command> ...

Execute a PL/SQL command. The contents of <command> are passed straight through to the database. This command applies to Oracle database interfaces.