Data Transformation Engine ODBC Adapter Reference Guide

ODBC Adapter Reference Guide
3
Contents
About This Document
Related References........................................................................................... 4
Chapter 1 - ODBC Adapter
Overview ....................................................................................................... 6
System Requirements........................................................................................ 6
Chapter 2 - Database Columns and Types
Item Type Properties......................................................................................... 7
Date and Time Formats...................................................................................... 8
Chapter 3 - Database Interface Designer Settings
Database Definition Dialog Box ...........................................................................10
Stored Procedures Native Call Syntax....................................................................11
Chapter 4 - ODBC Adapter Commands
Adapter Command Summary...............................................................................12
Adapter-specific Commands .......................................................................... 12
Adapter Commands for a Source..........................................................................14
GET > Source > Command Setting ...................................................................14
-ID Execution Command ............................................................................... 15
DBLOOKUP or DBQUERY Functions...................................................................16
GET Function ............................................................................................16
Adapter Commands for a Target..........................................................................16
PUT > Target > Command Setting ................................................................... 17
-OD Execution Command.............................................................................. 17
PUT Function ............................................................................................17
Chapter 5 - Overriding Column Attributes
Defining Column Attribute Overrides ....................................................................19
Chapter 6 - Binding Values in DBLOOKUP/DBQUERY
Limitation When Using ODBC ..............................................................................24
Specifying the Data Type...................................................................................24
Chapter 7 - Configuring DSN for Event Server Startup
Selecting the Startup Method .............................................................................27
Chapter 8 - Restrictions and Limitations
Appendix A - Return Codes and Error Messages
Index