topic Re: update not executing in Application Development and Automation Discussions

update not executing

Former Member — Thu, 01 Mar 2007 06:49:23 GMT

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

Re: update not executing

Former Member — Thu, 01 Mar 2007 09:55:06 GMT

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..

Re: update not executing

Former Member — Thu, 01 Mar 2007 10:21:57 GMT

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

Re: update not executing

Former Member — Fri, 02 Mar 2007 06:16:41 GMT

Hello syed ajaz,

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

Regards,

Jeffrey