Example: Run a command file

This example shows how to start DB-Access and run a command file that contains SQL statements.

The following sample command runs the SQL statements in a file named sel_stock.sql on the mystores database:
dbaccess mystores sel_stock
The following sample command runs the SQL statements in the sel_all.sql file on the database that file specifies:
dbaccess - sel_all.sql

Some operating systems require that you have execute permissions to run SQL command files, read permissions to open these files or their contents in DB-Access, or write permissions to save modified or new files.

Use the UNIX chmod command to enable execution of the SQL files that the initialization script installed.


Copyright© 2018 HCL Technologies Limited