

- MATERIALS STUDIO GATEWAY INITIALIZATION 64 BIT
- MATERIALS STUDIO GATEWAY INITIALIZATION DRIVERS
- MATERIALS STUDIO GATEWAY INITIALIZATION DRIVER
- MATERIALS STUDIO GATEWAY INITIALIZATION PASSWORD
This parameter is only valid for 64 bit platforms. This parameter is valid only when HS_LANGUAGE is set to A元2UTF8 and the gateway runs on Windows. This is the number of rows to be fetched from the non-Oracle database and to return to Oracle database at one time. HS_FDS_FETCH_ROWS specifies the fetch array size.
MATERIALS STUDIO GATEWAY INITIALIZATION DRIVER
Specifies the full path name to the ODBC driver manager. Specifies whether error tracing is turned on or off for gateway connectivity. The name of the table owner that is used for the non-Oracle database tables if an owner is not specified in the SQL statements.

HS_FDS_CONNECT_INFO describes the connection to the non-Oracle system. Maps non-Oracle target dates to Oracle target dates. Maps non-Oracle timestamps to Oracle timestamps. Use the IFILE initialization parameter to embed another initialization file within the current initialization file. Specifies the type of transaction model that is used when the non-Oracle database is updated by a transaction.

Specifies the default local time zone displacement for the current SQL session. Tunes internal data buffering to optimize the data transfer rate between the server and the agent process. Sets the size of the piece of LONG data being transferred.ĭefines the maximum number of cursors that can be open on one connection to a non-Oracle system instance.Ĭontrols whether Heterogeneous Services attempts to optimize performance of data transfer between the Oracle database and the Heterogeneous Services agent connected to the non-Oracle data store. Provides Heterogeneous Services with character set, language, and territory information of the non-Oracle data source. Specifies the maximum number of entries in the describe cache used by Heterogeneous Services. Specifies a unique alphanumeric name for the data store given to the non-Oracle system. Specifies a unique hexadecimal number identifying the instance to which the Heterogeneous Services agent is connected. Specifies a unique network sub-address for a non-Oracle system. 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). 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.
MATERIALS STUDIO GATEWAY INITIALIZATION PASSWORD
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.
MATERIALS STUDIO GATEWAY INITIALIZATION 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: 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. Set the parameter values as follows: parameter= value If there is a syntax error in an initialization parameter file, none of the settings take effect. Each command should start on a separate line.Įnd of line is considered a command terminator (unless escaped with a backslash).
