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.csvProcedure
- Go to the appropriate directory:
- WC_installdir/bin
- WCDE_installdir\bin
- Enter the following command:
- ./dataload.sh ../samples/DataLoad/Inventory/RADetail/wc-dataload.xml
- dataload ..\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;