4D v14.3

SQL SET OPTION

Home

 
4D v14.3
SQL
SQL SET OPTION

SQL SET OPTION 


 

SQL SET OPTION ( option ; value ) 
Parameter Type   Description
option  Longint in Number of option to set
value  Longint, String in New value of option

The SQL SET OPTION command modifies the value of the option passed in option.

option can have one of the following values, located in the “SQL” theme:

Constant Type Value Comment
SQL asynchronous Longint 1 0 = Synchronous connection (default value), 1 (or value other than 0) = Asynchronous connection
SQL charset Longint 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) or value -2 (see note 3)
By default: 106 (UTF-8)
SQL connection timeout Longint 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 max data length Longint 3 Maximum length of data returned
SQL max rows Longint 2 Maximum number of rows in resulting group (used for previews)
SQL query timeout Longint 4 Maximum timeout awaiting response when executing the SQL EXECUTE command.
Values: time in seconds
By default: no timeout

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.
  3. When you pass -2 as the value to SQL Charset, the encoding used by the 4D SQL server is automatically adapted to the running platform (non-UTF encoding):
    • Under Windows, ISO8859-1 is used,
    • Under Mac OS, MAC-ROMAN is used.

If the command was properly executed, the system variable OK returns 1. Otherwise, it returns 0.

 
PROPERTIES 

Product: 4D
Theme: SQL
Number: 818

The OK variable is changed by the command

 
HISTORY 

Modified: 4D v11 SQL Release 4

 
SEE ALSO 

SQL GET OPTION

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)