ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dictionary structures 表名前的星号*有何用处

dictionary structures 表名前的星号*有何用处

原创 Linux操作系统 作者:rosefish 时间:2008-03-18 14:53:24 0 删除 编辑



原帖由 gangtee 于 2008-1-7 12:30 发表
摘自 F1


TABLES *



Syntax
TABLES *table_wa.



Effect
This statement declares an additional table work area *table_wa, whose data type, like that of normal TABLES statements of flat, structured data type table_wa, is copied from the ABAP Dictionary.

The additional table work area can be used like the normal table work area. This applies in particular to obsolete short forms of Open SQL statements.

Note
The statement TABLES cannot be used in classes. For declaring as many work areas as you want, you can use the addition TYPE to use the data types in the ABAP Dictionary.

Example
Declaration of a normal and additional table work area and its use in obsolete short forms of the SELECT statement.

TABLES: scarr, *scarr.

SELECT SINGLE *
       FROM scarr
       WHERE carrid = 'LH'.

SELECT SINGLE *
       FROM *scarr
       WHERE carrid = 'UA'.

Ref. http://www.itpub.net/thread-921033-1-1.html

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/138253/viewspace-209676/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 动态显示标题
请登录后发表评论 登录
全部评论

注册时间:2008-01-21

  • 博文量
    8
  • 访问量
    14436