In the client/server model, a server accepts commands from multiple clients and responds by returning data and other information to the clients. Open Client applications use Client-Library routines to communicate commands to servers.
Table 2-18 summarizes the Client-Library command types:
Command type |
Initiated by |
Summary |
---|---|---|
Language |
ct_command |
Defines the text of a query that the server will parse, interpret, and execute. |
RPC, Package |
ct_command |
Specifies the name of a server procedure (Adaptive Server stored procedure or Open Server registered procedure) to be executed by the server. The procedure must already exist on the server. Package commands are only supported by mainframe Open Server servers. They are otherwise identical to RPC commands. |
Cursor |
ct_cursor |
Initiates one of several commands to manage a Client-Library cursor. |
Dynamic SQL |
ct_dynamic |
Initiates a command to execute a literal SQL statement (with restrictions on statement content) or to manage a prepared dynamic SQL statement. |
Message |
ct_command |
Initiates a message command and specifies the message-command ID number. |
Send-Data |
ct_command |
Initiates a command to upload a large text/image column value to the server. |