Sample: Loading detailed information items on expected inventory records

This sample demonstrates how to load detailed information items on expected inventory records, the expected inventory records must already been loaded to RA table before this scenario.

About this sample

In this sample, load data under WC_installdir\samples\DataLoad\Inventory\RA before load data under this directory. If you want to add more records in radetail.csv, accordingly add records with same VendorName and CreateTime in WC_installdir\samples\DataLoad\Inventory\RA\ra.csv

Procedure

  1. Go to the appropriate directory:
    • WC_installdir/bin
    • WebSphere Commerce DeveloperWCDE_installdir\bin
  2. Enter the following command:
    • LinuxAIX./dataload.sh ../samples/DataLoad/Inventory/RADetail/wc-dataload.xml
    • WebSphere Commerce DeveloperWindowsdataload ..\samples\DataLoad\Inventory\RADetail\wc-dataload.xml

Verifying the results

Run the following SQL statements:
select * from RADETAIL where RADETAIL_ID >= $startKey and RADETAIL_ID < $endKey;
The $startKey and $endKey are set in samples\DataLoad\Inventory\RADetail\wc-dataload.xml

For example, select * from RADETAIL where RADETAIL_ID >= 100000001 and RADETAIL_ID < 200000000;

Cleaning up the data

To clean up the data loaded in the database, run the following SQL statement:
delete from RADETAIL where RADETAIL_ID >= $startKey and RADETAIL_ID < $endKey;