| Author |
Message
|
| golovonometr |
 Posted: Mon Jun 29, 2015 12:14 am Post subject: truncate table before upload data |
 |
|
Newbie
Joined: 29 Jun 2015
Posts: 3
|
Sorry for my bad english 
I have a app with two message flows (reading and saving), first flow reading data from csv file, second flow inserting data to database. This good working, but i need truncate tables before first message was added to queue. Global variables don't working in different flows ((
?? |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Mon Jun 29, 2015 2:20 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Send a 'sepcial' message from the first flow to the second when the file is opened. Then the second flow can truncate the table as a distinct unit of work.
Once the special message has been sent, send the data normally.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| golovonometr |
| Posted: Mon Jun 29, 2015 3:11 am Post subject: |
|
|
Newbie
Joined: 29 Jun 2015
Posts: 3
|
smdavies99, thx 
| Quote: |
Send a 'sepcial' message from the first flow to the second when the file is opened. Then the second flow can truncate the table as a distinct unit of work.
Once the special message has been sent, send the data normally |
but ibm integration bus (InputFile node) don't supporting 'start' property, for sending special message. [/quote] |
|
| Back to top |
|
|
| nelson |
| Posted: Mon Jun 29, 2015 4:29 am Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
|
| Back to top |
|
|
| golovonometr |
| Posted: Mon Jun 29, 2015 5:55 am Post subject: |
|
|
Newbie
Joined: 29 Jun 2015
Posts: 3
|
thx! this works!   |
|
| Back to top |
|
|
|
|
