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 */|
REFRESH TABLE BIDW.D_BIDW_T.USA_PRODUCTSTOCKROOM_BASE;
Thanks In Advance,