Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Updating a CLOB column
 
From:   Bob Hahn

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023