About rajinfor

rajinfor · 22-05-2020

CREATE OR REPLACE SCRIPT view_load (tbl_schema, vw_schema, serv_schema) ASlocal success, res = pquery([[WITH TAB1 AS(select COLUMN_TABLE, ('V.'||COLUMN_NAME||' = T.'||COLUMN_NAME) AS PK,'V.'||COLUMN_NAME AS PK1, 'T.'||COLUMN_NAME AS PK2from ::s.EXA_A...

rajinfor · 26-05-2020

Please find the working code below, which will do Insert else Update for more than 200 tables and some of them are Full load (Truncate/Insert) from schemas in Exasol. Highlighted difference with Bold letters.CREATE OR REPLACE SCRIPT DM_PM_CRM_GLBL.vi...

rajinfor · 25-05-2020

You need to create a shell script with Exasol commands and can automate it via unix or 3rd party scheduler tools. If you have RPA tools, also can do the automation.

User Statistics

User Activity

Issue while using Merge statement in Lua script on Exasol

Re: Issue while using Merge statement in Lua script on Exasol

Re: How do I automate scripts?

New to the Exasol Community?