Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Daniel, you should have select option "Open Databases on Read & Write Mode" on the Settings tab under Script block.