returns an integer value indicating the output device type stored in
the long column descriptor for LongColumnName.
The values returned are shown in the table below:
Value Returned
Output Device Type
0
none specified
1
system file
3
heap space
OUTPUT_NAME
returns the output device name stored in the long column descriptor
for LongColumnName. The string returned is a 44 byte value.
LongColumnName
is the name of the column that has a long data type (LONG BINARY or
LONG VARBINARY).
Description
The long column functions can appear in the select list
or search condition of an SQL data manipulation statement.
The long column functions are useful when you need information about the
long column descriptors, but do not want to fetch the data.
For more information on long column data types, see the "Data Types"
chapter.
Referencing a LONG column in a LONG column function does not cause
the LONG data to be written out to the output device.
Examples
OUTPUT_DEVICE example
Change the PartPicture output device name to NewHammer in any row whose output device type for PartPicture is a system file.
UPDATE PartsIllus
SET PartPicture = '> NewHammer'
WHERE OUTPUT_DEVICE(PartPicture) = 1
OUTPUT_NAME example
Select the output device name of the PartPicture column for any row with a PartNumber of 100.
SELECT OUTPUT_NAME(PartPicture)
FROM PartsIllus
WHERE PartNumber = 100
Change all occurrences of the output device name of the PartPicture column to NewHammer if the current output device name is Hammer.
UPDATE PartsIllus
SET PartPicture = '> NewHammer'
WHERE OUTPUT_NAME(PartPicture) = 'Hammer'