Tuesday, June 24, 2025

run sql in x++

 internal final class DXC_AutoSettlementDelete

{

    public static void deleteTemporaryTable()

    {

        str                             sql;

        Connection                      conn;

        SqlStatementExecutePermission   permission;


        sql = 'Truncate Table DXC_LedgerTransParsedTmp';

        

        permission = new SqlStatementExecutePermission(sql);

        conn = new Connection();

        permission = new SqlStatementExecutePermission(sql);

        

        permission.assert();

        conn.createStatement().executeUpdate(sql);

        CodeAccessPermission::revertAssert(); // the permissions needs to be reverted back to original condition.

    }


}