Mass Update Zfield in Std Table with Split & Job submit

[ricky_shaw]

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

[ricky_shaw]

Can any one answer me please

[ricky_shaw]

Hi Again, I am using a check box 'P_Submit 'on Sel screen and when this is checked it will submit the jobs. My code is below:

[ricky_shaw]

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?

[ricky_shaw]

Why no one is responding to my post? Am i posting in the correct space? The new SDN upgrade seems to have messed up the things