HPlogo ALLBASE/SQL C Application Programming Guide: HP 3000 MPE/iX Computer Systems > Chapter 10 Programming with LONG Columns

Restrictions

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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.

Feedback to webmaster