Activating or Deactivating SQL Commands Manually

Use this procedure to activate or deactivate individual zero-row SQL commands by editing the SQL file.

To activate or deactivate a command by editing an SQL file

  1. Save a copy of the SQL file to a new name.

  2. Open the .sql file (not the copy) and locate the desired SQL command.

    Commands begin Run_SQL_#, for example Run_SQL_100.

  3. Edit the command as follows:

    • To activate the command, delete the element (Execute=N)

    • To deactivate a command, add the element (Execute=N)

      Insert the element on a line by itself after Run_SQL_# =.

  4. Save the file.

Related Topic

About Tuning Siebel Production Upgrade Files