Data Transformation Engine ODBC Adapter Reference Guide

Chapter 3 - Database Interface Designer Settings Stored Procedures Native Call Syntax

ODBC Adapter Reference Guide

The following is an example of the Database Definition dialog box with the

ODBC-specific settings.

Stored Procedures Native Call Syntax

A stored procedure can be accessed from within a map by specifying the native

call syntax in the following:

♦ a query that is specified in an input card

♦ the first argument in a

DBQUERY or DBLOOKUP function

This argument does not need to be a literal. The arguments to the stored

procedure may be determined at map execution time.

♦ the SQL Statement adapter command (

-STMT) in DBQUERY, DBLOOKUP, or GET

functions

For information about using

DBLOOKUP or DBQUERY, refer to or about using the

syntax for device-independent calls to access return values and output adapter

commands, refer to the Database Interface Designer Reference Guide.

For example, a call to a stored procedure using ODBC in a

DBLOOKUP might be:

DBLOOKUP ("{call MyAddNameProc('" + Name:Column + "',-1)}",

"mydb.mdq",

"MyDB")

Note String literals must be contained within single quotation marks; adapter

arguments must be separated by commas.