problem with import

Training
Enthusiast

problem with import

i am having a table A
CREATE SET TABLE A,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
x DATE FORMAT 'YYYY-MM-DD',
)
PRIMARY INDEX (x);

following is my data in textpad
07/07/08

i am using bteq import to insert this in table A
with script

.import REPORT file='C:\importtest2.txt'
.quiet on
.repeat 1
using
x (char(8))
values
(

cast(:x as date)

);

but i am getting an error saying
invalid date supplied for A.x
please clarify this
what i am doing wrong also please through a light on why this error is handling i.e how date format is working internally here

1 REPLY
Enthusiast

Re: problem with import

Hi Prakhar

try to use
cast('07/07/08' as date format 'dd/mm/yy')

cast( :x as date format 'dd/mm/yy')