Wednesday, March 5, 2014

Create / Drop table in PeopleCode

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 ....");