Hello to you,
I have been trying for a few days to run a store procedure with DB Connect 3.1.3.
I'm trying with dbxquery:
| dbxquery connection = TEST_CONNECT procedure = "{call ps_store_procedure_name ('2018-01-01', '2018-04-30')}"
Unfortunately it still tells me no results found
I also tried with an INPUT directly in data lab with the following command
SET NOCOUNT ON
EXEC STOREPROCEDURE_NAME
I have values that appear but they are wrong
Do you have any ideas ?
thank you very much
without "SET NOCOUNT ON" it does not work
Anybody have a solution ?