Can we use Nested structure at receiver side of JDBC
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