Hi guys,
I want to know how to run Stored Procedures as DB Inputs in DB Connect 2.
I have some SP's running as DB Inputs in DB Connect 1 and they work great. Also, those SP's receive as a parameter the rising column like this:
EXEC [user].[sp_records_monitor] @LAST_UPDATE = {{ ? }}
But now I'm migrating from DB Connect 1 to DB Connect 2 and I'm getting errors when I define those SP's as a DB Input and also passing the rising column to the SP.
Already tried to run the SP outside, in the search, using the dbxquery, but didn't work either.
Can anyone tell me the exact syntax to run the query now with the SP and also how to pass the value of the rising column to a DB Input?
Best regards,
João Amorim
... View more