|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/24/2008 11:42:56 AM
Posts: 2,
Visits: 8
|
|
I'm trying to create a simple table from external data that has problems with dates. The original data resides in MS Access, but I am exporting dates in a 10-char field as below.
I get: Failure 3707 Syntax error, expected something like ')' or ',' between the word 'Opened' and the 'cast' keyword.
What am I missing?
Should I be performing the cast in the using statement or the insert?
What is the corrcet syntax?
Very confused!!
Data format:
28304;2007-03-31;2008-01-15
80676;2007-12-31;2008-02-01
BTEQ script:
database dbname;
drop table dbname.storedt ;
create table dbname.storedt (
Outlet_ID varchar(10)
,Opened date
,Upgraded date
)
unique primary index (Outlet_ID);
.quiet on
.import vartext ';' file = filename.txt;
.repeat *
USING
Outlet_ID (varchar(10))
,Opened (date)
,Upgraded (date)
insert into dbname.storedt values
(:Outlet_ID
,:Opened (cast(Opened as date)
,:Upgraded (cast(Upgraded as date)
);
.logoff;
.quit;
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 5:35:53 PM
Posts: 439,
Visits: 421
|
|
The casting syntax is not correct, actually you don't need to cast ....
USING
Outlet_ID (varchar(10))
,Opened (varchar(10))
,Upgraded (varchar(10))
insert into storedt values
(:Outlet_ID
,:Opened
,:Upgraded
);
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/24/2008 11:42:56 AM
Posts: 2,
Visits: 8
|
|
Seems easy enough now! Thanks!
|
|
|
|