If you need to run the same dynamic SQL statement more than once per job use the PREPARE – EXECUTE statements using EXECUTE IMMEDIATE incurs…

EXECUTE IMMEDIATE is simple option to execute a Dynamic SQL. Here is an example TableName = ‘CUSTOMER’; SQLString = ‘DELETE FROM ‘+ %TRIM(TableName) ; EXECUTE…

There are two ways to write SQL one is Static SQL which get job done in most case and second one is Dynamic SQL for…