Archives of the TeradataForum

Message Posted: Thu, 08 Jun 2006 @ 09:47:09 GMT

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

Can anyone tell me how to solve the following error that I've encountered while fastloading?

     0006 create set table lanxu_t_sr10149_cons
          (acct_num decimal(17,0)
          ,enrollment_dt date
          ,redeemer_yn char(1)
          ,bonus_yn char(1)
          ,feeseg_maritz char(2)
          ,channel varchar(12)
          ,deenrollment_dt date)
          primary index (acct_num);

     **** 22:50:09 Command completed successfully


     0007 SET RECORD VARTEXT ",";

     **** 22:50:09 Now set to read 'Variable-Length Text' records
     **** 22:50:09 Delimiter character is set to ','
     **** 22:50:09 Command completed successfully


     0008 define acct_num(varchar(11))
            ,enrollment_dt(varchar(9))
            ,redeemer_yn(varchar(2))
            ,bonus_yn(varchar(2))
            ,feeseg_maritz(varchar(3))
            ,channel(varchar(13))
            ,deenrollment_dt(varchar(10))
            file=Consumer_Maritz_deenrollment.txt;

     **** 22:50:09 FDL4803 DEFINE statement processed

          -----------------------------------------------------
          -                                                   -
          -          Insert Phase                             -
          -                                                   -
          -----------------------------------------------------

     0012 insert into lanxu_t_sr10149_cons values
          (:acct_num
          ,:enrollment_dt (date, format 'mmddyyyy')
          ,:redeemer_yn
          ,:bonus_yn
          ,:feeseg_maritz
          ,:channel
          ,:deenrollment_dt (date, format 'mmddyyyy'));

     **** 22:50:13 Field too large in vartext data record: 2, field:
                   ENROLLMENT_DT
     **** 22:50:13 File record count
     **** 22:50:13 Value for Record statement may be too large

Thanks.

Lan

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