Search found 5 matches

by barsssk
6 years ago
Forum: Syntax
Topic: Change Working Directory of GAMS
Replies: 1
Views: 5473

Change Working Directory of GAMS

Hello all,

Is it possible to change working directory that GAMS puts all those .gdx, .txt, .lst files by default ?

Thanks
by barsssk
6 years ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 11
Views: 10112

Re: CSV Input Using SQL2GMS

I found the solution :) For those having the same problem, here it is: $onecho > %commandfile1% c=Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=E:MyPath\MyData\; Q1=select distinct PRODUCTCODE from [PerformanceGamsSourceConstraints.csv] s1=product X=GamsTest.gdx $offecho $call =sql2gms @%command...
by barsssk
6 years ago
Forum: Syntax
Topic: CSV Input Using SQL2GMS
Replies: 11
Views: 10112

CSV Input Using SQL2GMS

Hello everyone. I have used SQL2GMS tool to import data from SQL, Oracle or XLS. Now I need to import csv with this tool because row limit of xls is not enough. Here is a simple example from my code to import xls: $onecho > %commandfile1% c=DRIVER=Microsoft Excel Driver (*.xls);dbq=%filename%StoreDi...
by barsssk
6 years ago
Forum: Syntax
Topic: If-Else Statement (Not $ sign)
Replies: 2
Views: 6255

Re: If-Else Statement (Not $ sign)

Renger wrote: 6 years ago Hi barssk

Take a look at the documentation https://www.gams.com/24.8/docs/userguid ... seif_2.htm

Cheers
Renger
Thank you very much Renger. No idea why I couldnt find this before :)
by barsssk
6 years ago
Forum: Syntax
Topic: If-Else Statement (Not $ sign)
Replies: 2
Views: 6255

If-Else Statement (Not $ sign)

Hello everyone, I am aware of $ sign, but in my knowledge it is used for conditional definitions of variables, equations, parameters and etc. What I want to do is that controlling a code block(solve statement in this case) as it can be basically done in every coding language. Here is an example: if(...