My code is the following:
Code: Select all
set Ik /Ik01, Ik02, Ik03/
R /R01 * R08/
Vt /Vt01,Vt02/;
$if %system.filesys% == UNIX $abort.no error 'The model cannot run on a non-Windows platform';
$onecho > fixedtextcmd.txt
C=DRIVER={Microsoft Text Driver {*.txt}}; DBQ=C:\Users\is\Documents\gamsdir\projdir\Data;
Q=select Ik,Vt,R,var1 from vand.txt
O=fixed.inc
$offecho
$call sql2gms @fixedtextcmd.txt > %system.nullfile%
parameter p1(Ik,R,Vt) /
$include fixed.inc
/;
display p1;
Please help me.
And if you have another solution or example how to include *.txt file (or *.dat file) into GAMS it would be very helpful.
Best
Irena
My vand.txt file is attached.