Skip to Content
0
Apr 24, 2009 at 06:01 AM

QUESTION abt "SQL_DML" of the Receiver JDBC Adapter

236 Views

HI ALL,

i hav a doubt abt "SQL_DML" of the Receiver JDBC Adapter.

i wanna use two SQL Statements in the "SQL_DML" structure to manipulate two tables.

i.e.

<root>

<stmt>

<Customers action="SQL_DML">

<access>

INSERT INTO Customers VALUES (u2019$NAME$u2019, u2019$ADDRESS$', '$KEYFIELD$u2019);

INSERT INTO Companys VALUES('$NAME$')

</access>

<key>

<NAME>Company</NAME>

<ADDRESS>Street 3 </ADDRESS>

<KEYFIELD>CO</KEYFIELD>

</key>

</Customers>

</stmt>

</root>

BUT i cant ascertain if it permit like this writting above ??

Requset help in this regards.

Thx in advance.

brian