JDBC DT

[Former Member]

Hi All:

Is it possible to create two statement in a single Table.

Like I have to update two tables :

table 1

field1

field2

field3

table 2

f1

f2

f3

Now can I make a DT like this and go with only one JDBC receiver.

<b>

<statement>

<table2>

< action>

<access>

<field1>

<field2>

<field3>

<table2>

<f1>

<f1>

<f1></b>

IF NOT so how my data type will look for both tables. Is it required to create two different DT and two JDBC receiver.???

Thanks

FMF

[Former Member · Accepted solution]

Hi-

Yes you can use the single datatype to update two tables only thing is that the Mapping should be done correctly.

[Former Member]

I think you got the answer

Message was edited by:

Amitanshu Deep

[Former Member]

You can update 2 tables with single data type.No need to define two data types.Your structure is correct.

[Former Member]

so finally I can go with this structure...

<b><statement>

<table1>

<action>

<access></b><i>

<field1>

<field2>

<field3></i>

<b>

<table2>

<action>

<access></b><i>

<f1>

<f2>

<f3></i>