topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Mon, 08 Oct 2007 15:22:26 GMT

hi All,

i want to know what will this statement do

select * from *<dbtabname> where.......

thanks

Sundeep

Re: select statement

Former Member — Mon, 08 Oct 2007 15:26:01 GMT

This will select all fields from database table into internal table u have specified, which should be of the table type.

Never use select * unless u need more than 75% of the fields. this will create performance problems

Re: select statement

Former Member — Mon, 08 Oct 2007 15:26:13 GMT

Here data is populated from a <DB table name> which is assigned during runtime. So this is a Dynamic SELECT.

Check the program. There must be some code which assigns value to field symbol <dbtabname>.

ashish

Re: select statement

Former Member — Mon, 08 Oct 2007 15:28:12 GMT

it gets the data from the databasetable depending upon the

where condition.

suppose i have one table zone.

in this table 3 records will be there.the fields in the recores are

f1 f2 f3 f4.

one boss big a

two boss1 big1 a

theree boss2 big2 b.

if u write select statement like this

select * from zone where f4 = 'a'.

u get the fallowing records

one boss big a

two boss1 big1 a

Re: select statement

Former Member — Mon, 08 Oct 2007 15:35:00 GMT

good

i dont think select statement works like this,

if you give the statement as select * from * mara, it ll give you a compile time error.

thanks

mrutyun^

Re: select statement

Former Member — Mon, 08 Oct 2007 16:01:48 GMT

Hi Sundeep,

As per my thinking it should give you <b>ERROR</b>...

Thanks & Regards

ilesh 24x7

Re: select statement

Former Member — Tue, 09 Oct 2007 07:18:07 GMT

Hello all,

i have seen this codeing in a standard progrmam and its working

select * from *mara where(some condition)

Re: select statement

Former Member — Tue, 09 Oct 2007 07:23:26 GMT

If you are specifying the field names then you will have to use into clause , since you dont want to use into clause then you select all the fields from the table using select *.

here is an sample

select single * from ekpo where ebeln = v_ebeln.

Re: select statement

Former Member — Tue, 09 Oct 2007 08:01:46 GMT

hi Naresh,

u did not get my question..

select * from <b>*mara</b>

what is is the use of the *before mara.

i want to know that.

thanks

sundeep

Re: select statement

Former Member — Mon, 15 Oct 2007 08:01:39 GMT

not answered

Re: select statement

Former Member — Mon, 15 Oct 2007 08:06:19 GMT

Hi,

select * statement will select all the fields of the database table based on the condition given in the where clause.

Please reward points.

Thank you,

Gangula Vikram.

Re: select statement

gopi_narendra — Mon, 15 Oct 2007 08:12:31 GMT

Generally *MARA when declared is treated as the Work Area for that program.

Suppose we declare

tables : mara, *mara.

MARA and * MARA are treatead as workareas and at the same time you can even retrieve data.

Regards

Gopi