Failure 3737 Name requires more than 30 bytes in LATIN internal form.

Database

Failure 3737 Name requires more than 30 bytes in LATIN internal form.

none of the columbs in the volatile table are exceeding 30 char limit. Still getting the error. Any help is appreciated..

Create volatile set table  expq2adm.RING_COUPON_CODE_VTT

(

      DISCOUNT_COUPON_CD INTEGER NOT NULL,

      CAMPAIGNKEY INTEGER NOT NULL,

      CELLCODE VARCHAR(40),

      STARTDATE DATE FORMAT 'YYYY-MM-DD' NOT NULL,

      ENDDATE DATE FORMAT 'YYYY-MM-DD' NOT NULL,

      TIPON VARCHAR(20),

      CHANNEL VARCHAR(100),

      BARCODE VARCHAR(100),

      CAMPAIGNTYPE VARCHAR(80),

      CAMPAIGNNAME VARCHAR(200),

      CONTACTEDGROUP VARCHAR(100),

      OFFER VARCHAR(200),

      CAMPAIGNDESCRIPTION VARCHAR(200),

      ELFSEGMENT VARCHAR(200),

      OFFERSPLIT VARCHAR(200),

      CIRCULATION INTEGER,

      CAMPAIGNREPORTINGGROUP VARCHAR(200),

      RCD_INS_TS TIMESTAMP(6)

)

PRIMARY INDEX (DISCOUNT_COUPON_CD,CAMPAIGNKEY,CELLCODE)

on commit preserve rows;

#######################################################

$

 *** Failure 3737 Name requires more than 30 bytes in LATIN internal form.

                Statement# 1, Info =2

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

1 REPLY

Re: Failure 3737 Name requires more than 30 bytes in LATIN internal form.

This Issue is resolved, 

There were special characters in the BTEQ which were throwing the error.

Thanks,