IMPORT loads QUERY commands to be stored from a host file.
Such a file can be generated using an EXPORT command, but it can also be created by the user himself. The structure of this file is illustrated by the example given below.
Example
IMPORT command.fil
File Structure
1. Each command starts with a heading. Such a heading begins with the keyword COMMAND followed by the command name. At the same time, these headings separate the individual commands from each other.
2. Call privileges for other users may be inserted at the end of the file. These call privileges must be specified in the form of GRANT commands (see chapter GRANT Command) and must be separated from the commands to be stored by a line containing the keyword USERPRIV.
Example
COMMAND customer1
SELECT * from customer
REPORT
GROUP account
WID 1 10
COMMAND customer2
SELECT account from customer
REPORT
TOT account
USERPRIV
GRANT customer1 to Miller
GRANT customer2 to Smith