1  DATATRIEVE
   Optional SQL and DATATRIEVE formatting clauses allow you to
   modify data displays or query characteristics for interactive SQL
   users, DATATRIEVE users, or both. The optional formatting clauses
   (QUERY NAME and EDIT STRING) and DATATRIEVE clauses (QUERY HEADER
   and DEFAULT VALUE) can be used with the following statements:

   o  CREATE TABLE

   o  CREATE DOMAIN

   o  CREATE VIEW

   o  ALTER TABLE

   o  ALTER DOMAIN

   The following diagram shows the format for these clauses:

 sql-and-dtr-clause =
 
 -+-> QUERY HEADER IS -+> <quoted-string> +-------------------+->
  |                    +------ / <--------+                   |
  +-> EDIT STRING IS <quoted-string> -------------------------+
  |                                                           |
  +-> QUERY NAME FOR -+-> DTR --------+-> IS <quoted-string> -+
  |                   +-> DATATRIEVE -+                       |
  +-> DEFAULT VALUE FOR -+-> DTR --------+-> IS literal   ----+
                         +-> DATATRIEVE -+
 

   o  A query header specifies a string, enclosed in quotation
      marks, that interactive SQL or DATATRIEVE displays in place
      of the column name when it retrieves values from a column.
      Query headers allow you to specify descriptive headings for
      columns.

      Both interactive SQL and DATATRIEVE display any query headers
      you specify in SQL definitions.

   o  An edit string specifies a string, enclosed in quotation
      marks, that controls how interactive SQL or DATATRIEVE formats
      the display of values in a column.

      Both interactive SQL and DATATRIEVE use edit strings you
      specify in SQL definitions to control display formatting for
      those definitions.

      DATATRIEVE recognizes columns with null values and displays
      them according to the edit string for the missing value.

   o  A query name specifies a string, enclosed in quotation marks,
      that you can use instead of the column name when formulating
      DATATRIEVE queries. Query names are useful for abbreviating
      long column names in DATATRIEVE queries.

      SQL does not recognize query names in interactive queries; the
      QUERY NAME clause is useful only when you use DATATRIEVE to
      retrieve the data.

   o  If you specify a default value for a column and do not specify
      that column in a DATATRIEVE STORE or MODIFY statement,
      DATATRIEVE stores the default value specified in the SQL
      definition.

      SQL does not recognize default values in INSERT or UPDATE
      statements; the DEFAULT VALUE clause is useful only when you
      use DATATRIEVE STORE or MODIFY statements.
 

2  QUERY_HEADER_Clause
   The QUERY HEADER clause specifies the column header that SQL uses
   in displays of result tables that contain that column.

   If you include the QUERY HEADER clause, SQL uses the query header
   as the column header. If you omit the clause, SQL uses the column
   name as the column header.

   The column header can include any character except a carriage
   return, a line feed, or a control character. To include a double
   quotation mark in a column header, enclose it in single quotation
   marks.

   The following example defines a query header for one column and a
   DATATRIEVE query name for another column:

   SQL> ALTER TABLE TEMP
   cont>      ADD STATE CHAR (2)
   cont>         QUERY NAME FOR DATATRIEVE IS 'ST'
   cont>      ADD SEX CHAR (1)
   cont>         QUERY HEADER IS 'S'/'E'/'X';

   These statements define query headers and query names for the
   STATE and SEX columns. The slash character (/)  specifies that
   the header is split into three lines, so the header for the SEX
   column is 1 character wide, like the column itself.

   Both SQL and DATATRIEVE display the query header used in this
   example. Only DATATRIEVE recognizes the query name.
 

2  EDIT_STRING_Clause
   The EDIT STRING clause specifies the output format of a column
   value. SQL uses the EDIT STRING clause as the default format when
   writing a column value to a file or output device.

   To specify the format of a column value, use a string of one
   or more edit characters. Specify the edit string characters
   in single quotation marks without embedded spaces. In general,
   each edit character corresponds to 1 character position in the
   displayed output. For example, 999999 specifies that the output
   is 6 digits in 6 character positions.

   To enter more of the same edit characters, shorten the edit
   string by placing a repeat count in parentheses following the
   edit character. For example, the edit string 9(6) is equal to
   999999.

   You can change the character that SQL and DATATRIEVE display for
   the currency symbol ($),  decimal point (.), and digit separator
   (,)  edit string characters.

   To make your output conform to other conventions for numeric and
   monetary notation, override the system defaults for these symbols
   by redefining the following logical names:

   o  SYS$CURRENCY: Specifies the character SQL substitutes for
      the dollar sign ($)  edit string character. The default is a
      dollar sign.

   o  SYS$RADIX_POINT: Specifies the character SQL substitutes for
      the decimal point (.)  edit string character. The default is a
      decimal point.

   o  SYS$DIGIT_SEP: Specifies the character SQL substitutes for the
      comma (,)  edit string character. The default is a comma.