Stored procedures that take no output parameters and return ResultSets should
work fine with ExecuteSQL, but for DBs that allow OUT and INOUT parameters,
those won’t make it into the outgoing FlowFile (in either content or
attributes).
Regards,
Matt
> On Feb 27, 2023, at 4:19 PM, Dmitry Stepa
Hello Harshit ... I'm assuming "MyssqlTcp" is the name of a process
group in your NiFi GUI?? If so, can you show a screenshot of the NiFi
processors that are in that process group so we can see which processor
or where in the processing things might be hanging up?
Given no other info, the eas
We run our procedure using ExecuteSQL.
Just make sure to use proper SQL syntax
On February 27, 2023 2:09:19 p.m. Phillip Lord wrote:
Hello,
Does anyone have any experience executing a DB2 stored procedure?
Potentially using PutSQL? I don't think it can be done using ExecuteSQL,
and I can li
Hello,
Does anyone have any experience executing a DB2 stored procedure?
Potentially using PutSQL? I don't think it can be done using ExecuteSQL,
and I can likely use an executeStreamCommand to accomplish this. But
trying not to reinvent the wheel if I can just do it using a simple Nifi
processor