DBIF_RSQL_SQL_ERROR

[Former Member]

Hi All.

I am working on a program...when we run this program as a job it runs for sometime and then it gets cancel and when I went to st22 i saw the short dump with this message DBIF_RSQL_SQL_ERROR and when I talk to my basis team they said that the problem is our jobs are not getting commited in time and The active log is full and is held by application handle. So can you please tell me how can i take care of this.

Thanks,

Rajeev

[former_member191735]

Search for OSS notes using the error analysis. The desc you specified here will address to many reasons. I want you to go through the OSS notes first.

[PedroGuarita]

You can use a counter and after x records do the commit yourself, something like :

count = 0.
loop at int_tab.
  count = count + 1.
  update dbtab set field = 1.
  if count > 500.
    commit work.
    count = 0.
  endif.

endloop.

[Former Member]

Rajeev,

Can you please post more details like part of the dump, at what point it give this dump ? The other solution if it is related to select statement from tables etc , is go for the index, change select statement etc.