ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 3 matches
Author Message
  Topic: truncate table before upload data
golovonometr

Replies: 4
Views: 2072
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Jun 29, 2015 5:55 am   Subject: truncate table before upload data
You can use LocalEnvironment.File.Record property, so you will know when the first record is being processed and do what you need to do:

Record: Number of the record within the file. The first reco ...
  Topic: truncate table before upload data
golovonometr

Replies: 4
Views: 2072
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Jun 29, 2015 3:11 am   Subject: truncate table before upload data
smdavies99, thx

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 mes ...
  Topic: truncate table before upload data
golovonometr

Replies: 4
Views: 2072
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Jun 29, 2015 12:14 am   Subject: truncate table before upload data
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 tr ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.