Stephen Lappin
asked on
Pass parameters to/between SQL scripts with Firebird ISQL
How can I pass parameters to/between SQL scripts with Firebird Ā (v1.5) ISQL?
For example, I have a generic script to create a new database, with all the objects and standing data I requrie. but I want to be able to pass in paramers such as DB File Name, User, Password etc.
For example, I have a generic script to create a new database, with all the objects and standing data I requrie. but I want to be able to pass in paramers such as DB File Name, User, Password etc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
in that case I'm not sure what you mean, the isql command-line tool takes parameters (dbpath, username, etc).
isql localhost:c:/db/mydb -user myname ........
it also has a -i option to get it's instructions (create, etc) from a named file
isql localhost:c:/db/mydb -user myname ........
it also has a -i option to get it's instructions (create, etc) from a named file
ASKER
The answer is that ISQL does not offer a facility to pass parameters, but the methos described by NickUpson is a workable workaround.
ASKER
The example you provide is not passing parameters, but generating a script with the appropriate values included. Is it not possible to pass parameters in Firebird ISQL?