0

i am trying to load my data in my table. My data is terminated by '\t' and when I try:

OPTIONS (SKIP=0)
load data
infile 'C:\*'
APPEND into table Table1
FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
FNAME                    NULLIF NAME=BLANKS,
LNAME                     NULLIF LNAME=BLANKS,
SUFFIX                    NULLIF SUFFIX=BLANKS,
HNAME                    NULLIF HNAME=BLANKS,
ADDRESS1              NULLIF ADDRESS1=BLANKS,
ADDRESS2              NULLIF ADDRESS2=BLANKS,
CITY                         NULLIF CITY=BLANKS,
HSTATE                    NULLIF HSTATE=BLANKS,
ZIP                            NULLIF ZIP=BLANKS,
EXTENDED_ZIP        NULLIF EXTENDED_ZIP=BLANKS,
COUNTRY                 NULLIF COUNTRY=BLANKS,
)

I can successfully load my data in my table, but no null value show up and it inserted the next column values instead of (null).

Can anyone help me please

Thanks in advance

user3602755
  • 27
  • 1
  • 6

1 Answers1

0
1) As vkp pointed out , an extra ',' after country name.
2) FNAME                    NULLIF **NAME**=BLANKS

it should be 'FNAME'

Try these changes, it works fine for me.

arjun gaur
  • 518
  • 1
  • 9
  • 25