update not executing

[Former Member]

Hi folks ,

I was trying to use the Update syntax for the z-table.

Its not working properly.

In the where condition ,I have specified all the key fields

TYPES : BEGIN OF ITAB1,

JOBNAME TYPE CHAR32,

RUNINSTANCE TYPE CHAR3,

RUNCLIENT TYPE NUMC3,

STARTDATE TYPE CHAR10,

STARTTIME TYPE CHAR8,

VERSION TYPE NUMC4,

MAESTRO_JOB TYPE CHAR30,

BATCH_SCHEDULE TYPE CHAR50,

END OF ITAB1.

TYPES ITAB TYPE STANDARD TABLE OF itab1 WITH DEFAULT KEY.

DATA IN_TAB TYPE ITAB WITH HEADER LINE.

.

.

.

IF NOT IN_TAB[] IS INITIAL.

LOOP AT IN_TAB.

UPDATE ZADM_JOBRUN

SET

ZADM_JOBRUN~MAESTRO_JOB = IN_TAB-MAESTRO_JOB

ZADM_JOBRUN~BATCH_SCHEDULE = IN_TAB-BATCH_SCHEDULE

WHERE

JOBNAME = IN_TAB-JOBNAME AND

RUNINSTANCE = IN_TAB-RUNINSTANCE AND

RUNCLIENT = IN_TAB-RUNCLIENT AND

STARTDATE = IN_TAB-STARTDATE AND

STARTTIME = IN_TAB-STARTTIME AND

VERSION = IN_TAB-VERSION .

ENDLOOP.

ENDIF.

Kindly let know what is missing...

Regards,

Ajaz

[Former Member]

Hi,

Change the update statement like this.

UPDATE ZADM_JOBRUN

SET MAESTRO_JOB = IN_TAB-MAESTRO_JOB

BATCH_SCHEDULE = IN_TAB-BATCH_SCHEDULE

WHERE JOBNAME = IN_TAB-JOBNAME AND

RUNINSTANCE = IN_TAB-RUNINSTANCE AND

RUNCLIENT = IN_TAB-RUNCLIENT AND

STARTDATE = IN_TAB-STARTDATE AND

STARTTIME = IN_TAB-STARTTIME AND

VERSION = IN_TAB-VERSION .

Regards,

Jayaram..

[Former Member]

hi,

change your update statement like this

IF NOT IN_TAB[] IS INITIAL.

LOOP AT IN_TAB.

UPDATE ZADM_JOBRUN

SET

MAESTRO_JOB = IN_TAB-MAESTRO_JOB

BATCH_SCHEDULE = IN_TAB-BATCH_SCHEDULE

WHERE

JOBNAME = IN_TAB-JOBNAME AND

RUNINSTANCE = IN_TAB-RUNINSTANCE AND

RUNCLIENT = IN_TAB-RUNCLIENT AND

STARTDATE = IN_TAB-STARTDATE AND

STARTTIME = IN_TAB-STARTTIME AND

VERSION = IN_TAB-VERSION .

ENDLOOP.

ENDIF.

Regards,

Sruthi

[Former Member]

Hello syed ajaz,

Did you try including <i><b>Commit work</b></i> after the update statement in your code?

Regards,

Jeffrey