FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values
  • Page:
  • 1

TOPIC:

Just execute a MySQL Stored Procedure, also a SQL Server update statement 1 month 1 week ago #3655

  • Alan Sawyer
  • Alan Sawyer's Avatar Topic Author
  • Offline
  • Posts: 5
This might be simple but I can't figure it out.

Once I'm done, this will be put into a FH batch but right now I need to figure out the pieces.

I need to be able to execute a mysql stored procedure. That's it. no read data, no write data. Not sure how to do that.

Once I figure that out, in another FH process I need to execute an update statement in SQL Server. I can probably do the same way as mysql once I understand that part.

Any help would be appreciated.

Alan
 

Please Log in or Create an account to join the conversation.

Just execute a MySQL Stored Procedure, also a SQL Server update statement 1 month 1 week ago #3656

Hi Alan,

You can do this with the help of the SQL Heater . Just put your SQL statement here. You can decide when the SQL should be executed. Once during the “START” of the Import/Export process, at the “END” or for each processed row.

To execute a MySQL Stored Procedure you have to write call sp_NAME(para1, para2, …). If you need to overtake some field content you have to use FlowHeater Parameter instead. See screenshot below.

Like this way you can also perform your UPDATE statement on your MS SQL Server database.

 

 
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:

Please Log in or Create an account to join the conversation.

Just execute a MySQL Stored Procedure, also a SQL Server update statement 1 month 1 week ago #3657

  • Alan Sawyer
  • Alan Sawyer's Avatar Topic Author
  • Offline
  • Posts: 5
Thanks, I think I tried this but FH complained about the read side. Is there a way to tell FH that I done need a valid Read side since I'm only going to use the write side?

Alan
 

Please Log in or Create an account to join the conversation.

Just execute a MySQL Stored Procedure, also a SQL Server update statement 1 month 1 week ago #3658

Hi Alan,

Sorry I don’t understand. You can choose (1) on which side the SQL statement should be executed and (2) in case of a multi adapter definition on which Adapter ?

 
 
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:

Please Log in or Create an account to join the conversation.

Last edit: by FlowHeater-Team.

Just execute a MySQL Stored Procedure, also a SQL Server update statement 1 month 1 week ago #3659

  • Alan Sawyer
  • Alan Sawyer's Avatar Topic Author
  • Offline
  • Posts: 5
I understand that, but in this case I don't have a "read" adapter, only a "write", but I think FH requires me to have a valid "read" adapter.
I maybe can just use an empty text file and use textadapter.
I'll try it out and see if that will work.
Thanks
Alan
 

Please Log in or Create an account to join the conversation.

Just execute a MySQL Stored Procedure, also a SQL Server update statement 1 month 1 week ago #3660

Hi Alan,

Now it´s clear for me. In this case just use the TestFile Adapter as a dummy adapter. Create just one row on READ side and configure your WRITE side to perform just updates. Of course the one row shouldn’t match the primary key for updates :-) that´s all.
 
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.183 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2021 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en