error using import

Tools
Enthusiast

error using 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: error using import

You are having problem with date's format in the input data file. Try explicitly formating the input variable.