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 Stepanov <dmi...@dmitryds.com> wrote: > > > 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 <phillord0...@gmail.com> >> 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 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 >> >> Thanks >> Phil > >
