SQLA is a simple and efficient tool that helps users with their daily work. With better configuration, this tool can be used effectively.
SQLA also provides a way for you to automate your queries from a Windows machine. This recipe won't be covering the full process, but here are some commands that you can use to automate the scripts/jobs.
To execute SQLA from the command prompt, use the following:
Enter the following command on Run:
Sqla -c cookbook -f "c:\workbook\dbc.sql” -e "c:\workbook\resultset\dbc.log"
- The -c cookbook is used to establish a connection to the cookbook server
- -f "c:\workbook\dbc.sql" opens a file in the given path directly to SQL Assistant
- -e "c:\workbook\resultset\dbc.log" is used to export the resultset ...
