hello!
I'm trying to get two outputs from DB2 via ExecuteSQL. my procedure call look like
CALL LNSI01.GETNSI_ETR('table_name','1970-01-01-00.00.00' ,'9999-12-31-23.00.00', ?);
and it should return status code (0 or 1) and cursor for data. that's how it look in dbeaver:
but nifi throw exception:
ExecuteSQLRecord[id=af97199f-11df-1182-bd74-9c849e01a5cb] Unable to execute SQL select query CALL LNSI01.GETNSI_ETR('IC00.TER_OBJ','1970-01-01-00.00.00' ,'9999-12-31-23.00.00', ?) due to DB2 SQL Error: SQLCODE=-313, SQLSTATE=07004, SQLERRMC=null, DRIVER=4.25.13. No FlowFile to route to failure: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-313, SQLSTATE=07004, SQLERRMC=null, DRIVER=4.25.13
how can I get it? is it possible at all?