ALLBASE/SQL Reference Manual (36216-90216)

252 Chapter8
Expressions
Long Column Functions
Examples
1. 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
2. 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'