delete statement

[Former Member]

Hi

experts can anyone please tell me the syntax of delete statament.actually my code is not running and is giving a shortdump.

DELETE itab WHERE emo_cd_rd_dest = 2314.

is there any alternate mthod fot this.

[Former Member]

Hi Gaurav

You can also use Clear or else you can also delete by comparing

DELETE ADJACENT DUPLICATES FROM itab.

DATA ITAB LIKE STANDARD TABLE OF LINE 
          WITH NON-UNIQUE KEY COL2.

LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.
LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.
LINE-COL1 = 1. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 2. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 3. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 4. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 5. LINE-COL2 = 'A'. APPEND LINE TO ITAB.

OFF = 0. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

OFF = 14. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING COL1.

OFF = 28. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB.

OFF = 42. PERFORM LIST.

FORM LIST.
  SKIP TO LINE 3.
  LOOP AT ITAB INTO LINE.
     WRITE: AT /OFF  LINE-COL1, LINE-COL2.
  ENDLOOP.
ENDFORM.

Reward all helpfull answers

Regards

Pavan

[Former Member]

Hi,

what is the error message in shortdump?

[former_member491305]

Hi,

Give it in codes.

DELETE itab WHERE emo_cd_rd_dest = '2314'.

[former_member404244]

Hi,

Try like this.use single code.

DELETE itab WHERE emo_cd_rd_dest = '2314'.

Regards,

Nagaraj

[Former Member]

Hi,

Try this,

DELETE itab WHERE emo_cd_rd_dest = '2314'.

What dump it is Showing?

Regards,

Padmam.

[Former Member]

Hi Gaurav

You can also use Clear or else you can also delete by comparing

DELETE ADJACENT DUPLICATES FROM itab.

DATA ITAB LIKE STANDARD TABLE OF LINE 
          WITH NON-UNIQUE KEY COL2.

LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.
LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.
LINE-COL1 = 1. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 2. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 3. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 4. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 5. LINE-COL2 = 'A'. APPEND LINE TO ITAB.

OFF = 0. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

OFF = 14. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING COL1.

OFF = 28. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB.

OFF = 42. PERFORM LIST.

FORM LIST.
  SKIP TO LINE 3.
  LOOP AT ITAB INTO LINE.
     WRITE: AT /OFF  LINE-COL1, LINE-COL2.
  ENDLOOP.
ENDFORM.

Reward all helpfull answers

Regards

Pavan