AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Administrar bases de datos / HFSQL / Gestión de HFSQL Client/Server
  • Overview
  • List of keywords
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
Overview
When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information.
In the data model editor, this information is typed in the connection description, "Advanced" tab.
Through programming, this extended information is configured:
This information is defined via the following keywords.
Attention: This help page only presents optional connection information available for Native Connectors (also called Native Access) and OLE DB.
List of keywords
KeywordDescription
ANSI_NULLSSpecifies the behavior, compatible with ISO, of the Equal to (=) and Different from (< >) operators when they are used with Null values.
The possible values are as follows:
  • 0: Forces parameter to FALSE on server.
  • 1: Force the parameter to TRUE on the server.
  • Not specified: Uses current server configuration.
Conectores Nativos This keyword is supported by the Native SQL Server Connectors (via OLE DB and ODBC).
ANSI_PADDINGChecks the mode for storing in the column the values whose length is less than the size defined for the column and the values containing space characters on the right for the char, varchar, binary and varbinary data.
The possible values are as follows:
  • 0: Forces parameter to OFF.
  • 1: Forces parameter to ON.
  • Not specified: Uses current server configuration.
Conectores Nativos This keyword is supported by the Native SQL Server Connectors (via OLE DB and ODBC).
ANSI_WARNINGSSpecifies whether the behavior in accordance with the ISO standard must be respected for several error conditions.
The possible values are as follows:
  • 0: Forces parameter to OFF.
  • 1: Forces parameter to ON.
  • Not specified: Uses current server configuration.
Conectores Nativos This keyword is supported by the Native SQL Server Connectors (via OLE DB and ODBC).
ARITHABORTStops a query when a capacity overflow or a division by zero occurs during its execution.
The possible values are as follows:
  • 0: Forces parameter to OFF.
  • 1: Forces parameter to ON.
  • Not specified: Uses current server configuration.
Conectores Nativos This keyword is supported by the Native Sybase and SQL Server Connectors (via OLE DB and ODBC).
CHARSETDefines the charset during the call to dbsetlname.
Conectores Nativos This keyword is supported by the Native Sybase Connector only.
Client FlagFor more details, see the documentation about MySQL (keyword = 'mysql_real_connect').
Conectores Nativos This keyword is supported by the Native MySQL Connector.
CONCAT_NULL_YIELDS_NULLDefines whether the concatenation results are considered as being null values or empty strings.
The possible values are as follows:
  • 0: Forces parameter to OFF.
  • 1: Forces parameter to ON.
  • Not specified: Uses current server configuration.
Conectores Nativos This keyword is supported by the Native SQL Server Connectors (via OLE DB and ODBC).
CrypteEncrypted connection.
If this keyword is set to "YES", the communication between the database client and the server will be encrypted.
Example:
"Encrypt=YES"
Conectores Nativos This keyword is supported by the Native SQL Server Connectors (via OLE DB and ODBC).
DTSUsed to specify whether the distributed transactions must be used or not.
  • If "DTS = 0", the management of distributed transactions is disabled.
  • If "DTS = 1" (default value), the management of distributed transactions is enabled.
Conectores Nativos This keyword is supported by the Native Oracle Connector only.
File nameName of the UDL file used to establish a connection via OLE DB.
To create a UDL file:
  1. Create a text file whose extension is "UDL".
  2. Double-click this file. The window for the properties of the data links is opened.
  3. Configure the connection.
  4. Run the test of the connection.
  5. Confirm ("OK" button). The UDL file can now be used.
Note: This method is not recommended. Indeed, the OLE DB access uses the connection information to avoid the limitations set by some providers.
OLE DB This keyword is supported by OLE DB.
Initial CatalogName of database that will be used on the data source.
MODELOCKAllows you to specify the type of lock used in the SQLxxx functions.
Conectores Nativos SQL Server, Sybase:
  • SQLLock(Table) uses TABLOCKX by default.
    Example: MODELOCK = TABLOCKX
    SELECT * FROM MaTable WITH (TABLOCKX)
  • SQLLock(qry) uses UPDLOCK by default. Example:
    SELECT * FROM MaTable WITH (UPDLOCK) WHERE MaRub>2 ORDER BY MaRub
Conectores Nativos Oracle:
  • SQLLock(Table) uses the "EXCLUSIVE" mode by default. Example: MODELOCK = EXCLUSIVE
    LOCK TABLE MaTable IN EXCLUSIVE MODE NOWAIT
  • SQLLock(qry) adds "FOR UPDATE" to the query (cannot be configured).
NLS_DATE_FORMATIf this keyword is specified, the Native Connector runs the following query when opening the connection:
ALTER SESSION SET NLS_DATE_FORMAT = format
This format does not concern the consultation of Oracle columns by WLanguage but the date conversions performed by the Oracle engine itself. For example, when running a query containing TO_CHAR of a date.
Conectores Nativos This keyword is supported by the Native Oracle Connector only.
NUMERIC_ROUNDABORTSpecifies the level of gravity for the error when a rounding operation performed in an expression triggers a loss of precision.
The possible values are as follows:
  • 0: Forces parameter to OFF.
  • 1: Forces parameter to ON.
  • Not specified: Uses current server configuration.
Conectores Nativos This keyword is supported by the Native SQL Server Connectors (via OLE DB and ODBC).
OLDDATEFORMATModifies the return format of the date values in the SQLxxx functions in order to be compatible with the format of the Native Connectors of WINDEV 5.5.
The possible values are as follows:
  • 0: (default value) Date format managed by HFSQL.
  • 1: Date format compatible with WINDEV 5.5 Native Connectors.
This keyword is supported by:
  • Conectores Nativos SQL Server (YYYY-MM-DD HH:MM:SS.CCC)
  • Conectores Nativos Sybase (YYYY-MM-DD HH:MM:SS.CCC)
  • Conectores Nativos Oracle (DD-MM-YYYY HH24:MI:SS)
PREFETCHMEMORYSize of the memory in bytes (corresponds to the OCI_ATTR_PREFETCH_MEMORY parameter of OCI_HTYPE_STMT).
The default value is 10485760 (=10 MB).
Conectores Nativos This keyword is supported by the Native Oracle Connector only.
PREFETCHROWNumber of rows in the prefetch (corresponds to the OCI_ATTR_PREFETCH_ROWS parameter of OCI_HTYPE_STMT).
The possible values are as follows:
  • 0: Disables prefetch management,
  • Default value: 1000.
Conectores Nativos This keyword is supported by the Native Oracle Connector only.
QUOTED_IDENTIFIERForces SQL Server to follow the ISO rules regarding the quotes that delimit the identifiers and the literal strings. The identifiers between double quotes can be reserved Transact-SQL keywords or they can contain characters not allowed in the conventions of Transact-SQL syntax regarding the identifiers.
The possible values are as follows:
  • 0: Forces parameter to OFF.
  • 1: Forces parameter to ON.
  • Not specified: Uses current server configuration.
Conectores Nativos This keyword is supported by the Native Sybase and SQL Server Connectors (via OLE DB and ODBC).
Server PortServer port.
For more details, see the documentation about MySQL (keyword = 'mysql_real_connect').
Conectores Nativos This keyword is supported by the Native MySQL and PostgreSQL Connectors.
SSL CAName (and path) of certification authority file.
Conectores Nativos This keyword is supported by the Native MySQL Connector and Native PostgreSQL Connector.
SSL CAPathName (and path) of directory that contains the SSL CA certificate in PEM format.
Conectores Nativos This keyword is supported by the Native MySQL Connector.
SSL CertName (and path) of certificate file.
Conectores Nativos This keyword is supported by the Native MySQL Connector and Native PostgreSQL Connector.
SSL CipherList of "ciphers" allowed during the SSL encryption.
Conectores Nativos This keyword is supported by the Native MySQL Connector.
SSL CRLList of revoked certificates (CRL = Certificate Revocation List).
Conectores Nativos This keyword is supported by the Native PostgreSQL Connector.
SSL KeyName (and path) of the key file.
Conectores Nativos This keyword is supported by the Native MySQL Connector and Native PostgreSQL Connector.
SSL ModeSSL connection mode:
  • allow: Attempt a non-SSL connection, then if unsuccessful, attempt an SSL connection.
  • disable: Disable SSL on the connection.
  • prefer (default mode): Attempt an SSL connection, then if unsuccessful, attempt a non-SSL connection.
  • require: Force SSL on the connection. If the certificate file of certification authority is supplied, check the server certificate.
  • verify-ca: Force SSL on connection with server certificate verification.
  • verify-full: Force SSL on the connection, checking that the server machine name matches the certificate.
Conectores Nativos This keyword is supported by the Native PostgreSQL Connector.
TRANS_NO_NEW_SESSIONManagement of new sessions when starting a transaction.
If this keyword is set to 1, no new session will be created when starting a transaction. This option allows you to use the temporary tables created per session.
This option can also impact the use of nested transactions.
Conectores Nativos This keyword is supported by the Native SQL Server Connector via OLE DB.
Trusted_ConnectionLog in with NT authentication.
If this keyword is set to "YES", the Windows user who runs the process to initiate the connection will be used to log in to the database
Example:
"Trusted_Connection=YES"
Conectores Nativos This keyword is supported by Native SQL Server Connector.
Unix SocketFor more details, see the documentation about MySQL (keyword = 'mysql_real_connect').
Conectores Nativos This keyword is supported by the Native MySQL Connector.
UNUSEDPROCESSESMaximum number of unused processes (3 by default) stored in cache in a WLanguage connection on SQL Server.
In the Native SQL Server and Sybase Connectors, unused processes (and their connections) are stored in a cache in order to speed up the execution of a new query
Reminder: Creating a process and connecting it is a time-consuming operation.
Conectores Nativos This keyword is supported by the Native Sybase Connector.
USECOUNTKeyword specific to the SQLxxx functions.
The possible values are as follows:
  • 0: (default value): the query result is scanned for counting.
  • 1: Uses a query request (SELECT COUNT FROM ...) to count the number of records in queries executed with SQLxxx functions.
Conectores Nativos This keyword is supported by the Native Sybase and SQL Server Connectors (via OLE DB and ODBC).
WD Cache SizeSize of the cache for retrieving the records returned by a query.
For the Native MySQL Connector and the Native PostgreSQL Connector, it is used to specify the cache size in the optional information of the connection. If this parameter is specified, the setting defined by CtCacheSize is ignored.
For the Native SQL Server Connector (via OLE DB and ODBC), defines the number of records that must be read at once by a server cursor. This value is set to 100 by default.
The possible values are as follows:
  • -2: Default value for Native Connector or client library (usually 100).
  • -1: All records are cached.
This keyword is supported by:
  • Conectores Nativos Native Sybase, SQL Server (via OLE DB and ODBC) and PostgreSQL Connectors.
  • OLE DB OLE DB.
WD CLIENT LIBRARYSpecifies the DLL of the client library that must be used for the Native Progress Connector.
Example:
"WD CLIENT LIBRARY= C:\Program Files (x86)\Progress\OpenEdge\bin\pgoe1023.dll"
If this keyword is used, the content of the WDPRGS.INI file is ignored.
Conectores Nativos This keyword is supported by the Native Progress Connector.
WD CLIENT VERSIONSpecifies the version number of the client library to be used.
This keyword is supported by:
  • Conectores Nativos SQL Server Native Connectors (Native Access) via OLE DB: The following values are possible:
    • 2000: Uses the SQLLOLEDB client library (supplied with SQL Server 2005).
    • 2005: Uses the SQLnCli client library (supplied with SQL Server 2005).
    • 2008: Uses the SQLnCli10 client library (supplied with SQL Server 2008).
    • 2012: Force the use of the SQLnCli12 client library (supplied with SQL Server 2012).
    • 2017: Force the use of the msoledbsql client library.
    • 2019: Forces the use of the msoledbsql client library in version 19.
  • Conectores Nativos SQL Server Native Connectors (Native Access) via ODBC: The following values are possible:
    • 2000: Uses the SQLLOLEDB client library (supplied with SQL Server 2005).
    • 2005: Uses the SQLnCli client library (supplied with SQL Server 2005).
    • 2008: Uses the SQLnCli10 client library (supplied with SQL Server 2008).
    • 2012: Force the use of the SQLnCli12 client library (supplied with SQL Server 2012).
    • msodbcsql11: Enables use of the msodbcsql version 11 client library.
    • msodbcsql13: Enables use of msodbcsql client library version 13.
    • msodbcsql17: Enforces use of msodbcsql client library version 17.
    • msodbcsql18: enforces use of msodbcsql client library version 18.
  • Conectores Nativos Oracle: The possible values are as follows:
    • 7: Enforces use of Oracle 7 client library (ociw32.dll).
    • 8: Uses the Oracle 8 and later client library (oci.dll).
WD Command TimeoutDefines the maximum timeout (in seconds) for running a command (command timeout).
The possible values are as follows:
  • -1: Client library default value (usually 30 sec).
  • 0: No timeout. In this case, the wait is infinite (warning: there is a risk of the application freezing).
  • value greater than 0: Timeout value in seconds.
This keyword is supported by:
  • Conectores Nativos Native Sybase, SQL Server (via OLE DB or ODBC) and PostgreSQL Connectors.
  • OLE DB OLE DB.
WD Connection TimeoutDefines the maximum timeout (in seconds) for establishing the connection (connection timeout).
The possible values are as follows:
  • -1: Client library default value (usually 30 sec).
  • 0: No timeout (infinite waiting).
  • value greater than 0: Timeout value in seconds.
This keyword is supported by:
  • Conectores Nativos Native Sybase, SQL Server (via OLE DB or ODBC) and PostgreSQL Connectors.
  • OLE DB OLE DB.
WD Cursor LocationIn most cases, the default cursor is the fastest. It corresponds to the "default result set" of the SQL Server documentation.
You have the ability to specify specific cursors:
  • "WD Cursor Location = CLIENT" allows you to request the use of a client cursor for all the browse operations performed on this connection.
  • "WD Cursor Location = SERVER" allows you to request the use of a server cursor for all the browse operations performed on this connection. The type of the server cursors used is FAST_FORWARD. For more details, see the documentation about SQL Server.
This type of cursor can be used to:
  • Limit the resources reserved on the server during the browse operations.
  • Limit the number of connections opened by the Native Connector to manage the multiple browses in parallel.
Caution:
  • In most cases, the browses performed with the server cursors are slower than the browses performed in default mode.
  • The server cursors may not be compatible with some types of queries.
  • The performance is affected by the cache size.
Note: When a connection is in transaction, server cursors are automatically used.
This keyword is supported by:
  • Conectores Nativos Native SQL Server Connector (via OLE DB or ODBC).
  • OLE DB OLE DB.
WD Lock TimeoutDefines the maximum timeout (in seconds) for implementing a lock (lock timeout).
The possible values are as follows:
  • -2: Immediate response (uses NOWAIT on Oracle).
  • -1: Default value (usually 30 sec).
  • 0: No timeout (infinite waiting).
  • value greater than 0: Timeout value in seconds.
Conectores Nativos This keyword is supported by the Native SQL Server (via OLE DB or ODBC) and Oracle Connectors (only the -2 value).
WD RECORD LOCKUsed to specify whether the management of locks is enabled (or not) on the connection.
  • If "WD RECORD LOCK = WITH (NOLOCK)", the management of locks is disabled on the connection. In this case, the Native Connector adds "WITH (NOLOCK)" into all generated SELECT queries. Therefore, the selected records are not locked.
  • If this option is not specified (default case), the management of locks is enabled on the connection. All the selected records are automatically locked.
Caution: "WD RECORD LOCK = WITH (NOLOCK)" is not used by default. This option should be used with caution: the value of the records read may not correspond to the real value (for example, if this value has recently been modified by another workstation).
CnxProgress.InfosEtendues = ...
	"PORT=2800;" + ...
	"WD RECORD LOCK = WITH (NOLOCK);" + ...
	"WD CLIENT LIBRARY= C:\...\pgoe1022.dll"
Conectores Nativos This keyword is supported by the Native Progress Connector.
Conectores Nativos Special cases:
  • Sybase: The default value is "NOHOLDLOCK"..
  • SQL Server via OLE DB: The default value is "WITH (NOLOCK)"..
For all other Native Connectors, the default value is empty (including the SQL Server connector via ODBC).
WD SESSION MODEThis value is an integer, result of a combination (BinaryOr) of the following values:
  • OCI_SYSDBA=2
  • OCI_SYSOPER=4
  • OCI_PRELIM_AUTH=8
For example, to connect as SYSDBA, you must use "WD SESSION MODE=2".
Conectores Nativos This keyword is supported by the Native Oracle Connector.
WD Unicode SupportUsed to specify whether the management of the Unicode format is enabled (or not) on the connection.
If "WD Unicode Support = 0", the management of the Unicode format is disabled on the connection. All the values will be converted (if necessary) by the server into the default character set. In this case, the performance is improved but the Unicode items are not supported.
If "WD Unicode Support = 1" (default value), the management of the Unicode format is enabled on the connection. All the exchanges with the server will be performed in Unicode. The possible conversions are managed by the native connector.
Conectores Nativos This keyword is supported by the Native SQL Server (via OLE DB or ODBC), MySQL and PostgreSQL Connectors.
Conectores Nativos The optional information is now supported for the Native AS/400 Connector (for more details, see the documentation about the Native AS/400 Connector):
  • ASP
  • AUTOJOURNAL
  • CACHERECORDS
  • CACHETIMEOUT
  • CACHETIMEOUTKEY
  • CCSID
  • LOCALCP
  • CODEPAGEFILE
  • CONNECTION TIMEOUT
  • COMMAND TIMEOUT
  • DATETYPE
  • TIMETYPE
  • DRVOPTIMISTIC
  • EIM_LOOKUP_INFO
  • EXTRAIDX
  • FIELDNAMES_MUST_MATCH
  • FORCELIBL
  • HFMAXKEY
  • IGNORE_EMPTY_EXTINFO
  • IMPORT_DFT
  • IMPORT_SELOMIT
  • LITERALCASE
  • LEADINGSPACES
  • ONLYSHORTFIELDNAMES
  • PGNAME
  • SQLNAMING
  • SSL
  • SSL_INTF
  • SSL_CAFILE
  • SSL_CAPATH
  • STRICTIDENTICAL
  • SQLFULLPRECISION
  • SQLHPOS
  • TCP_VERSION
  • TCPIP_FATAL
  • TIMEOUTNOTIF
  • USER_CERT_FILE
  • USER_CERT_PKEY_FILE
  • USER_CERT_PASSPHRASE
Versión mínima requerida
  • Versión 16
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 21/09/2024

Señalar un error o enviar una sugerencia | Ayuda local