Data Transformation Engine Resource Adapter Reference Guide

Contents
Resource Adapters Reference Guide
5
Using mtsmaker without a Database/Query File.................................................. 75
General Parameter Rules...................................................................................76
List of Parameters...........................................................................................77
Database Name (-B) ....................................................................................78
Data Source (-D) ........................................................................................ 78
Type Tree File (-F) .....................................................................................78
Stored Procedure Name (-G) .........................................................................78
Database/Query File (-M) .............................................................................78
Category Type (-N) ..................................................................................... 79
Tree Script File (-O)....................................................................................79
Password (-P)............................................................................................79
Query Name (-Q)........................................................................................79
SQL Statement (-S) .....................................................................................80
Table Name (-T) ........................................................................................80
User ID (-U) ..............................................................................................80
Variable Name (-V) .....................................................................................80
Format (-X) .............................................................................................. 81
Database Adapter Type (-Z) ..........................................................................81
Chapter 7 - Troubleshooting Database-specific Adapters
Chapter 8 - Messaging-specific Adapter Information
Overview ......................................................................................................84
Message Flow............................................................................................84
Adapter Transactions .......................................................................................86
Transactional Control.................................................................................. 86
Connection Management ..............................................................................86
Messages as a Data Source .................................................................................86
Example of Data Processing Modes..................................................................87
Messages as a Data Target .................................................................................87
Appendix A - Return Codes and Error Messages
General Adapter Messages .................................................................................88
Database-specific Adapter Messages.....................................................................90
Index