Can we use Nested structure at receiver side of JDBC

[AbdulHammed]

Hi Experts,

my scenarios is PROXY to JDBC and the example structure is defined as below for PROXY

The ‘H’ prefix indicates the header items. The ‘D’ indicates the Detailer items and the prefix ‘B’ is for the SubDetailer data items. A production order can have multiple Detailers and the each Detailer can have multiple SubDetailers. Therefore the logic needs to index and sort the data into each separate production order. Example Data as below

H	100	50	2/1	10
D	100	50	5	5
B	100	50	5	001
H	200	75	2/4	20
D	200	75	10	2/10
B	200	75	10	002
D	200	75	20	2/10
B	200	75	20	003

so all the above details are about PROXY structure and sample data that triggered from PROXY.

Now my question is can we use same nested structure for the JDBC at receiver side under ACCESS cuz we have to insert the data in one particular table of Database. or do we have any alternatives to simplified this scenario.

Please help me on this.

Regards

[apu_das2]

Hi Abdul,

The proxy structure is a custom structure that you have created as per your requirement. But JDBC structure depends on your table structure or stored procedure that you are using at receiver end.

If you are inserting data directly into database table then you can insert the table structure as an external definition using option dbtab.

Generally Below is the structure for Table -

Statement

   dbTableName

      action

      table

      access

           param1

           param2

Stored Procedure -

Statement

   <Stored Procedure Name>

      action

      <param 1>

         isInput

         Type

      <param 2>

         isInput

         Type

[former_member190293]

Hi Abdul!

If your aim is to perform insert operations in particular order, say, Headers->Detailers->Subdetalers, then you should use mapping to construst message structure with multiple Statement items for jdbc query.

Regards, Evgeniy.

[AbdulHammed]

Hi Evgeniy,

Thanks for your reply...but the structure is like Subdetailer is child node of Detailer & Detailer is child node of Header and one more thing is we can get multiple detailers under one Header and Multipler SubDetailer under One Detailer Items.....

Example: Please find below same data where you can see the combinations of H, D & B in one record...

H	100	50	2/1	10
D	100	50	5	5
B	100	50	5	001
H	200	75	2/4	20
D	200	75	10	2/10
B	200	75	10	002
D	200	75	20	2/10
B	200	75	20	003

[former_member190293]

As Bhavesh has already asked, what is your target database table structure?

And what is the way your data has to be inserted into that table?

[bhavesh_kantilal]

What is the target Table structure to which this data has to be posted to? The JDBC table determines the target Message Type structure to be used and not the source..

Regards

Bhavesh

[AbdulHammed]

Hi Bhavesh,

Target structure is same as source nested structure.....

[bhavesh_kantilal]

Sorry that does not make sense. The target structure as per my previous response depends on the table structure in which you are inserting the data. What is your table structure considering you are inserting into a database table? There is no such thing as nested tables. You only have primary keys and foreign keys on your tables.

[AbdulHammed]

Thanks Bhavesh for your valuable time & response to the query.