HP 3000 Manuals

ALLBASE/SQL FORTRAN Application Programming Guide

Restrictions 

A LONG column can be referenced in a select list and/or a host variable
declaration.  Some restrictions do apply to LONG columns.  However,
related standard columns are not affected by these restrictions.

LONG columns cannot be used as follows:

   *   In a WHERE clause.
   *   In a type 2 INSERT command.
   *   Remotely through ALLBASE/NET.
   *   As hash or B-tree index key columns.
   *   In a GROUP BY, ORDER BY, DISTINCT, or UNION clause.
   *   In an expression.
   *   In a subquery.
   *   In aggregate functions (AVG, SUM, MIN, MAX).
   *   As columns to which integrity constraints are assigned.
   *   With the DEFAULT option of the CREATE or ALTER TABLE commands.

MPE/iX 5.0 Documentation