Table Fetching

[Former Member]

Without using SELECT *, is there any way to pick all the fields of a table?

[Former Member]

hi,

there is no other way to pick other than select*

[former_member404244]

Hi,

If u want all the fields from the data base table then SELECT * is the best way..Thre is no other way...else u have to spcify all the fields.

Regards,

nagaraj

[Former Member]

Tx

[Former Member]

Tx

[former_member404244]

Hi santo,

U didn't give points to both of us??

Reagrds,

Nagaraj

[RemiKaimal]

Hello,

You can, without explicitly writing a select statement using Logical databases.

As you must be knowing your LDB name can be specified in Goto->attributes in Attributes group :

Specify F1S (for BC: Planned flights, flights and bookings)

save and activate your report pgm.

Check out this sample code :

NODES: spfli, sflight.

FIELD-GROUPS: header, flight_info, flight_date.

START-OF-SELECTION.
  INSERT: spfli-carrid spfli-connid sflight-fldate
          INTO header,
          spfli-cityfrom spfli-cityto
          INTO flight_info.

GET spfli.
  EXTRACT flight_info.

GET sflight.
  EXTRACT flight_date.

END-OF-SELECTION.
  SORT STABLE.
  LOOP.
    AT FIRST.
      WRITE / 'Flight list'.
      ULINE.
    ENDAT.
    AT flight_info WITH flight_date.
      WRITE: / spfli-carrid , spfli-connid, sflight-fldate,
               spfli-cityfrom, spfli-cityto.
    ENDAT.
    AT flight_date.
      WRITE: / spfli-carrid , spfli-connid, sflight-fldate.
    ENDAT.
    AT LAST.
      ULINE.
      WRITE: cnt(spfli-carrid), 'Airlines'.
      ULINE.
    ENDAT.
  ENDLOOP.

Also note usage of LDB has slower performance than a normal select statement

Regards,

Remi

[Former Member]

select * is the best way. else you have to specify all the fields in your select statement.

Kishore.