Hola a todos/as!
Tengo un problema con un DELETE en un programa SQLRPGLE.
La instrucci�n es la siguiente
C/Exec Sql
C+ Delete from FILE
C+ Where DATE < :OldDate
C/End-Exec
C+ Delete from FILE
C+ Where DATE < :OldDate
C/End-Exec
En interactivo, desde el STRSQL me permite borrar registros, pero al ejecutarlo desde programa me da el siguiente error.
Member FILE not journaled to journal *N.
FILE in LIBRARY not valid for operation.
FILE in LIBRARY not valid for operation.
SQLCODE = -7008
SQLSTATE=55019
Estoy depurando con UPDPROD(*YES)
El fichero lo acabo de crear yo mismo. Es un f�sico con claves y no tiene opciones de compilaci�n ex�ticas.
Que tiene que ver el journal?
Message . . . . : Member FILE not journaled to journal *N.
Cause . . . . . : Member FILE file FILE in library LIBRARY is not
journaled to journal *N in library *N for commitment definition 88.
The journal specified is used by commitment definition 88. If *N is
specified for the journal, the file is not journaled. If the file is a
logical file, all based-on physical files may not be journaled to the same
journal as required by commitment control.
Recovery . . . : Ensure the file being opened is journaled. For logical
files, make sure that the based-on physical files are journaled to the same
journal.
Cause . . . . . : Member FILE file FILE in library LIBRARY is not
journaled to journal *N in library *N for commitment definition 88.
The journal specified is used by commitment definition 88. If *N is
specified for the journal, the file is not journaled. If the file is a
logical file, all based-on physical files may not be journaled to the same
journal as required by commitment control.
Recovery . . . : Ensure the file being opened is journaled. For logical
files, make sure that the based-on physical files are journaled to the same
journal.
Puede ser que el SQL se este peleando con el COMMIT?
Alguien tiene alguna idea de que puede estar pasando?
Gracias
Carlos
