| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for AS/400 |
![[-]](/dwicons/i_colpse.gif)
| Chapter 2 Configuring the DirectConnect Access Service Library |
|
| Access service Client Interaction properties |
These properties control how an access service interacts with client applications.
The subsection heading for these properties must appear in the service library configuration file as:
{Client Interaction}Points to a file with application validation information. This property is included for backward compatibility with MDI Database Gateway only. To use this feature, set the GatewayCompatible property to yes.
ApplicationValidationFile=pathfilename
0-128 characters
No default
pathfilename is the complete file specification, including the full path name, for the file with application validation information.
We recommend you use the service name redirection capability as described in DirectConnect Server Administration Guide instead of application validation. If you must use an application validation file, see the MDI Database Gateway Installation and Administration Guide for your target database system and platform.
If you choose to use both service name redirection and application validation, service name redirection takes precedence.
Specifies the character the client application uses to separate decimal numbers for presentation purposes. The target database does not store the client decimal delimiter character.
ClientDecimalSeparator=[ . | , ]
. (period)
A period (.) indicates that the client application uses a period as the decimal delimiter.
A comma (,) indicates that the client application uses a comma as the decimal delimiter.
Following is an insert example using commas as the decimal delimiter:
insert into testtbl values(2,00,__,3,33,__)
If some of your client applications use a different character as a decimal delimiter, make sure that those applications connect to an access service configuration set that uses the same client decimal delimiter character.
If the client decimal delimiter is a comma (,), set the DecimalResults property value to char to enable the access service to return decimal results with a comma as the client decimal delimiter.
If the SQLTransformation property value is passthrough, use the TargetDecimalSeparator value for all SQL requests going to the target database. For example, if the TargetDecimalSeparator value is a period (.), use a period for the decimal delimiter in all SQL requests going to the target database (such as insert statements).
For information about SQL transformation modes, see "SQL Transformation modes" .
Specifies how many minutes a client connection can remain inactive before an access service terminates the connection.
ClientIdleTimeout=integer
0-1024
0
integer is how many minutes a client connection can remain inactive before an access service terminates the connection.
0 indicates that an access service never terminates an idle connection.
A connection is idle when:
A client connected but did not issue a command.
A command processed, but the client did not issue another command.
A large result set returned from SQL request processing, and the result screen paused for the specified timeout period.
The access service checks client activity once per minute. Therefore, a client can remain inactive for up to one minute beyond the ClientIdleTimeout value before the access service ends the connection.
Specifies whether this access service starts when the DirectConnect Server starts.
EnableAtStartup=[ no | yes]
no
no means that the access service does not start when the server starts.
yes means that the access service does start when the server starts.
If you are not using DirectConnect Manager for Microsoft Windows 95 and Windows 98, to manage your access services, set this property to yes.
Specifies whether the access service accepts and returns MDI Database Gateway set statements, global variables, and a few error messages that client applications use to make processing decisions. This property is included for backward compatibility with MDI Database Gateway only. We recommend you use current access service settings.
GatewayCompatible=[ no | yes ]
no
no means that the access service recognizes access service settings only.
yes means that the access service recognizes both access service settings and MDI Database Gateway settings.
Backward compatibility with the MDI Database Gateway is provided only as an interim measure to allow you to upgrade your client applications to the syntax supported in the access service.
If your client applications do not require MDI Database Gateway settings, set this value to no to use access service settings only.
If your current client applications use previous MDI Database Gateway global variables and set statements, set this property to yes to allow your applications to continue to use MDI Database Gateway settings.
For information about backward compatible MDI Database Gateway settings, see Appendix A, "Backward compatibility with MDI database gateways"
Specifies the maximum number of bytes an access service returns to the client application in a result set.
MaxResultSize=integer
0-2147483646
2147483646
integer is a number of bytes.
A value of 0 (zero) defaults to 2147483646 bytes (the default value).
The MaxResultSize value is approximate in that an access service checks at the end of each row to see if the MaxResultSize value was exceeded.
If the MaxResultSize value is exceeded, the access service:
Sends the entire row to the client application (not a partial row)
Does not send any of the remaining rows in the result set
Issues a warning message
Typically, the number of bytes returned is less than the value of the MaxResultSize property because the calculations for character columns are based on the defined size, whereas the actual data contained in these columns is usually less.
The SendWarningMessages property controls whether the access service returns warning messages to the client application. See "SendWarningMessages" .
Specifies the maximum number of rows an access service returns to the client application in a result set.
MaxRowsReturned=integer
0-2147483646
2147483646
integer is a number of rows.
A value of 0 (zero) defaults to 2147483646 rows (the default value).
If the MaxRowsReturned value is exceeded, the access service issues a warning message and does not send any of the remaining rows in the result set.
The SendWarningMessages property controls whether the access service returns warning messages to the client application.
Specifies the maximum number of client connections the access service can handle at one time.
MaxSvcConnections=integer
1-n where n is the maximum number of client connections allowed by the server.
MaxConnections property value of the DirectConnect Server.
integer is a number of client connections.
The server MaxConnections property determines the maximum number of client connections. For information about MaxConnections, see the DirectConnect Server Administration Guide.
The Allocate property value can affect the number of client connections:
If the Allocate property is set to connect, MaxSvcConnections should be equal to or less than the number of parallel APPC sessions that can be supported from the server to the AS/400.
The access service does not verify the validity of the MaxSvcConnections value. Based on the platform, exceeding the number of parallel sessions will cause unpredictable results.
If the Allocate property is set to request, you can set the MaxSvcConnections property to a value greater than the number of parallel APPC sessions that you configured in your APPC software. For more information about the Allocate property, see "Allocate" .
Specifies whether to enable or disable delimited identifiers. Delimited identifiers are object names enclosed in double quotes. You can use them to avoid certain restrictions on object names. Table, view, and column names can be delimited by quotes; other names cannot.
Delimited identifiers can:
Be reserved words
Begin with non-alphabetic characters
Include characters that ordinarily are not allowed
quoted_identifer=[ on | off ]
off
on means that a quoted string used as an identifier is recognized.
off means that a quoted string used as an identifier is not recognized as an identifier.
Delimited identifiers follow the conventions for identifiers for AS/400.
Before you create or refer to a delimited identifier, issue the following statement:
set quoted_identifier on
Each time you use the delimited identifier in a statement, you must enclose it in double quotes. For example:
create table "1one" (col 1 char(3)) create table "include spaces" (col1 int)
or
create table "grant"("add" int)
insert "grant"("add") values (3)When the quoted_identifier configuration property is turned on, use single quotes, not double quotes, around character or date strings. Delimiting strings with double quotes causes Adaptive Server to treat them as identifiers. The following example shows the correct way to insert a character string into col1 of 1table when the quoted identifier "1one" is turned on:
insert "1one"(col1) values ('abc')To insert a single quote into a column, use two consecutive single quotation marks. The following example shows the correct way to insert the values "a'b" into col1:
insert "1one"(col1) values('a"b')Specifies whether an access service returns warning messages to the client application.
SendWarningMessages=[ no | yes ]
no
no specifies that the access service does not return warning messages to the client application.
yes specifies that the access service returns warning messages to the client application.
For information about error messages, see the DirectConnect Error Message Guide.
Describes an access service.
ServiceDescription=char
0-255 characters
No default
char is a user-defined character string.
This property enables you to place descriptive information in the configuration file about each access service.
Specifies the maximum number of bytes in character columns an access service returns to the client application.
TextSize=integer
0-32767
32767
integer is a number of bytes.
A value of 0 (zero) defaults to 32767 (the default value).
An access service truncates data exceeding the TextSize length and does not issue a warning message.
The access service returns character data longer than 255 bytes as CS_TEXT datatype.
Specifies whether the access service or the client application manages commits and rollbacks.
TransactionMode=[ short | long ]
short
long specifies that the access service gives commitment control to the client application. The access service keeps the connection to the target database active until one of the following occurs:
The client application issues a commit or rollback.
The ClientIdleTimeout value is exceeded, in which case the transaction rolls back. (See "ClientIdleTimeout" .)
short indicates that the access service issues a commit or a rollback after each request.
For the AS/400, transaction management requires journaling on all files (table and physical), which is known as cursor stability. See the IsolationLevel property for defining journaling levels. For information about enabling journaling, see the DirectConnect Installation Guide for Enterprise Connect Data Access IPS.
Allows you to customize an alternate version string for client applications that rely on a particular string that is different from the access service default version string.
Version=versionstring
The access service default version string
versionstring is the version string you want reported to client applications.
If you leave this property blank, it defaults to the access service default version string.
If you customize an alternate version string, the following rules apply:
The format of this string cannot contain embedded new lines.
You can insert a space after the equal sign (=) for readability in the configuration file; however, when an access service sends the version string to the client application, it removes any leading and trailing white space.
You can obtain the access service default version string by issuing sp_helpserver. (See sp_helpserver .)
|
|