problem with my sqlloader

[sqlloader]

Hi ,

I am having problem while trying load data into my table using the sqlloader .

My control file is shown below :

load data
infile 'Q_ISSUE_HS-01-apr-2002.dat'
badfile 'Q_ISSUE_HS-01-apr-2002.bad'
discardfile 'Q_ISSUE_HS-01-apr-2002.dsc'

APPEND

into table Q_ISSUE_HS
fields terminated by ";"

(
ISSUE_TYPE_CD,LOAD_DT,MSG_ID,MSG_VRSN_NB,EFCTV_TRD_DT,MSG_CR
TN_DT,MSG_CRTN_TM,USER_ID,USER_ORG_ID,SDP_ID,USER_NB,MDS_SRC
_CD,MSG_ST,ACTN_CD,ISSR_ORG_ID,SIC_CD,BUS_CNDTN_CD,BUS_INDST
_CD,ISSUE_ID,ISSUE_NM,TSO_QT,ORGN_CD,ISSUE_SHRT_NM,ISSUE_C
LASS_CD,CUSIP_ID,ISIN_ID,CINS_ID,WHEN_ISSD_FL,WHEN_DSTRD_FL,
TRD_UNIT_QT,VNDR_DSSMN_FL,USAGE_CD,XMPTN_15C211_FL,VTNG_CD,W
ITH_WRRNT_FL,WITH_RGHTS_FL,CNVRB_FL,UTP_ATHRN_CT,UTP_BBO_ACT
V_CT )

my problem there are 280 records where the clast column of the table UTP_BBO_ACTV_CT is null . There are around 280 records which are null .

IS there any way in which i can solve this problem .

I tried giving this trailing nullcols but this is giving someother error which is shown below

SQL*Loader: Release 8.0.5.2.1 - Production on Tue Apr 2 17:38:22 2002

(c) Copyright 1998 Oracle Corporation. All rights reserved.

SQL*Loader-350: Syntax error at line 10.
Expecting "(", found keyword fields.
fields terminated by ";"


Apprecite your in advance

Prabhakar

 

[bcouse]

I have had a similar experience and solved it by completely redoing my control file - it was as if there was a blank or strange character embedded in the file that was causing SQLLoader to gag.

You probably do want to use the TRAILING NULLCOLS parm if the last column indeed could be NULL.

Good luck!

 

[JamesGordon]

I believe that SQL*Loader is petty about blank lines and expects things in a certain order.
Look at the examples in the docs and ensure the correct ordering.