Skip to content

ABAP Keyword Documentation →  ABAP − Reference →  Obsolete Language Elements →  Obsolete Processing of External Data →  Obsolete Database Access →  Obsolete ABAP SQL →  Obsolete Syntax in ABAP SQL 

UPDATE WHERE, DELETE WHERE - CLIENT SPECIFIED

Other versions: 7.31 | 7.40 | 7.54

Obsolete Syntax

... CLIENT SPECIFIED ...

Effect

The addition CLIENT SPECIFIED can be used instead of the USING additions in the variants UPDATE SET and DELETE FROM of those write ABAP SQL statements in which a WHERE condition can be specified. This is obsolete and forbidden in strict mode from Release 7.54 and whenever global temporary tables are accessed. The addition USING should be used instead of CLIENT SPECIFIED.

The addition CLIENT SPECIFIED disables implicit ABAP SQL client handling off for the write statement. No implicit condition is created for the current client and the client column of client-specific data sources can be specified in the WHERE condition for selecting clients.

If it is known statically that the target of the write statement specified in target is not client-specific, the addition CLIENT SPECIFIED cannot be specified.


Notes

  • If the addition CLIENT SPECIFIED is specified in UPDATE SET and DELETE FROM and no WHERE condition is specified, all rows of the target specified in target are edited. The statement DELETE then deletes the entire content. The addition USING ALL CLIENTS is available as a replacement for this behavior.
  • If the addition CLIENT SPECIFIED is used for a dynamically specified database table or view and they are not client-specific, the addition is ignored.
  • If specified for statically specified cross-client database tables or views , the addition CLIENT SPECIFIED produces a syntax error in the strict modes of the syntax check from Release 7.40, SP05 or else a syntax warning.


Example

This example demonstrates two uses of the obsolete addition CLIENT SPECIFIED and how it is replaced by USING. The UPDATE statement selects a client, which can be implemented by switching implicit client handling to this client using USING CLIENT. The DELETE statement is intended to delete the data of all clients, which can be implemented by the addition USING ALL CLIENTS.

UPDATE demo_expressions 
  CLIENT SPECIFIED SET num1 = 1 WHERE mandt = '100' AND id = 'X'. 
UPDATE demo_expressions 
  USING CLIENT '100' SET num1 = 1  WHERE id = 'X'. 

DELETE FROM demo_expressions CLIENT SPECIFIED. 
DELETE FROM demo_expressions USING ALL CLIENTS.