Member since
10-04-2022
1
Post
0
Kudos Received
0
Solutions
10-04-2022
06:57 AM
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?
... View more
Labels:
- Labels:
-
Apache NiFi