Destination-Template Transfer Statement

The destination-template transfer statement allows you to transfer data and send a result set into a template.

• Destination-Template Transfer Processing
  During a destination-template transfer, the access service inserts the data values it retrieves with the sourceselectstatement from the source database into the destination-template SQL clause.
• Datatype Qualifiers
  Qualifiers tell the access service how to format data that is inserted for a placeholder.
• Special Date and Time Qualifiers
  You can combine special date and time qualifiers and construct the date or time format that the target database requires.
• Destination-Template Processing
  A service library processes destination-template processes using transfer from and transfer to statements.
• Destination-Template Transfer Errors
  Value errors occur during transfer processing when the value being inserted is out of range for the column’s datatype.
• Transfer RPC
  The client application can create a stored procedure within Adaptive Server that invokes the access service library transfer function.