Create Table MySQL in Qlikview

[tjardine99]

How can I CREATE TABLE for MySQL within QLikview?

ODBC CONNECT TO 'XXXXX';
SQL

CREATE TABLE `temp_trans`......

[ckarras22]

Hello,

The way you try is not a valid Qlik statement. Instead, try to create a store procedure and call it from your script:

>>>>>>>>>>>>>>>>>>>Load script

Load
1 as Scc
;
sql exec sp_crt_tbl
;

>>>>>>>>>>>>>>store procedure

CREATE PROCEDURE [dbo].[sp_crt_tbl]
AS

CREATE TABLE terty.dbo.test_table1 (column11 INT, column12 varchar(20));

BR

Christos K.