The API is the mechanism used to pass SQL statements to servers. The contents of an SQL statement are transparent to the API; no parsing or SQL translation takes place within it. Necessary SQL translation such as that required when accessing a non-SQL based DBMS is processed at the server. See your SQL manual and iWay Server Administration manual for your specific platform for more information.
The API supports dynamic SQL. It requires only that an SQL source statement is available, in the form of a character string, when the statement is to be prepared or executed. The API checks to see that the string is properly delimited and passes it, unexamined, to the server. The server parses the statement, executes it if necessary, and passes the result to the client program. The API acts primarily as a conduit, passing command strings in one direction and fielding output data in the other direction. Static SQL is not supported.
| iWay Software |