Access Service User's Guide DirectConnect for AS/400

Home

Access Service User's Guide DirectConnect for AS/400

Chapter 2 Configuring the DirectConnect Access Service Library

Access service Client Interaction properties

ClientDecimalSeparator

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.

Syntax

ClientDecimalSeparator=[ . | , ]

Default

. (period)

Values

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.

Comments

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" .


	Expand Search