SqlDbx Forum

tommymim

Member

cmd export = file filename or $(filename)

Hello,

Is it possible to use this script command:
cmd export = file filename

but declare filename as a variable?
or is it possible to change working directory in the script?

For example I would like to make this code working:

$DEFINE var_filename 'c:\sqltest.csv'

cmd export = file $(var_filename)

Currently it exports results to the file $(var_filename) and not to the desired file: c:\sqltest.csv

Or the alternative would be to modify working folder with the script where results are stored.

Thank you in advance for your suggestions.

All the best,
Tommy

sqldbxhelp

Administrator

Re: cmd export = file filename or $(filename)

Currently it's not possible use variable as a file name for export.
I am not sure I understand how this is related to "modify working folder"