Originally posted by: SystemAdmin

Hi,

My input is an XML type data and for each record there are 3 different fields are present (Author, Subject, BookName) and the Output is MS Access Database. I have 3 different tables in the database, each to handle the corresponding records for each subject.

For my Input, there are 5 records, with 3 different Subjects. So, I want the records should be inserted through 3 tables based on the subject value for each record.

I have passed each record in the Functional Map (F_Map) and used Insert statement in DBLOOKUP Statement. But, I am not getting any record in tables neither any .dbl file getting created even though I have passed -TRACE command option and set the uodate keys for each of those table in the .MDQ File. I am specifiying the rules used to insert the records into different tables:
b:f90f8a234f
DBQUERY("INSERT INTO " + Subject:ElemDecl Books:Input " (Author, BookName) VALUES ('" Author:ElemDecl Books:Input + "','" + Title:ElemDecl Books:Input + "')","-MDQ SampleMDQ.mdq -DBNAME SampleDB -UPDATE -TRACE") [/b:f90f8a234f]

Kindly suggest me something to get solution for this.

Thanks in advance,
Pranab
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

DBQUERY with ODBC is used as a source not a target. DBQUERY definitely does not use the -UPDATE. Try a PUT. Trace file is not being created because -UPDATE is not a valid command and thus the -T is ignored.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

You could also call a RUN map from the functional map and use that map's output to ODBC adapter as target.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender