Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 21 Nov 2002 @ 19:09:43 GMT

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

Subj:   Re: Continuations in FastLoad
From:   Geoffrey Rommel

  Could you define it as two fields of 40 chars each and concatenate them?  

  I realise this a bit cumbersome.  

Good idea ... but alas, no.

          ,IN_STR_ADR_LN_1             (CHAR(40),NULLIF=
      '0000000000000000000000000000000000000000'XC )
          ,IN_STR_ADR_LN_2             (CHAR(40),
          ,IN_CITY                     (CHAR(20),
          ,IN_ST_CD                    (CHAR(02),NULLIF='0000'XC)
          ,IN_ALPHA_CNTRY_CD           (CHAR(03),NULLIF='000000'XC)


**** 14:00:53 DEFINE Syntax Error
**** 14:00:53 Missing ')' in definition for column: IN_STR_ADR_LN_1

  <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