Ispirer Website
Ispirer Toolkit Overview
Free Trial
You can use environment variables to specify the SERVIŠ”E, PASSWORD and USER for the whole run in sqlways_all.bat. But first you need to specify those environment variables in the SQLWays, so that it used them in all the bat files with the commands, like:
The Password is specified as %PASSWORD% here.
So, as the result you will have bat files for data and ddl loading with the commands like, e.g. for Oracle:
sqlplus %USER%/%PASSWORD%@%SERVICE% @calendar_ddl.sql
All the bat files are run using the sqlways_all.bat file with the command like:
sqlways_imp.exe /bat=sqlways_all.bat
So, all that is left to do is to update the sqlways_all.bat file with the following SET commands before the CALL statements:
set USER=ora set PASSWORD=pass set SERVICE=ora
As the result the SQLPLUS command will be executed as follows:
sqlplus ora/pass@ora @calendar_ddl.sql
So, changing just three values in the sqlways_all.bat file, you can control which user, password and service name must be used for the whole load.