Enabling and disabling the RFQ trading mechanism

Before 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.

About this task 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:

• WC_installdir/schema/db2

• WC_installdir\schema\db2

• WC_installdir/schema/oracle

• WC_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.

   • Use iSeries Navigator (by installing IBM iSeries Access for Windows) to run the SQL script.

3. Enable RFQ notification messaging.
   
   

4. Change the frequency with which the scheduler performs commands relating to RFQ can be done through the Scheduler.

Results

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.

Related concepts

Request for Quote (RFQ)

RFQ response - - -