ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 583
SQL Statements S - Z
UPDATE
>> specifies that output is appended to the following file name. If the file does
not exist, it is created.
>! specifies that output is placed in the following file name. If the file already
exists, it is overwritten.
>%
SharedMemoryAddress is the shared memory address where the output is placed.
>%$ is the shared memory address, determined by ALLBASE/SQL, where the
output is placed.
$ is the wildcard character that represents a random, five-byte
alphanumeric character string generated by ALLBASE/SQL. This is a file
name.
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
Table 12-2. 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