topic DB2 REFRESH Command from QV in QlikView https://community.qlik.com/t5/QlikView/DB2-REFRESH-Command-from-QV/m-p/720238#M674077 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><TABLE><TBODY><TR><TD>ODBC CONNECT TO D_BIDW_T;&nbsp;&nbsp; </TD><TD> /*&nbsp; ETL_DEV&nbsp; */</TD></TR></TBODY></TABLE><P></P><P>SQL</P><P>REFRESH TABLE BIDW.D_BIDW_T.USA_PRODUCTSTOCKROOM_BASE;</P><P></P><P>Thanks In Advance,</P><P>Dan</P></BODY></HTML> Mon, 21 Jul 2014 15:42:48 GMT dbaksa_1 2014-07-21T15:42:48Z DB2 REFRESH Command from QV https://community.qlik.com/t5/QlikView/DB2-REFRESH-Command-from-QV/m-p/720238#M674077 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><TABLE><TBODY><TR><TD>ODBC CONNECT TO D_BIDW_T;&nbsp;&nbsp; </TD><TD> /*&nbsp; ETL_DEV&nbsp; */</TD></TR></TBODY></TABLE><P></P><P>SQL</P><P>REFRESH TABLE BIDW.D_BIDW_T.USA_PRODUCTSTOCKROOM_BASE;</P><P></P><P>Thanks In Advance,</P><P>Dan</P></BODY></HTML> Mon, 21 Jul 2014 15:42:48 GMT https://community.qlik.com/t5/QlikView/DB2-REFRESH-Command-from-QV/m-p/720238#M674077 dbaksa_1 2014-07-21T15:42:48Z Re: DB2 REFRESH Command from QV https://community.qlik.com/t5/QlikView/DB2-REFRESH-Command-from-QV/m-p/720239#M674078 <HTML><HEAD></HEAD><BODY><P>Hi Daniel, you should have select option "Open Databases on Read &amp; Write Mode" on the Settings tab under Script block.</P></BODY></HTML> Mon, 21 Jul 2014 17:30:13 GMT https://community.qlik.com/t5/QlikView/DB2-REFRESH-Command-from-QV/m-p/720239#M674078 2014-07-21T17:30:13Z