Ejecutando consultas SQL de insercion desde un programa Java me tira este 
error: 
java.sql.SQLException: [SQL7008] MER2E2F1 de MERFL no válido para la operación.

Buscando el código de error [SQL7008] encontre esto: 
"La base de datos realiza el control de compromiso mediante el registro por 
diario. Cualquier aplicación ODBC que se beneficia del control de compromiso 
necesitará registrar por diario los archivos que se utilizan."

"Every time I have seen this message, it is because the file is not
journaled (e.g. it wasn't created as part of a collection through SQL;
probably was created using DDS).  When using SQL and the default isolation
level (or generally any isolation level other than NONE), an insert or
update requires that the file be journaled (CRTJRNRCV, CRTJRN, then
STRJRNPF)."

O sea, debo journalizar todos los archivos que quiera actualizar?
No hay otra solución?

Estoy accediendo al db2/400 mediante iBatis (framework para acceder a base de 
datos).

___________________________________________
CONFIDENTIALITY NOTICE
This e-mail and any files and/or attachments transmitted with it are strictly 
confidential and intended solely for the use of the addressee. They may contain 
privileged and confidential information and, if you are not the intended 
recipient, you are hereby notified that any dissemination or copying and any 
use or disclosure of the information contained therein is strictly prohibited 
and may be illegal. If you are not the intended recipient, please notify [EMAIL 
PROTECTED] immediately and delete this message and any files and/or attachments 
thereto.

__________________________________________________
Forum.HELP400 es un servicio más de NEWS/400.
© Publicaciones Help400, S.L. - Todos los derechos reservados
http://www.help400.es
_____________________________________________________

Para darte de baja visita la siguente URL:
http://coyote.combios.es/mailman/listinfo/forum.help400

Responder a