Support Questions

Find answers, ask questions, and share your expertise

NiFi handling status code and cursor from DB2 procedure

avatar
New Contributor

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_1-1664891463880.png

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?

 

 

0 REPLIES 0