Data values embedded as strings  SQL transformation

Chapter 4: Converting Datatypes

Datatype conversion

When a DB2 access service receives data values embedded in strings, it does not automatically convert the incoming data values. The client application must format the strings correctly with valid datatypes before sending them to the target database. The DB2 access service provides a string template for the target datatypes. To find the correct datatype, the client application receives this string template for the target datatypes from the sp_columns CSP.





Copyright © 2005. Sybase Inc. All rights reserved. SQL transformation

View this book as PDF