A language command defines a batch of one or more SQL statements and sends it to the server to be compiled and executed.
The following table compares the DB-Library routines used for sending language commands with their Client-Library equivalents:
DB-Library routines |
DB-Library functionality |
Client-Library routines |
Client-Library functionality |
|---|---|---|---|
(none) |
(none) |
ct_cmd_alloc( connection, cmd_pointer) |
Allocate a CS_COMMAND structure. |
dbfcmd( dbproc, string, args...) |
Format text and add to the DBPROCESS command buffer. There is a 1k buffer limit for DB-Library. |
sprintf( cmd_string, control_string, args...) |
Format text and initialize the language command string using sprintf, strcpy, or other system calls. |
dbcmd( dbproc, string) |
Add text to the DBPROCESS command buffer. |
ct_command( cmd, CS_LANG_CMD, cmd_string, string_len, CS_MORE) |
Initiate a language command using cmd_string, with more command text to follow. |
(none) |
ct_command( cmd, CS_LANG_CMD, cmd_string, string_len, CS_END) |
Add cmd_string as the final piece of command text for this command. |
|
dbsqlexec( dbproc) |
Send a command batch to the server for execution. |
ct_send( cmd) |
Send a command batch to the server for execution. |
