//declare table varibale MyTable myTable; ttsbegin; // to delete all records with any condition delete_from myTable; or //delete records based on some condition delete_from myTable where mytable.Recid = 12345677; ttscommit;
//declare table varibale MyTable myTable; ttsbegin; // to delete all records with any condition delete_from myTable; or //delete records based on some condition delete_from myTable where mytable.Recid = 12345677; ttscommit;