|
|
|
|
|
|
|
|
|
|
|
version 11.3 (Modified)
SQL SET OPTION (option; value)
| Parameter | Type | Description | |
| option | Longint |  | Number of option to set |
| value | Longint | | New value of option |
Description
The SQL SET OPTION command is used to modify the value of the option passed in option.
option can have one of the following values, located in the "SQL" theme:
| Constant | Description and possible values |
| SQL Asynchronous (1) | 0 = Synchronous connection (default value), |
| 1 (or value other than 0) = Asynchronous connection | |
| SQL Max Rows (2) | Maximum number of rows in resulting group |
| (used for previews) | |
| SQL Max Data Length (3) | Maximum length of data returned |
| SQL Query Time Out (4) | Maximum timeout awaiting response when executing |
| the SQL EXECUTE command. | |
| Values: time in seconds | |
| By default: no timeout | |
| SQL Connection Time Out (5) | Maximum timeout awaiting response when executing |
| the SQL LOGIN command. | |
| This value must be set before opening the connection | |
| in order to be taken into account | |
| Possible values: time in seconds | |
| By default: no timeout | |
| SQL Charsets (100) | Text encoding used for requests sent to external sources |
| (via the SQL pass-through). | |
| The modification is carried out for the current process and | |
| the current connection. | |
| Possible values: MIBEnum identifier (see note 2) | |
| By default: 106 (UTF-8) |
Notes:
1. When you work with the internal SQL kernel of 4D, the SQL Asynchronous option serves no purpose due to the fact that this type of connection is always synchronous.
2. MIBEnum numbers are referenced at the following address: http://www.iana.org/assignments/character-sets.
See Also
System Variables or Sets
If the command was properly executed, the system variable OK returns 1. Otherwise, it returns 0.
|
|
|
|
|
|
|
|
|
|
|