Database Utilities (MOSC)

MOSC Banner

SQl Loader - load I delimited file with different data types

edited Feb 18, 2014 12:00PM in Database Utilities (MOSC) 2 commentsAnswered

I am trying to load a "I" delimited data file with different data records into the same table using WHEN clause and it is in version 8.0  (it does not know filler keyword yet). I use  as follows:

                                   APPEND

                                   into table same_table_name

                                   when (1)='XXX'

                                   fields terminated by '|'

                                      (...)

                                   into table same_table_name

                                   when (1)='YYY'

                            '       fields terminated by '|' 

                                     (...)

It loads all records of type 'XXX' just fine and does not see actual data rows for the rest of the records - what's the problem, I thought WHEN clause should work , I used for the fixed length files before... Help is appreciated. Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center