topic create SQL run by batch -certain record in Application Development and Automation Discussions

create SQL run by batch -certain record

Former Member — Fri, 30 Oct 2009 03:37:00 GMT

hi all , i have created one program , and i have execute more than 40000 record. the problem is, when i run this background job with 40000 record, i got DBIF_RSQL_INVALID_RSQL error. if i run 100 record it will display.

how i want to modified my pgram which is , its run 100 record by 100 record until 40000 record, then it is will i have the same problem? DBIF_RSQL_INVALID_RSQL?

Re: create SQL run by batch -certain record

Former Member — Fri, 30 Oct 2009 04:34:37 GMT

yeah..u can handle your select -options with less number of records like this:

s_guidt[] = s_guid[].

REFRESH s_guid[].

LOOP AT s_guidt .

MOVE-CORRESPONDING s_guidt TO s_guid .

APPEND s_guid .

cnt = cnt + 1 .

IF cnt > 50 .

cnt = 0.

PERFORM get_header.

REFRESH s_guid[].

ENDIF.

ENDLOOP .