Data Transformation Engine SQL/MX Adapter Reference Guide

Adapter Commands for a Target Chapter 5 - Adapter Commands
SQL/MX Adapter Reference Guide
19
The Target in the Compiled Map is Not a Database
With Database/Query File Without Database/Query File
"'-MDQ mdq_file
-DBNAME
database_name
-TABLE
table_name
[-CCARD|-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'"
"'-DBTYPE SQLMX
-TABLE
table_name
[-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
-TABLE
table_name
[-CCARD|-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]")
PUT ("DB",
"-DBTYPE SQLMX
-TABLE
table_name
[-CCARD|-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]")