topic Re: star structure? in Application Development and Automation Discussions

star structure?

Former Member — Thu, 28 Feb 2008 16:00:28 GMT

Does any one know why do we put start (*) sometimes 2 declare work areas, eg watts the diff between

TABLES: sadr and

TABLES: *sadr

Thanks

Sameer

Former Member — Thu, 28 Feb 2008 16:11:44 GMT

It mean it needs to use the workarea of the same table twice.

TABLES:  <TABLE>,
               *<TABLE>.

It's like to define:

TABLES:  <TABLE>.
DATA:  WA TYPE <TABLE>.

In the samples it declares two workarea based on the same structure.

SELECT * FROM SADR WHERE .....
   IF SADR-<FIELD> = ............
      SELECT * FROM *SADR WHERE .....

In this way I can do two queries for the same table and store the result in two different workarea without to lose the result of the first query.

Max

Former Member — Thu, 28 Feb 2008 19:14:23 GMT

Got it.

Thanks Max.