Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information Using Database-specific Adapters

Resource Adapters Reference Guide

Using Database-specific Adapters

Database-specific adapter commands can be used in any of the following ways:

♦ when specifying adapter settings for sources and targets

♦ with functions in map and component rules

♦ on the command line using execution commands to override source or target

settings

See General Rules for Adapter Commands and Chapter 2 - Resource Adapters Use

for more information.

Adapter Usage in Functions

The set of adapter commands specified in functions must begin with one double

quotation mark and end with one double quotation mark. Each adapter command

is separated by one space. The following is an example:

DBLOOKUP ("SELECT * FROM PARTS","

command1 command2…

Adapters in Input Data and Output Data Settings

Use the Map Designer or Integration Flow Designer to specify a database adapter

either as a source or as a target by selecting Database as the value for the

GET > Source or PUT > Target setting, respectively. In addition to the common

adapter settings such as Scope, Retry, and so on, you can enter any of the

desired database adapter commands for the GET > Source > Command or

PUT > Target > Command settings.

List of Commands

The following table lists each database-specific adapter command and whether the

command can be used for a source and/or a target, and/or in a

DBLOOKUP,

DBQUERY, GET, or PUT function. Usage is indicated with √. For a RUN function, any

adapter command can be used as indicated for a source or target.

Name Adapter Command Syntax

Source

Target

DBLOOKUP

DBQUERY

GET

PUT

Audit

-AUDIT[G][+] [

full_path

]

√ √ √ √ √

Bad Data

-BADDATA[+]

full_path

√ √