Decision Optimization

 View Only

  • 1.  Batch Run

    Posted Thu June 01, 2017 08:00 AM

    Originally posted by: mikeabd


    Hello Team,

     

    I have a question regarding batch running and main block. I have a data table with a column lets say Store #. I wanna solve MIPs interactively. I want CPLEX to fetch to the database and read 1 store at a time and solve the MIP and store the results back to another table in database.

     

    Can anyone of you guys guide with an example ? Like how do I loop through all the stores in my database and solve them 1 at a time ?

     

    Thanks

    Mike


    #CPLEXOptimizers
    #DecisionOptimization


  • 2.  Re: Batch Run

    Posted Thu June 01, 2017 08:51 AM

    Hi,

    in which language ?  In OPL , C++, JAVA ?

    regards


    #CPLEXOptimizers
    #DecisionOptimization


  • 3.  Re: Batch Run

    Posted Thu June 01, 2017 08:54 AM

    Originally posted by: mikeabd


    Its in OPL and I'm using 12.6.3

     

     


    #CPLEXOptimizers
    #DecisionOptimization


  • 4.  Re: Batch Run

    Posted Thu June 01, 2017 09:27 AM

    HI,

    could

    https://www.ibm.com/developerworks/community/forums/html/topic?id=e3987f3a-9c07-4a0a-b281-720cbec45080&ps=25

    help ?

    This explains how to do that with Excel sheets.

    But the you could do the same with DBRead with OPL in CPLEX 12.6.3

    regards


    #CPLEXOptimizers
    #DecisionOptimization