IndexMapping2.gms : MDB2GMS Example 6 - Index mapping done in Database

Description

This example shows how to map index names if the names in the
database are different from the ones in the GAMS model.
In this case all mapping is handled inside the database.

This model is referenced in "Example 6 - Index Mapping" section "Index mapping
done in Database" from the MDB2GMS Documentation.

Keywords: MDB2GMS, data exchange, GAMS language features


Category : GAMS Data Utilities library


Main file : IndexMapping2.gms   includes :  Sample.mdb  IndexMapping2.gms

$title MDB2GMS Example 6 - Index mapping done in Database (IndexMapping2,SEQ=039)

$onText
This example shows how to map index names if the names in the
database are different from the ones in the GAMS model.
In this case all mapping is handled inside the database.

This model is referenced in "Example 6 - Index Mapping" section "Index mapping
done in Database" from the MDB2GMS Documentation.

Keywords: MDB2GMS, data exchange, GAMS language features
$offText

$if %system.filesys% == UNIX $abort.noError 'This model cannot run on a non-Windows platform';
$call msappavail -Access
$ifE errorlevel<>0 $abort.noError 'Microsoft Access is not available!';

Set i / NY, DC, LA, SF /;

$onEcho > howToRead.txt
I=Sample.mdb
Q=SELECT [GAMS City], [value] FROM [example table], CityMapper WHERE CityMapper.[Access City]=[example table].city
O=city2.inc
$offEcho

$call mdb2gms @howToRead.txt > %system.nullfile%
$ifE errorLevel<>0 $abort Error using MDB2GMS!

Parameter data(i)/
$include city2.inc
/;
display data;