report

[Former Member]

in reports,what's major difference b/w logical database and query?

can any one pls send the code also.

thanx and regrads,

priya

[sreeramkumar_madisetty]

Hi

LDB: is an hierachical logical relation between the tables.

Query : U can make it any way. no need of hierachical.

This is the simplest diffrence.

Regards,

Sree

[Former Member]

Hello,

A <b>logical database</b> is a reusable read routine that, once defined, can be used by multiple developers in multiple applications. The structure of a logical database defines the hierarchy, and thus the read sequence of the nodes. The depth of data read depends upon a report program

GET events. The logical database reads down to the deepest GET event of all

nodes that lie in the direct access path. The GET events are processed several times in the program , that is, a GET statement is really like loop processing. Therefore, you should not program a SELECT statement within a GET event, as this ultimately corresponds to a nested SELECT. Due to the predefined read sequence, you should avoid programming GET events that refer to deeper hierarchy nodes but do not require the data from higher nodes in the hierarchy. The LDB always reads the key fields of these nodes as well (the SPFLI and SFLIGHT fields in the example). In this situation, it is better to program the SELECT statements yourself than to use the logical database. When formulating the GET statement, you should always use the FIELDS addition (at least with wider tables) if you do not need all the fields in your program. The GET FIELDS f1 f2 statement corresponds to

a SELECT f1 f2, and must be appraised accordingly.

Reward if helpful,

Regards,

LIJO