on 04-13-2024 12:07 AM
Hi,
I need to do a mass update for a single Z*custom field of a STD table(say EANL).
The no. of records expected are around 3 million recs.
I am using Open cursor & then Fetch cursor technique to get 50000 records(package) at a time and update it in a do..enddo loop. Ofcourse 'Package' is a selection screen field.
Is this a right approach?
Now how do i make this fetch cursor & update(using FM) to submit into different background jobs?
I know there are std FM's like FM's JOB_OPEN, SUBMIT Program & Job_ClOSE. But how do i fit these pieces together(fetch cursor + Update+ jobs) to make use these FM's into my program?
Can anyone please suggest.
Thanks
Hi Again,
I am using a P_Submit on Sel screen and when this is checked it will submit the jobs.
My code is below:
* Split into jobs
* Split into jobs
1) if p_submit = 'X'.
perform submit_jobs.
stop.
endif.
2) open cursor with hold c_curs1 for
select * from sometable
where field1 in s_field1
and field2 lt sy-datum
and loevm = space.
* fetch data in packets
do.
fetch next cursor c_curs1 into table it_tab package size p_record.
if sy-subrc = 0.
sort it_everh by vertrag.
describe table it_everh lines data(lv_lines).
perform update_data.
else. " if no further data then exit
message 'No (more) data found' type 'S'.
exit.
endif.
refresh it_tab.
enddo.
close cursor c_curs1.
3) Inside perform submit_jobs i have FM's for Job open & close & between that a SUBMIT prog..etc
submit (lv_prog) via job gv_jobname number gv_jobcount
with s_field1 in s_contr
with p_record eq p_record
with p_submit eq 'X'
and return.
But the Program is executing 1) and stopping there.
The data Update logic is working perfect.
Can someone suggest?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.