Manualshelf

Data Transformation Engine ODBC Adapter Reference Guide

ManualsBrandsHP ManualsServerHP NonStop G-Series
11121314151617181920
Chapter 4 - ODBC Adapter Commands Adapter Commands for a Target
ODBC Adapter Reference Guide
18
With Database/Query File
Without Database/Query File
[-AUDIT[G][+] [
full_path
]]
[{-TRACE|-TRACEERR}[+] [
full_path
]]'
[-BADDATA[+]
full_path
]
[-AUDIT[G][+] [
full_path
]]
[{-TRACE|-TRACEERR}[+] [
full_path
]]'
The Target in the Compiled Map is Not a Database
With Database/Query File Without Database/Query File
'-MDQ
mdq_file
-DBNAME
database_name
-PROC
procedure_name
|-TABLE
table_name
[-USER
username
]
[-PASSWORD
password
]
[-CCARD|-CSTMT [
number
]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path
]
[-AUDIT[G][+] [
full_path
]]
[{-TRACE|-TRACEERR}[+] [
full_path
]]'
'-DBTYPE ODBC
-SOURCE
datasource
-PROC
procedure_name
|-TABLE
table_name
[-USER
username
]
[-PASSWORD
password
]
[-CCARD|-CSTMT [
number
]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path
]
[-AUDIT[G][+] [
full_path
]]
[{-TRACE|-TRACEERR}[+] [
full_path
]]'
PUT Function
Use the PUT function to pass data to the target adapter.
With Database/Query File Without Database/Query File
PUT ("DB",
"-MDQ
mdq_file
-DBNAME
database_name
-PROC
procedure_name
|-TABLE
table_name
[-USER
username
]
[-PASSWORD
password
]
[-CCARD|-CSTMT [
number
]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path
]
[-AUDIT[G][+] [
full_path
]]
[{-TRACE|-TRACEERR}[+] [
full_path
]]")
PUT ("DB",
"-DBTYPE ODBC
-SOURCE
datasource
-PROC
procedure_name
|-TABLE
table_name
[-USER
username
]
[-PASSWORD
password
]
[-CCARD|-CSTMT [
number
]]
[-DELETE]
[-BADDATA[+]
full_path
]
[-AUDIT[G][+] [
full_path
]]
[{-TRACE|-TRACEERR}[+] [
full_path
]]")