Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands
Resource Adapters Reference Guide
57
Name Adapter Command Syntax
Source Target
DBLOOKUP
DBQUERY
GET PUT
Connect String
(Oracle only)
-CONNECT connect_string
√ √ √ √ √
Commit by Card*
-CCARD
√ √ √ √ √
Commit by
Statement
-CSTMT [ number ]
√ √ √ √ √
Delete
-DELETE
√ √
Database Name*
-DBNAME database_name
√ √ √ √ √
Database Adapter
Type
-DBTYPE database_adapter
√ √ √ √ √
Data Source
ODBC, DB2
-SOURCE datasource
√ √ √ √ √
Microsoft SQL
Server, S
y
base S
Q
L
Server
-SOURCE server\\database
√ √ √ √ √
File
-FILE [ directory ]
√ √
Global
Transaction
Management
(Oracle 8, Oracle AQ,
Microsoft SQL Server
7 only)
-GTX
√ √ √ √ √
Database/Query
File*
-MDQ mdq_file_name
√ √ √ √ √
Password
-PASSWORD password
√ √ √ √ √
Stored Procedure
Name
-PROC procedure_name
√ √
Query Name
-QUERY query_name
√ √
Row Count
(ODBC, Oracle,
DB2)
-ROWCNT row_count
√ √ √
SQL Statement
-STMT SQL_statement
√ √
Table Name*
-TABLE table_name
√ √