GDX2ACCESSExample3.gms : Dumping a large Table to Database

Description

This example demonstrates how to dump a large symbol with a million elements to
an Access database file.

This model is referenced in the "Dumping a large Table to Database" example from
the GDX2ACCESS Documentation.

Keywords: GDX2ACCESS, data exchange, GAMS language features


Category : GAMS Data Utilities library


Main file : GDX2ACCESSExample3.gms   includes :  GDX2ACCESSExample3.gms

$title Dumping a large Table to Database (GDX2ACCESSExample3,SEQ=127)

$onText
This example demonstrates how to dump a large symbol with a million elements to
an Access database file.

This model is referenced in the "Dumping a large Table to Database" example from
the GDX2ACCESS Documentation.

Keywords: GDX2ACCESS, 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 / i1*i1000 /;
Alias (i,j);
Parameter p(i,j);
p(i,j) = uniform(-100,100);

execute_unload 'example3.gdx', p;
execute 'gdx2access example3.gdx > %system.nullfile%';