Enabling and disabling the RFQ trading mechanism (Business Edition)

Before you can use the RFQ trading mechanism, the Site Administrator must enable RFQs using SQL scripts that can be found in the WC directory created as part of the WebSphere Commerce installation process.

There are two SQL scripts used:

wcs.enable_rfq.sql
Use this SQL script to enable RFQs in WebSphere Commerce
wcs.disable_rfq.sql
Use this SQL script to disable RFQs in WebSphere Commerce

The SQL scripts are specific to the type of database used with WebSphere Commerce and can be found in the following directories:

DB2
i5/OSiSeriesAIXLinuxSun Solaris Operating EnvironmentWC_installdir/schema/db2
WindowsWC_installdir\schema\db2
Oracle
AIXSun Solaris Operating EnvironmentWC_installdir/schema/oracle
WindowsWC_installdir\schema\oracle

To enable RFQs:

  1. Log on to the WebSphere Commerce database created during installation.
  2. Enable RFQs using the wcs.enable_rfq.sql script for the database you are using with WebSphere Commerce. For example, if you are using DB2, issue the following command: db2 -tvf wcs.enable_rfq.sql.
    i5/OSiSeries Use iSeries Navigator (by installing IBM iSeries Access for Windows) to run the SQL script.
  3. Enable RFQ notification messaging.
  4. Changing the frequency with which the scheduler performs commands relating to RFQ can be done through the Scheduler.
  5. If you intend to use WebSphere Commerce Payments in conjunction with RFQ orders, it must be enabled in a separate process.

To disable RFQs:

  1. Log on to the WebSphere Commerce database created during installation.
  2. Disable RFQs using the wcs.disable_rfq.sql script for the database you are using with WebSphere Commerce. For example, if you are using DB2, issue the following command: db2 -tvf wcs.disable_rfq.sql.

Feedback