Hello all,
Is it possible to change working directory that GAMS puts all those .gdx, .txt, .lst files by default ?
Thanks
Search found 5 matches
- 6 years ago
- Forum: Syntax
- Topic: Change Working Directory of GAMS
- Replies: 1
- Views: 5605
- 6 years ago
- Forum: Syntax
- Topic: CSV Input Using SQL2GMS
- Replies: 11
- Views: 10545
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...
- 6 years ago
- Forum: Syntax
- Topic: CSV Input Using SQL2GMS
- Replies: 11
- Views: 10545
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...
- 6 years ago
- Forum: Syntax
- Topic: If-Else Statement (Not $ sign)
- Replies: 2
- Views: 6308
Re: If-Else Statement (Not $ sign)
Thank you very much Renger. No idea why I couldnt find this beforeRenger 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
- 6 years ago
- Forum: Syntax
- Topic: If-Else Statement (Not $ sign)
- Replies: 2
- Views: 6308
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(...