topic Create SQL Table from QlikSense LoadScript in App Development https://community.qlik.com/t5/App-Development/Create-SQL-Table-from-QlikSense-LoadScript/m-p/1276942#M26488 <HTML><HEAD></HEAD><BODY><P>Hey folks,</P><P></P><P>I want to create a SQL table from QlikSense script.</P><P>Therefore I use the following syntax:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_148939567468374" jivemacro_uid="_148939567468374"> <P>load *; SQL create table oxopen.GMT411.TEST;</P> </PRE><P></P><P>But I always receise the following error:</P><P><SPAN style="color: #ff0000; font-family: monospace; font-size: 13px;">ErrorSource: Unknown description, ErrorMsg: (null): SQL create table oxopen.GMT411.TEST</SPAN></P><P></P><P>I can load data from this Database, so the OLE DB - Connection must be ok.</P><P></P><P>The code snippet above works perfectly in QlikView, but not in Sense.</P><P></P><P>Can somebody explain this behaviour and have a workaround?</P></BODY></HTML> Mon, 13 Mar 2017 09:06:19 GMT Anonymous 2017-03-13T09:06:19Z Create SQL Table from QlikSense LoadScript https://community.qlik.com/t5/App-Development/Create-SQL-Table-from-QlikSense-LoadScript/m-p/1276942#M26488 <HTML><HEAD></HEAD><BODY><P>Hey folks,</P><P></P><P>I want to create a SQL table from QlikSense script.</P><P>Therefore I use the following syntax:</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_148939567468374" jivemacro_uid="_148939567468374"> <P>load *; SQL create table oxopen.GMT411.TEST;</P> </PRE><P></P><P>But I always receise the following error:</P><P><SPAN style="color: #ff0000; font-family: monospace; font-size: 13px;">ErrorSource: Unknown description, ErrorMsg: (null): SQL create table oxopen.GMT411.TEST</SPAN></P><P></P><P>I can load data from this Database, so the OLE DB - Connection must be ok.</P><P></P><P>The code snippet above works perfectly in QlikView, but not in Sense.</P><P></P><P>Can somebody explain this behaviour and have a workaround?</P></BODY></HTML> Mon, 13 Mar 2017 09:06:19 GMT https://community.qlik.com/t5/App-Development/Create-SQL-Table-from-QlikSense-LoadScript/m-p/1276942#M26488 Anonymous 2017-03-13T09:06:19Z Re: Create SQL Table from QlikSense LoadScript https://community.qlik.com/t5/App-Development/Create-SQL-Table-from-QlikSense-LoadScript/m-p/1276943#M26489 <HTML><HEAD></HEAD><BODY><P>Maybe you'll get more feedback quicker if you ask this question in a Qlik Sense forum?</P><P></P><P>See here: <A href="https://community.qlik.com/thread/61072">QlikCommunity Tip: How to move your discussion thread</A></P></BODY></HTML> Mon, 13 Mar 2017 09:19:49 GMT https://community.qlik.com/t5/App-Development/Create-SQL-Table-from-QlikSense-LoadScript/m-p/1276943#M26489 Peter_Cammaert 2017-03-13T09:19:49Z