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.
dbaksa_1
Contributor

DB2 REFRESH Command from QV

Is is possible to execute a DB2 refresh command from QV? I want to refresh a DB2 table before extracting data from it. Below is the syntax I'm using. I receive a ready only error when I use the code below. If I change the ODBC config I still get the same error.

ODBC CONNECT TO D_BIDW_T;   /*  ETL_DEV  */

SQL

REFRESH TABLE BIDW.D_BIDW_T.USA_PRODUCTSTOCKROOM_BASE;

Thanks In Advance,

Dan

Tags (1)
1 Reply
Not applicable

Re: DB2 REFRESH Command from QV

Hi Daniel, you should have select option "Open Databases on Read & Write Mode" on the Settings tab under Script block.

Community Browser