SQL Clean process documentation

Some examples running with Control-M and Control-EM database.
Post Reply
User avatar
th_alejandro
Nouveau
Nouveau
Posts: 188
Joined: 26 Nov 2008 12:00
Location: Bogotá

SQL Clean process documentation

Post by th_alejandro » 09 Aug 2009 6:41

In many many forum i read about different clean process that is executed to execute via SQL directly on the CTM database. But i want to 'organize' a list of all 'clean process'. Make your appoints as follows:

Example :

To clean message alerts
DELETE FROM ....

To clean old jobs .... what ever....
DELETE FROM ...

To update jobs. ...
UPDATE ....

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 12 Aug 2009 2:24

there is a lot of command like this,but be carefull with API MAJ PROCESS
that can not be taken only by a insert or delete .......


regards
philmalmaison

User avatar
sjjoseph
Nouveau
Nouveau
Posts: 3
Joined: 12 Jan 2010 12:00

Post by sjjoseph » 12 Jan 2010 7:49

Hi all,
Thanks for all this information. But i want to know that if I want to remove only records from the table not columns. Then What i have to do?
Drop is the command for deleting the table.
Thanks in advance.

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 13 Jan 2010 10:09

so use the
delete from <table> where <what>
go


regards
philmalmaison

Post Reply