topic Re: DELETE STATEMENT IN ECC6.0 in Application Development and Automation Discussions

DELETE STATEMENT IN ECC6.0

Former Member — Tue, 23 Jan 2007 13:29:53 GMT

HI,

How to use the DELETE statement in ECC6.0.

when i am using this statement , it is going to short dump.

Delete itab from wtab.

pls let me know

i am getting the error ,

convert the charater to numerics, only numerics are supported in at the argument position , bcos it is a unicode program.

let me know pls .

regards,

Re: DELETE STATEMENT IN ECC6.0

Former Member — Tue, 23 Jan 2007 13:34:52 GMT

Hi Madhavi,

The meaning of the statemnet

delete itab from <num> is that it would delete all the records from index <num>

if you want to delete the record that is like the workarea, you would have to use the where condition.

Message was edited by:

Ravi Kanth Talagana

Re: DELETE STATEMENT IN ECC6.0

Former Member — Tue, 23 Jan 2007 13:35:09 GMT

In Unicode table fields must be the same type and length....So itab and wtab must be the same....Declare a TYPE and then declare ITAB and WTAB as that TYPE.

Greetings,

Blag.

Re: DELETE STATEMENT IN ECC6.0

Former Member — Tue, 23 Jan 2007 13:59:24 GMT

hi,

chk the syntax:

DELETE - itab_lines

Syntax

... itab [FROM idx1] [TO idx2] [WHERE log_exp]... .

Extras:

1. ... FROM idx1

2. ... TO idx2

3. ... WHERE log_exp

Effect

To delete several lines at once, you have to specify at least one of the additions FROM, TO, or WHERE. You can only use the additions FROM and TO with standard tables and sorted tables.

If you specify several of the additions, the rows are deleted that result from the intersection of the individual additions.

Addition 1

... FROM idx1

Effect

If you specify FROM, all the table rows from the table index idx1 onwards are included. idx1 must be a data object with type i. If the value of idx1 is less than or equal to 0, a runtime error occurs. If the value is greater than the number of table rows, no rows are deleted.

Addition 2

... TO idx2

Effect

If you specify TO, only the table rows up to table index idx2 are included. idx2 must be a data object with type i. If the values of idx2 is less than or equal to 0, a runtime error occurs. If the value is greater than the number of table rows, it is set to the number of rows. If idx2 is less than idx1, no rows are deleted.

Addition 3

... WHERE log_exp

Effect

You can specify any logical expression log_exp after WHERE, for which the first operand of each individual comparison is a component of the internal table. This enables all logical expression with the exception of IS ASSIGNED, ISREQUESTED, and IS SUPPLIED. The dynamic specification of components using character-type data objects in parentheses is not supported here. All rows for which the logical expression is true are deleted.

hope this helps u,

keerthi