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:
![mdvonavi_0-1664891449188.png mdvonavi_0-1664891449188.png](https://community.cloudera.com/t5/image/serverpage/image-id/35839iC5B717FCEEA5719E/image-dimensions/246x218?v=v2)
![mdvonavi_1-1664891463880.png mdvonavi_1-1664891463880.png](https://community.cloudera.com/t5/image/serverpage/image-id/35841i7DCEF12005EF04DC/image-dimensions/240x212?v=v2)
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?