Description

This example shows how to map index names if the names in the
database are different from the ones in the GAMS model.

This model is referenced in "Example 6 - Index Mapping" section "Index Mapping
done in GAMS" from the SQL2GMS Documentation.

Keywords: SQL2GMS, data exchange, GAMS language features

Category : GAMS Data Utilities library

Main file : IndexMapping3.gms   includes :  Sample.accdb  IndexMapping3.gms

$title SQL2GMS Example 6 - Index Mapping done in GAMS (IndexMapping3,SEQ=051)

$onText
This example shows how to map index names if the names in the
database are different from the ones in the GAMS model.

This model is referenced in "Example 6 - Index Mapping" section "Index Mapping
done in GAMS" from the SQL2GMS Documentation.

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

$callTool win32.msappavail Access
$if errorlevel 1 $abort.noError "No Access available"

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

Set idb 'from database' / 'new york', 'washington dc', 'los angeles', 'san francisco' /;

$call sql2gms C="DRIVER=Microsoft Access Driver (*.mdb, *.accdb);dbq=.\Sample.accdb" B O="city1.inc" Q="SELECT City, [Value] FROM [example table]" > %system.nullfile%
$ifE errorLevel<>0 $abort Error using SQL2GMS!

Parameter dbdata(idb) /
$include city1.inc
/;

Set mapindx(i,idb) / NY.'new york', DC.'washington dc', LA.'los angeles', SF.'san francisco' /;

Parameter data(i);
data(i) = sum(mapindx(i,idb), dbdata(idb));
display data;