we got the following problem:
during the execution of an applicative, for ex: a modification .......

an insert failure is produced, this insert failure is produced on one specific table, we have already increase the extent of this table but the problem still contineous.

how can we determine the causes of this failure to insert on a table.

Hi,
Please test the ISAM error. What is the error.

Gustavo.

Gustavo, the engine doesn´t give any isam error
it looks like if the application to insert is erased, but indeed it doesn´t erase
the reality would be it is not inserted

Hi Eduardob

Please, can you send me the SQL insert.

Gustavo

let m_status = 0

FOR m_ix = 1 to 54
if ga_ddeterm[m_ix].coddet is null then
continue for
end if
if ga_ddeterm_pe[m_ix].coddet is null then
continue for
end if

let gr_detcer.codlab = gr_ccertifi.codlab
let gr_detcer.numero = gr_ccertifi.numero
let gr_detcer.anio = gr_ccertifi.anio
let gr_detcer.coddel = gr_ccertifi.coddel
let gr_detcer.deljurinsc = g_deljurinsc
let gr_detcer.nrocer = gr_ccertifi.nrocer
let gr_detcer.coddet = ga_ddeterm[m_ix].coddet
let gr_detcer.valobt = ga_ddeterm[m_ix].valobt
let gr_detcer.feccer = g_fechahora
let gr_detcer.senabm = g_senabm
let gr_detcer.fecgra = g_fecha
let gr_detcer.usrnom = g_usrnom
let gr_detcer.senenv = " "
let gr_detcer.orden = m_ix

SET LOCK MODE TO WAIT
insert into lb_detcer
values (gr_detcer.*)

if status != 0 then
let m_status = status
exit for
go to f_tratam_galta01_analisis
end if
END FOR

Gustavo here I send you the SQL insert, it´s a common sentence