You can query a script to display information about the script. You can specify wildcard characters to display all scripts with names that match a particular pattern. When you query a script, you can direct the output to a file in a file system that the server can access.
| Format | Description |
|---|---|
| Standard | Displays the script name and description. This is the default. |
| Detailed | Displays commands in the script and their line numbers, date of last update, and update administrator for each command line in the script. |
| Lines | Displays the name of the script, the line numbers of the commands, comment lines, and the commands. |
| File | Outputs only the commands contained in the script without all other attributes. You can use this format to direct the script to a file so that it can be loaded into another server with the DEFINE script command specifying the FILE= parameter. |
query script *
The command gives results like
the following:
Name Description
--------------- ------------------------------------------------------
QCOLS Display columns for a specified SQL table
QSAMPLE Sample SQL Query
For more information about querying a server script, refer
to Administrator's Reference.