ALLBASE/SQL Reference Manual (36216-90216)

242 Chapter8
Expressions
CAST Function
Assume there is only one row qualified for the following query.
EXEC SQL select PartNumber, CAST(UnitPrice,BINARY(8))
INTO :hostvar1, :hostvar2
FROM PurchDB.SupplyPrice
WHERE VendorNumber BETWEEN 9000 AND 9020;
6. You will see the DECIMAL constant shown as:
99.99
SELECT PartNumber, CAST(99.99,VARCHAR(10))
FROM PurchDB.SupplyPrice;