Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
tjardine99
Contributor
Contributor

Create Table MySQL in Qlikview

How can I CREATE TABLE for MySQL within QLikview?

ODBC CONNECT TO 'XXXXX';
SQL
CREATE TABLE `temp_trans`......
1 Reply
ckarras22
Partner - Creator
Partner - Creator

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.