How can I replace standard stored procedure with a modified stored procedure when schema objects are created in a TPC-C benchmark?
For example, when Benchmark Factory creates an order for the TPC-C benchmark (c_order), it does not populate the time portion of the date when it assigns the entry date (c_order.o_entry_d.) For example, it only stores 12/01/2013 00:00:00 instead of 12/01/2013 10:15:34.
If there's a requirement to see the time portion of the date as well a modified version of the stored procedure (C_SP_New_Order) must be used so it assign the current date and time.
To have Benchmark Factory (BMF) use a customized procedure, do the following steps:
1. Create a batch file (.bat, file used to replace our built in procedure with your modified version).
2. In BMF, select "Create Objects for TPC-C" then launch Execute File Wizard by going to Wizards | Execute File.
3. Select the .bat file created in step 1, then BMF will automatically execute the .bat file while testing.
