Home » RDBMS Server » Server Utilities » update through sql loader
|
|
Re: update through sql loader [message #255287 is a reply to message #255234] |
Tue, 31 July 2007 05:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
annu-agi
Messages: 238 Registered: July 2005 Location: Karachi
|
Senior Member |
![annu-agi](/forum/theme/orafaq/images/yahoo.png) ![anwerrasool](/forum/theme/orafaq/images/google.png)
|
|
hi experts
see the script and tell me where i m making a mistake to enter constant data for com_Cd and loc_cd . it causeing an error
Record 1: Rejected - Error on table DEALER_INFO, column COM_CD.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 2: Rejected - Error on table DEALER_INFO, column COM_CD.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 3: Rejected - Error on table DEALER_INFO, column COM_CD.
Column not found before end of logical record (use TRAILING NULLCOLS)
load data
infile 'M:\dbf_only\ighdeler.TXT'
into table dealer_info
fields terminated by ","
optionally enclosed by '"'
(
CAT_ID ,
D_CODE ,
MEM_DT date 'yyyymmdd',
NAME ,
PERSON ,
ADDRESS1 ,
ADDRESS2 ,
ADDRESS3 ,
PHONE ,
CLASS ,
CR_APP ,
CR_TERMS ,
ACCOUNT ,
CR_LIMIT ,
OPENING ,
TARGET ,
TOT_LIAB ,
VISIT1 ,
VISIT2 ,
VISIT3 ,
VISIT4 ,
VISIT5 ,
VISIT6 ,
VISIT7 ,
TOT_AMT ,
SHOP_ON ,
SHOP_OFF ,
SHOP_POS ,
CLOSE_D date 'yyyymmdd',
START_D date 'yyyymmdd',
FAX ,
D_K_NO ,
DEEP_FREZ ,
CASH_FREE ,
NEW_FLAG ,
GST_NO ,
NTN_NO ,
com_Cd char "01",
dealer_cd char "LPAD(ROWNUM, 10, '0')",
loc_Cd char "01"
)
|
|
|
|
Goto Forum:
Current Time: Fri Sep 06 23:47:17 CDT 2024
|