Link to home
Start Free TrialLog in
Avatar of Joalkat
Joalkat

asked on

Command Prompt Error in Oracle SP2-0042 Unknown Command

I'm trying to create a control file in the command prompt, so I can load a flat file (tilde delimited) but I keep getting an error when the LOAD DATA command is invoked.  Here's the script and what am I doing wrong?

-- This is the SQL*Loader for  Items

LOAD DATA
INFILE      'Z:\JR Osuna\extracts_items tilda delimited\ITEMS_MFG.txt'
BADFILE     'Z:\JR Osuna\extracts_items tilda delimited\ITEMS_MFG.bad'
DISCARDFILE 'Z:\JR Osuna\extracts_items tilda delimited\ITEMS_MFG.dsc'
TRUNCATE
INTO TABLE trex_inv_items_mfg_copics_stg
FIELDS TERMINATED BY "~"
TRAILING NULLCOLS                                      
(
MITEM                 CHAR "TRIM(:MITEM        )",
MLLC                  CHAR "TRIM(:MLLC         )",
MRACN                  CHAR "TRIM(:MRACN        )",
MTYPN                  CHAR "TRIM(:MTYPN        )",
.....many more rows....
)

Thanks.

Joalkat
ASKER CERTIFIED SOLUTION
Avatar of MikeOM_DBA
MikeOM_DBA
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Joalkat
Joalkat

ASKER

Thanks, it worked...