mapping

Specify how data types are to be mapped.

USYS$MSS_PARAMS = mapping : 1 | 2 | 11 | 22 | 23

Arguments

  • 1—use the same mapping as the U1.1 connector

  • 2—use the Numeric data type for N packing codes and SQL Server 7.0 limits (default)

  • 11—same as mapping=1, but with mapping of money fields (M2) to Numeric(19,2)

  • 22—same as mapping=2, but with mapping of money fields (M2) to Numeric(19,2)

  • 23—same as mapping=2, but all date fields are stored in a Date field, by default. Only applicable for MS SQL 2008 and higher.

Related Topics