Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Stored Procedures in Netezza from Qlikview Application?

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

Community Browser