The following example shows the use of the BY NAME phrase for deferred mode processing of large objects using BTEQ and BLOBs.
CREATE TABLE tabf2 ( i1 INTEGER, v1 VARCHAR(256)); INSERT INTO tabf2 (1, 'c:\temp\data.dat'); .SET INDICDATA ON .EXPORT INDICDATA FILE=scg0720.dat SELECT * FROM tabf; .EXPORT RESET CREATE TABLE tabb ( i1 INTEGER, c1 BLOB); .IMPORT INDICDATA FILE=scg0720.dat USING (a INTEGER, b BLOB AS DEFERRED BY NAME) INSERT INTO tabb (:a, :b);