Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
AM2
Contributor II
Contributor II

LIB CONNECT TO in Read/Write mode

Hi,

in qlikview i have

ODBC CONNECT TO Vertica (XUserId is QeLRRWFMObYSGXFNWD, XPassword is ETZBFYAHRRMADYUNAScA,mode is write);

SQL
CREATE LOCAL TEMP TABLE temp_table1 ON COMMIT PRESERVE ROWS
as .......

How to Replay the Read/Write function in Qlik Sense LIB CONNECT TO  ?

Labels (1)
2 Replies
mpc
Partner - Specialist
Partner - Specialist

Hi, 

By using the Lib Connect To, the settings used is the one configured in the ODBC driver. 
Then, in my memories, the ODBC driver has a "read-only" option to uncheck.

You can check if the account used to query the Database has write privilege too. 

And then you can execute a query like that: 
SQL:
Insert into myTable values ('A','B','C'); 

Kind regards 

From Next Decision and me with love
This answer help you ? Like it ! Problem solved ? Mark it !
AM2
Contributor II
Contributor II
Author

Hi, tanks.

ODBC has already "read-only" unchecked

DB Vertica schema xxxxxxxxxx has write privilege.

Error is not possible in transaction in read only mode.