ALLBASE/SQL Reference Manual (36216-90216)

590 Chapter12
SQL Statements S - Z
UPDATE WHERE CURRENT
Description — LongColumnIOString
• The input device must have a permission allowing the login user to access it. For
example, if the file belongs to the login user, permission must be at least 400. If the file
belongs to another user, in a different group, permission must be at least 004.
• When an output device has been specified and it exists prior to a SELECT or FETCH
statement, ALLBASE/SQL does not change the file's owner or permission.
• The output device, if it does not exist prior to a SELECT or FETCH statement, is created
with the following characteristics.
• If the output device exists prior to a SELECT or FETCH statement, in order for
ALLBASE/SQL to access it for append or overwrite, the above characteristics are
recommended.
• 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.
• 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.
• 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 statement unless you
use the INSERT or UPDATE statement with the overwrite option.
• LONG columns cannot be used as follows:
• In a WHERE clause.
• In a type II INSERT statement.
• Remotely through ALLBASE/NET.
• As hash or B-tree index key columns.
• In a GROUP BY, ORDER BY, DISTINCT, or UNION clause.
Table 12-3. 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