Getting SQL*Loader Error SQL*Loader-350: Syntax error at line 43. Illegal combination of non-alphanu
I've written several SQL*Loader programs over the years and haven't encountered this before.
I'm getting an SQL*Loader-350: Syntax error at line 43.
Illegal combination of non-alphanumeric characters
The CTL File is:
LOAD DATA
---- Linux Format
INFILE '/SharedData/Finance/Payroll/zhri0006c_Lycoming.csv'
Discardfile "STADDR.dis"
TRUNCATE INTO TABLE TLW.PMP_PEOPLESOFT_IMPORT
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(GEN_BADGE_NO CHAR,
PAY_GROUP CHAR,
EMPLOYEE_ID CHAR,
LAST_NAME CHAR,
FIRST_NAME CHAR,
EMPLOYEE_STATUS CHAR,
HIRE_DATE DATE "MM/DD/YYYY",
DEPARTMENT CHAR,
ACCOUNT_CODE CHAR,
LABOR_GRADE CHAR,
CLOCK_NUMBER CHAR,
HOURLY_RATE DECIMAL EXTERNAL,