Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 22 Jun 1999 @ 05:33:46 GMT

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

Subj:   Re: String longer than 255 characters
From:   Duncan Heard


How about using a load utility rather than raw SQL - MultiLoad should do nicely (Granted, It would be better if you didn't have to do this...)

Just put the data you wish to load into a flat file, write a multiload script to do the insert/update and run it... If you are going to be doing this kind of thing often I really think this is the correct way to go (assuming you have a license for Multiload at your site.)

If you are new to multiload scripts I suggest you download inTeraScript - Jim Calvert's script building utility. This utility can generate the scripts from the table definition in the data dictionary and can save you a lot of time. With a small amount of fairly obvious editing the scripts should be able to do what you are after.

Otherwise use the cocatenated string workaround found below...



  <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