GAMS [ Home | Support | Sales | Solvers | Documentation | Model Libraries | Search | Contact Us ]

Wiring : Use of wiring option to read multi-data column tables

Example of wiring option.

Instead of
   select prod,loc,year,'sales',sales from data
   union
   select prod,loc,year,'profit',profit from data

we use
   select prod,loc,year,sales,profit from data
   or
   select * from data
   Files:  Sample.mdb  Wiring.gms
$ontext Example of wiring option. Instead of select prod,loc,year,'sales',sales from data union select prod,loc,year,'profit',profit from data we use select prod,loc,year,sales,profit from data or select * from data $offtext sets y 'years' /1997*1998/ loc 'locations' /nyc,was,la,sfo/ prd 'products' /hardware, software/ q 'quantities' /sales, profit/ ; $onecho > cmd.txt I=Sample.mdb Q=select * from data O=x.inc W=i1|i2|i3|v4='sales'|v4='profit' $offecho $call =mdb2gms @cmd.txt parameter data(y,loc,prd,q) / $include x.inc /; display data;