Save the current SQL statement

You can save SQL statements in a file for later use, such as to run the statements from the command line or retrieve the saved statements with the Choose option on the SQL menu.

To save the current SQL statement or statements in a file, select the Save option on the SQL menu. Enter a name for the command file:

DB-Access appends the extension .sql to the file name. For example, if you name your file cust1, DB-Access stores the file with the name cust1.sql. The CHOOSE screen still lists cust1, but the operating system identifies the same file as cust1.sql if you list the directory files from the command line.

Copyright© 2018 HCL Technologies Limited