1 Reply Latest reply: Jul 21, 2014 1:30 PM by Srikanth P RSS

    DB2 REFRESH Command from QV

    Daniel Baksa

      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