DB update

Former Member — Wed, 27 Aug 2008 07:48:06 GMT

Hye Experts,

Suppose there are 8 colums in DB table and all are non-empty.

I want to alter only last 3 coloums, without disturbing the first 3. Only first column is the primary key.

Is it possible only by using either update or modify, without a Select statement.

I dont want to use Select Query for fetching the data, instead have to update the record.

Thanks,

Sentil

Re: DB update

Former Member — Wed, 27 Aug 2008 07:51:40 GMT

Hi,

Use the Update statment :


  UPDATE ztable SET augru = vbap-mvgr1
      WHERE vbeln EQ t_vbak-vbeln.

Hope this helps,

Erwan

Re: DB update

ThomasZloch — Wed, 27 Aug 2008 07:52:58 GMT

déjà vu...different user, same question?

Re: DB update

Former Member — Wed, 27 Aug 2008 07:54:58 GMT

Hi,

It can be done as below..

UPDATE dbtab - set_expression

Syntax

[col1 = f1 col2 = f2 ... ]

[col1 = col1 + f1 col2 = col2 + f2 ...]

[col1 = col1 - f1 col2 = col2 - f2 ...]

[(expr_syntax1) (expr_syntax2) ...] ... .

Extras:

1. ... col = f

2. ... col = col + f

3. ... col = col - f

4. ... (expr_syntax)

Effect

Change-expressions for the addition SET for the statement UPDATE.

Addition 1

... col = f

Effect

Assignment of a value. For col, columns of the database table given in target or in the stated view dbtab can be specified through a column identifier comp or dbtab_{comp. For f, data objects of the ABAP program or a column identifier dbtab}comp of another column in the database table can be used.

The statement UPDATE assigns the content of f to the columns col in all the rows defined by the WHERE condition. If the data types are not compatible, conversion is as follows:

During the assignment of a data object, the content - if necessary - is converted according to the conversion rules into the ABAP data type that corresponds to the data type of the column. An error during conversion causes an exception that cannot be handled.

During the assignment of another column, the content - if necessary - is converted in the database system. The option of conversion and the conversion rules depend on the database system concerned. An error during conversion would - in releases prior to 6.10 - cause an exception that cannot be handled. In releases after 6.10, it causes an exception CX_SY_OPEN_SQL_DB that can be handled.

if, for f, a column is specified, changes to this column that are made in the same UPDATE statement are not taken into consideration during the assignment.

If a column col appears in several change-expressions, the last corresponding change-expression takes effect.

Addition 2

... col = col + f

Effect

Addition of a value. For col and f, the same applies as for the assignment of a value. col must have a numeric data type, however.

The statement UPDATE adds - in all the rows defined by the WHERE condition - the value of f to the content of the column col. Otherwise, the same rules apply as for the assignment of a value.

Addition 3

... col = col - f

Effect

Subtraction of a value. For col and f, the same applies as for the assignment of a value. However, col must have a numeric data type.

The statement UPDATE subtracts - in all the rows defined by the WHERE condition - the value of f from the content of the column col. Otherwise, the same rules apply as for the assignment of a value.

Addition 4

... (expr_syntax)

Effect

Dynamic specification of change-expressions. A change- expression can be specified as a bracketed data object expr_syntax that - at execution of the statment - either contains the syntax of one or several static change-expressions or is initial. The data object expr_syntax can be a character-type data object or an internal table with character-type data type. The syntax in expr_syntax is - as in the ABAP Editor - independent of uppercase/lowercase lettering. In the specification of an internal table, the syntax can be split up into several lines.

Cheers,

Rama.

Edited by: posimsetty ramamurthy on Aug 27, 2008 2:18 PM

Re: DB update

Former Member — Wed, 27 Aug 2008 08:31:10 GMT

Perhaps Ram liked the question so much, that he wanted to practice answering it a little bit longer.....

Ram has been doing quite a lot of practicing lately together with his friend as well...

Re: DB update

Former Member — Wed, 27 Aug 2008 10:35:31 GMT

All of them are clones derived from Guest.

Cheers

Vijay

topic Re: DB update in Application Development and Automation Discussions

DB update

Re: DB update

Re: DB update

Re: DB update

Re: DB update

Re: DB update