- INFORMIX ODBC PARAMETERIZED QUERY SYNTAX DRIVERS
- INFORMIX ODBC PARAMETERIZED QUERY SYNTAX UPDATE
- INFORMIX ODBC PARAMETERIZED QUERY SYNTAX PASSWORD
When the parameter is set, the expansion is suppressed when reporting the remote column size, calculating the implicit resulting buffer size, and instantiating in the local Oracle database. When it is set to ALL, the expansion is suppressed from the non-Oracle database to the Oracle database. When it is set to LOCAL, the expansion is suppressed between the gateway and the Oracle database. When it is set to REMOTE, the expansion is suppressed between the non-Oracle database and the gateway. HS_KEEP_REMOTE_COLUMN_SIZE specifies whether to suppress ratio expansion when computing the length of (VAR)CHAR datatypes during data conversion from non-Oracle database to the gateway, and then to the Oracle database. HS_KEEP_REMOTE_COLUMN_SIZE = OFF | LOCAL |REMOTE | ALL
INFORMIX ODBC PARAMETERIZED QUERY SYNTAX UPDATE
Moreover, any update to the non-Oracle database is committed immediately. The gateway cannot participate in distributed updates. SINGLE_SITE_AUTOCOMMIT provides read and write access to the non-Oracle database without logging. READ_ONLY_AUTOCOMMIT provides read only access to the non-Oracle database that does not use logging. However, the gateway cannot participate in distributed updates. SINGLE_SITE provides read and write access to the non-Oracle database. READ_ONLY provides read access to the non-Oracle database.
INFORMIX ODBC PARAMETERIZED QUERY SYNTAX PASSWORD
The password is assigned with the HS_FDS_RECOVERY_PWD parameter. The account name is assigned with the HS_FDS_RECOVERY_ACCOUNT parameter. The transaction log table must be granted SELECT, DELETE, and INSERT privileges set to public. A different name can be set using the HS_FDS_TRANSACTION_LOG parameter. The default table name is HS_TRANSACTION_LOG. To use the commit-confirm model, the following items must be created in the non-Oracle database: Specifies the type of transaction model that is used when the non-Oracle database is updated by a transaction.ĬOMMIT_CONFIRM provides read and write access to the non-Oracle database and allows the gateway to be part of a distributed update. SET PRIVATE specifies that the parameter value is set as an environment variable for the agent process and is also private (not transferred to the Oracle database, not appearing in dynamic performance views or graphical user interfaces).ĬOMMIT_CONFIRM, READ_ONLY, SINGLE_SITE, READ_ONLY_AUTOCOMMIT, SINGLE_SITE_AUTOCOMMIT Use PRIVATE for the initialization parameters only if the parameter value includes sensitive information such as a user name or password. Making the initialization parameters private prevents the upload from happening and they do not appear in dynamic performance views. If, however, you are storing sensitive information like a password in the initialization parameter file, then you may not want it uploaded to the server because the initialization parameters and values are not encrypted when uploaded. Most initialization parameters should not be private. PRIVATE specifies that the initialization parameter should be private to the agent and should not be uploaded to the Oracle database.
INFORMIX ODBC PARAMETERIZED QUERY SYNTAX DRIVERS
Use SET for parameter values that the drivers or non-Oracle system need as environment variables. SET specifies that, in addition to being used as an initialization parameter, the parameter value is set as an environment variable for the agent process. If you do not specify either SET or PRIVATE, the parameter is used only as an initialization parameter for the agent. Most parameters are needed only as initialization parameters, so you usually do not need to use the SET or PRIVATE keywords.
You cannot use either as an initialization parameter name. If a backslash precedes any other character then the backslash is ignored.įor example, to enable tracing for an agent, set the HS_FDS_TRACE_LEVEL initialization parameter as follows: HS_FDS_TRACE_LEVEL=ON The following can be used inside a quoted string:Ī backslash at the end of the line continues the string on the next line. An initialization parameter value is either:Ī string of characters that does not contain any backslashes, white space or double quotation marks (")Ī quoted string beginning with a double quotation mark and ending with a double quotation mark. Value is the initialization parameter value. Initialization parameter names are case sensitive. It is a string of characters starting with a letter and consisting of letters, digits and underscores. Parameter is an initialization parameter name. If there is a syntax error in an initialization parameter file, none of the settings take effect. The syntax for the initialization parameter file is as follows:Įach command should start on a separate line.Įnd of line is considered a command terminator (unless escaped with a backslash).