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

$callTool win32.msappavail Access
$if errorlevel 1 $abort.noError "No Access 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%';