SQL$HELP72.HLB  —  Errors  SQL_ERRORS, INV_TBL_DCL
  Invalid use of declared local temporary table <str>

  Explanation:  A declared local temporary table my not be used in
  this context.  A scratch table defined using DECLARE LOCAL
  TEMPORARY TABLE may not be the target of an ALTER TABLE, or DROP
  TABLE statement.  In addition the declared name may not be
  referenced by base table constraint, a view definition or
  similar stored metadata object.  The DECLARE LOCAL TEMPORARY
  TABLE clause may only appear a SQL Module Language or
  Pre-compiler source as part of a CREATE MODULE statement.

  User Action:  Do not reference the scratch table name in a DDL
  statement or use the DECLARE LOCAL TEMPORARY TABLE in an
  unsupported context.
Close Help