Data Transformation Engine SQL/MX Adapter Reference Guide

SQL/MX Adapter Reference Guide
3
Contents
About This Document
Related References........................................................................................... 4
Chapter 1 - NonStop SQL/MX Adapter
Overview ....................................................................................................... 5
Chapter 2 - Command Alias
Chapter 3 - Database Columns and Types
Item Type Properties......................................................................................... 7
Date and Time Formats...................................................................................... 9
Default NonStop SQL/MX Format ..................................................................... 9
Available NonStop SQL/MX Formats.................................................................10
Chapter 4 - Database Interface Designer Settings
Database Definition Dialog Box ...........................................................................12
Chapter 5 - Adapter Commands
Adapter Command Summary...............................................................................14
Adapter-specific Command ................................................................................14
Database Adapter Type (-DBTYPE) ..................................................................14
Adapter Commands for a Source..........................................................................15
GET > Source > Command Setting ...................................................................15
-ID Execution Command ...............................................................................15
DBLOOKUP or DBQUERY Functions...................................................................16
GET Function ............................................................................................17
Adapter Commands for a Target..........................................................................17
PUT > Target > Command Setting ................................................................... 18
-OD Execution Command..............................................................................18
PUT Function ............................................................................................19
Chapter 6 - Restrictions and Limitations
Appendix A - Return Codes and Error Messages
Index