Default datatype conversion  usertype values

Chapter 4: Converting Datatypes

Client-specified datatype conversion

Some Open Client and Open Server datatypes do not directly map to target datatypes. For example, Open Client and Open Server CS_DATETIME and CS_DATETIME4 datatypes do not directly map to DB2 DATE, TIME, or TIMESTAMP datatypes.

When defaults are not appropriate for these datatype conversions, the CT-Library client can specify the intended DB2 datatype by using the usertype field in the parameter’s CS_DATAFMT structure. The client fills in the CS_DATAFMT structure and a pointer to the structure is passed to the ct_param Open Client function call.

The DB2 access service then converts the Open Client and Open Server datatype to the precise target datatype.

DB-Library clients cannot take advantage of this feature and are limited to the default datatype conversions.





Copyright © 2005. Sybase Inc. All rights reserved. usertype values

View this book as PDF