| SQLLDR, do you know why? Pleasee¡¡ [message #71601] |
Wed, 27 November 2002 16:16  |
HoMmEr
Messages: 3
Registered: November 2002
|
Junior Member |
|
|
I've this control file,
LOAD DATA
INFILE 'c:hommerf10.dat'
APPEND INTO TABLE estandar3
WHEN (cod_prod = 'SR6001')
(
cod_prod POSITION(1:6),
num_cli POSITION(07:14),
signo POSITION(15:15),
importe POSITION(16:22),
deci POSITION(23:24)
)
and when i put
"sqlldr
userid=system/manager@proyecto control=c:hommercmf1.ctl
log=c:hommercmf1.log
direct=true"
Dos says that everything is o.k.
-carga terminada- recuento de registros lógicos 16284-
But the log file is full of errors like "Registro 16: Desechado - todas las cláusulas WHEN han fallado", When clauses fails.
Evidently, this cod_prod is in the file, with others like SR0001, SR0201........
(By the way, can I put the 'like' in then when clause???)
WHY ?? Pleassse? As soon as posible¡¡
Thank you very much¡¡¡¡¡¡¡¡
Excuse me for my bad English¡¡
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
