DB2 REFRESH Command from QV

[dbaksa_1]

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

[#2]

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