Understanding SQL commands

Each connection object might include one or more command objects responsible for the execution of individual SQL commands. Each command object embodies a SQL statement and is associated with the code required to process that statement for a particular database protocol and server combination, such as SQL*Net to Oracle 7.

SQL command instances can be parameterized for executing a series of commands that differ only in the value of selected constants. Parameters are responsible for binding values to placeholders in command objects and for converting those values to appropriate SQL constants. Commands might also take or produce a record source for transferring data from a datastore to client applications. For more information about record sources, see Chapter 4.


[Contents] [Previous] [Next]
Click the icon to mail questions or corrections about this material to Taligent personnel.
Copyright©1995 Taligent,Inc. All rights reserved.

Generated with WebMaker