/*********************************************
 * OPL 5.0 Data
 * Author: Igor
 * Creation Date: 2/22/2007 at 5:16 PM
 *********************************************/

DBconnection db("odbc","DRIVER={Microsoft Access Driver (*.mdb)};DBQ=WARP2006W Condensed.mdb//");
//provide the address of the database

Shoes from DBread(db,"SELECT Product_Num FROM Product_Master");
Machines from DBread(db,"SELECT Machine_Num FROM Machine_Master");

MarInv from DBread(db,"SELECT * FROM InventoryMar07");
AprDemand from DBread(db,"SELECT * FROM DemandAllStoresApr07");
MachineOpCosts from DBread(db, "SELECT * from MachineOpCosts");
RMCostPerShoe from DBread(db, "SELECT * from RMCostPerShoe");
warehouseData from DBRead (db, "SELECT Warehouse_Num, Capacity, Op_Cost FROM Warehouse_Master WHERE Warehouse_Num <> 7");

DBexecute(db,"drop table Result");
DBexecute(db,"create table Result(oil varchar(10), gas varchar(10), blend real, a real)");