ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 449
SQL Statements E - R
INSERT
• If the output device exists prior to a SELECT or FETCH command, in order for
ALLBASE/SQL to access it for append or overwrite, the above characteristics are
recommended.
• When no portion of the output device name is specified, the default file name, tmp$.LF,
is used. The wildcard character ($) indicates a random, five-byte, alphanumeric
character string. This file is created in the local directory.
• When you specify a portion of the output file name in conjunction with the wildcard
character ($), a five-byte, alphanumeric character string replaces the wildcard. The
wildcard character can appear in any position of the output device name
except the
first. The maximum file name being 14 bytes, you can specify 9 bytes of the device
name.
• The wildcard character, whether user specified or part of the default output device
name, is a unique five-byte, alphanumeric character string.
• When a file is used as the LONG column input or output device and you do not give it a
specific path name in the LONG column I/O string, the default is the path where ISQL
or your program is running.
• The output device cannot be overwritten with a SELECT or FETCH command unless you
use the INSERT or UPDATE command with the overwrite option.
• LONG columns cannot be used as follows:
— In a WHERE clause.
— In a type II 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.
Table 11-5. Default Output Device Characteristics
Device Type Permission UserID (uid) GroupID (gid)
OUTPUT create 700 Current user login id Current user login group
OUTPUT append 200 Current user login id Current user login group
OUTPUT overwrite 200 Current user login id Current user login group