0 Replies Latest reply: Jun 9, 2016 7:31 AM by Luis Matías RSS

    Stored Procedures in Netezza from Qlikview Application?

    Luis Matías

      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