Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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.