Samples > Data load utility samples > Inventory samples
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_INSTALL\samples\DataLoad\Inventory\RA before load data under this directory.To add more records in radetail.csv, accordingly add records with same VendorName and CreateTime in WC_INSTALL\samples\DataLoad\Inventory\RA\ra.csv
Procedure
- Navigate to the appropriate directory:
- WC_INSTALL/bin
- WCDE_INSTALL\bin
- Enter the following command:
- ./dataload.sh ../samples/DataLoad/Inventory/RADetail/wc-dataload.xml
- dataload ..\samples\DataLoad\Inventory\RADetail\wc-dataload.xml
Verify 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;
Clean 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;