Deleting order objects

To delete order objects:

  1. Type the following:
    • DB2
      • AIXi5/OSiSeriesSun Solaris Operating EnvironmentLinux./dbclean.sh -object order -type typename -instancexml instancename -db dbname -dbuser user -days daysold -loglevel loglevel
      • Windowsdbclean -object order -type typename -instancexml instancename -db dbname -days daysold -loglevel loglevel
    • Oracle
      • AIXSun Solaris Operating Environment./dbclean.sh -object order -type typename -instancexml instancename -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
      • Windowsdbclean -object order -instancexml instancename -type typename -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password

      Use host:port:sid for the Oracle database name. For example, myhost:1521:mydb.

    Note: For the -type parameter, you can specify one of seven different types: completed to indicate a completed order, canceled to indicate a canceled order, shipped to indicate a shipped order, deposited to indicate an order which has been deposited, stale_guest to indicate stale orders from guest customers, stale_non_guest to indicate stale orders by customers who are not guests, or markfordelete to indicate a requisition list or an order item that needs to be deleted.

  2. Examine the dbclean_yyyy.mm.dd_hh.mm.ss.zzz.log file.

Feedback