| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database insert theoretical design question |
« View previous topic :: View next topic » |
| Author |
Message
|
| BDS |
 Posted: Tue Nov 02, 2010 6:35 am Post subject: Database insert theoretical design question |
 |
|
Newbie
Joined: 21 Oct 2010
Posts: 8
|
Hello all
All theory and pen chewing at this stage, but I'd be grateful for any pointers on how to go about a inserting data from a single input message into a db.
eg order input message
The physical design being a central table - order that has one-to-many relationships with for example
orderItems table, -stock codes or ordered items held as different rows
customerAddress, -eg holding billing & delivery address as multiple rows
Is this possible to insert directly or is the option to go via a stored proc?
I cannot find examples of primary key lookup and then potential multiple row inserts to multiple tables
Any links, comments please
Cheers |
|
| Back to top |
|
 |
| BDS |
| Posted: Tue Nov 02, 2010 12:21 pm Post subject: |
|
|
Newbie
Joined: 21 Oct 2010
Posts: 8
|
have I asked a really dumb question?  |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 02, 2010 12:44 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| BDS wrote: |
| have I asked a really dumb question? |
Well maybe, but you've really asked a question that's either answered with "yes" or "it depends".
Can you do multiple row inserts to multiple tables? Yes.
Can you invoke a stored proc to do it? Yes.
Which method should you use? It depends.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| BDS |
| Posted: Wed Nov 03, 2010 1:24 am Post subject: |
|
|
Newbie
Joined: 21 Oct 2010
Posts: 8
|
Thanks Vitor
I knew I could invoke a stored proc, so I'll keep exploring the multiple row inserts to multiple tables.
If anyone has any pseudo or example code to get me started looking int he right areas - appreciated.
Thanks |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
