ALLBASE/SQL Reference Manual (36216-90216)

448 Chapter11
SQL Statements E - R
INSERT
LongColumnIOString specifies the input and output locations for the LONG data. The
specification for this string is given below.
SQL Syntax — LongColumnIOString
<{[ PathName /] FileName
% SharedMemoryAddress }
[{>
>>
>!}[ PathName /]{ FileName
CharSting$
CharString$ CharString }
>%{ SharedMemoryAddress
$ }]
Parameters — LongColumnIOString
< [ PathName /] FileName is the location of the input file.
<%
SharedMemoryAddress is the shared memory address where the input is located.
> specifies that output is placed in the following file. If the file already exists,
it is not overwritten nor appended to, and an error is generated.
>> 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
command, 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 command, is created
with the following characteristics.