There are instances where we need to create and drop the table dynamically using PeopleCode / AE.
In sqr we have on-error if there are any issues in creating a table.
In the same way for PeopleCode we can use try..catch block.
Example:
try
sqlexec("Drop table PS_XXXX");
catch (exception e)
Rem ignore exception;
End-try;
sqlexec("Create table PS_XXX ....");
In sqr we have on-error if there are any issues in creating a table.
In the same way for PeopleCode we can use try..catch block.
Example:
try
sqlexec("Drop table PS_XXXX");
catch (exception e)
Rem ignore exception;
End-try;
sqlexec("Create table PS_XXX ....");