Distances1 : Single-valued tables
Example of database access with MDB2GMS
The programs selects distances from database "sample.mdb"
and writes them to "distances.inc" or "distances.gdx" or both.
Note that at least one output file name has to be provided.
If no output file name is provided, the program starts to run
in interactive mode.
Files: Distances1.gms Sample.mdb
<![CDATA[
$ontext
Example of database access with MDB2GMS
The programs selects distances from database "sample.mdb"
and writes them to "distances.inc" or "distances.gdx" or both.
Note that at least one output file name has to be provided.
If no output file name is provided, the program starts to run
in interactive mode.
$offtext
$call =mdb2gms I=Sample.mdb Q="select city1,city2,distance from distances" O=distances.inc X=distances.gdx p=distances
* the following options can be used
* B: Quote blanks
* M: Mute
* L: No listing
*$call =mdb2gms I=Sample.mdb Q="select city1,city2,distance from distances" O=distances.inc X=distances.gdx p=distances B M L
* output could be produced seperately as follows:
*$call =mdb2gms I=Sample.mdb Q="select city1,city2,distance from distances" O=distances.inc
*$call =mdb2gms I=Sample.mdb Q="select city1,city2,distance from distances" X=distances.gdx p=distances
set i /seattle, san-diego/;
set j /new-york, chicago, topeka/;
parameter dist1(i,j) 'distances' /
$include distances.inc
/;
parameter dist2(i,j) 'distances';
$gdxin 'distances.gdx'
$load dist2=distances
$gdxin
display dist1, dist2;
]]></plaintext></body></div>