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 utilities_root\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 utilities_root\samples\DataLoad\Inventory\RA\ra.csv

Procedure

1. (Developer) On a command line, go to the WCDE_installdir\bin directory.

2. (Linux) Open a command line in the Utility server Docker container. Change the directory to utilities_root/bin directory.
   For information about entering and leaving containers, see Running utilities from the Utility server Docker container.

3. Enter the following command:

   • (Linux) ./dataload.sh ../samples/DataLoad/Inventory/RADetail/wc-dataload.xml

   • (Developer) 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;