-
Hi there,
I am getting the following problem from an SQL Loader file.
This file ran correctly last year when the database was version 7.3.3, however is has since been upgraded to version 8i (running on NT)
SQL*Loader-350: Syntax error at line 14.
Expecting positive integer or column name, found keyword month.
month integer external NULLIF month=BLANKS,
The cmd file looks like:-
set ORACLE_SID=DRPL
f:\orant8i\bin\sqlldr userid=DRPL/DRPL control=f:\drpl\drplload\ctl\week_2003.ctl log=f:\drpl\drplload\log\week_2003.log
The ctl file is:-
OPTIONS ( DIRECT=TRUE )
LOAD DATA
INFILE "f:\drpl\drpldata\week2003.dat"
DISCARDFILE "f:\drpl\drplload\discard\week2003.dis"
DISCARDMAX 999
APPEND
INTO TABLE WEEK_CONVERSION
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
( year char,
start_date date(8) "YYYYMMDD",
day_number integer external,
week_number integer external,
year_week char,
month integer external NULLIF month=BLANKS,
quarter integer external NULLIF quarter=BLANKS,
last_friday_of_month char,
seq integer external)
Many thanks in advance
Allie
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|