How to do?

Usage: sqla -t <DBMS type> OPTIONS from command line. Or startup from SQL*All - Windows GUI. Below lists the command line OPTIONS:

Short Long Description
-? --help Display help and exit.
-c --command Execute command after connected.
-d --database Database to use.
-f --file Execute script file after connected.
-h --host Connect to host
-p --password Password to use when connection to server or database.
-P --port Port number to use for connection. (Upper-case 'P')
  --prompt Set SQL*All prompt.
-t --type DBMS type.
-u --user User for login.

Notice: all parameters are case sensitive.

e.g.: sqla -tmssql -hlocalhost -P1433 -usa -p12345 -dpubs (or sqla --type=mssql --host=localhost --port=1433 --user=sa --password=12345 --database=pubs) meaning connect to MSSQL database pubs which located in localhost, listenning port is 1433 by user(sa) with password(12345).


Run Commands/SQL Script when startup

e.g.: sqla -tmssql -hlocalhost -P1433 -usa -p12345 -c "show databases;exit;", this command will show databases then exit immediately after connected to mssql.

e.g.: sqla -tmssql -hlocalhost -P1433 -usa -p12345 -f "c:\script.sql", this command will executes SQL script file "c:\script.sql" automation after connected to mssql.