How to update db column in qlikview script

[qwebnm]

Dear Qlik Team,

Is it possible to update db columns in sql, postgresql from qlikview script?
If you can, is there a guide for this?

Please respond when possible.
thank you.

[Wanda6123 · Accepted solution]

Yes, it is possible to update database columns in SQL or PostgreSQL from QlikView script. QlikView supports the execution of SQL queries and statements through its script. You can use the 'SQL' prefix in your QlikView script to execute SQL commands.

SQL UPDATE your_table_name
SET column1 = 'new_BeBallPlayers_value'
WHERE condition;

Replace your_table_name, column1, new_value, and condition with your specific table name, column name, desired value, and the condition for updating. Remember to be cautious when updating data directly in a database, as it can have significant consequences. Always back up your data before making updates.