Archives of the TeradataForum

Message Posted: Thu, 23 Jun 2005 @ 16:03:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Here's a TPump approach using concatenation--this should work with BTEQ too -- this case used a custom 'directory sweep' access module for parallel/overlapped load of multiple lobs but can be simplified for single blobs via using a single session and file I/O rather than the axsmod (might require an inmod to adjust the data read to fit a binary varchar layout):

     .BEGIN LOAD ERRLIMIT 5000 SESSIONS 4
                 PACK 1
                 SERIALIZE ON
                 ERRORTABLE lob_et             ;
     .LAYOUT DATAIN_LAYOUT ;
       .FIELD      segseq                   *  INTEGER;
       .FIELD      name                     *  VARCHAR(255) key;
       .FIELD      IN_f_blob                *  VARBYTE(64000);
     .DML LABEL INSERT_DML;
     Update lobtbl
       Set theblob = theblob || :IN_f_blob
       Where lobname = :name
     ELSE
       INSERT INTO logtbl
           ( lobname   =  :name
            ,theblob   =  :IN_f_blob
           );

     .IMPORT INFILE whocares axsmod /home/rmh/lib/librblobs.so ' '

	<Prev	Next>		<<First	<Prev	Next>	Last>>