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:

• Use 1 - 10 characters. Start with a letter, then use any combination of letters, numbers, and underscores (_). Press Enter to save the file.
• UNIX™: File names are case-sensitive. The file orders is not the same as Orders or ORDERS.

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.