Hi All,
I'm trying call to a netezza (odbc connection to NZSQL) procedure wirh parameters from qlikview:
SQL execute gdc.prc_update_ie_sales('product', 'South', 201605, 200, 'SIMULATED', 'user', current_timestamp, 1);
but it does not work and shows the error:
SQL##f - SqlState: 01000, ErrorCode: 2, ErrorMsg: NOTICE: Error occurred while executing PL/pgSQL function PRC_UPDATE_IE_SALES
SQL execute gdc.prc_update_ie_ventas_cartera('product', 'South', 201605, 200, 'SIMULATED', 'user', current_timestamp, 1)
I've tried to call procedure with a OLEDB Netezza connection and it works. Anyone know what happens and why it does not work in odbc?
Thanks in Advance,
Regards
Luis
