Create Table MySQL in Qlikview

tjardine99 — Mon, 26 Nov 2018 23:13:53 GMT

How can I CREATE TABLE for MySQL within QLikview?

ODBC CONNECT TO 'XXXXX';
SQL

CREATE TABLE `temp_trans`......

Re: Create Table MySQL in Qlikview

ckarras22 — Wed, 28 Nov 2018 15:59:01 GMT

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));

Christos K.