topic Re: Select Count in Application Development and Automation Discussions

Select Count

Former Member — Wed, 28 Feb 2007 15:34:49 GMT

I am assuming this is basically use for finding the number of entries in a DB table...any other comon uses?

Should sy-dbcnt be checked when using this?

Thank-You

Re: Select Count

alex_m — Wed, 28 Feb 2007 15:37:18 GMT

SY-DBCNT will give u no of entries return by your select statement, if u put select * the sy-dbcnt will contain how many entries in DB table.

Re: Select Count

Former Member — Wed, 28 Feb 2007 15:38:32 GMT

Hi,

sy-dbcnt - total no of database records .

Regards,

Smithi

Re: Select Count

Former Member — Wed, 28 Feb 2007 15:38:37 GMT

Hi,

Sy-Dbcnt is used only for count the total no of records in db table.

No,

not for any orther uses.

Regards,

Sreevani

Re: Select Count

Former Member — Wed, 28 Feb 2007 15:38:44 GMT

Hello TOM,

SY-DBCNT - DB operations, number of table lines processed

Vasanth

Re: Select Count

Former Member — Wed, 28 Feb 2007 15:38:55 GMT

HI Tom,

Yes, that is its primary usage. To be precise, it gives the number of matches for the current where clause.

no need to check. It essentially does the same.

Regards,

Ravi

Re: Select Count

Former Member — Wed, 28 Feb 2007 15:40:41 GMT

So checking sy-dbcnt is same as COUNT.

So my basic question is still what would I use COUNT for?

Re: Select Count

Former Member — Wed, 28 Feb 2007 15:42:08 GMT

Sy-dbcnt will give the no. of records fetched from the database.

i.e Number of processed table rows

SY-DBCNT

SQL statements set the content of SY-DBCNT to the number of database lines processed. With SELECT loops in Open SQL, SY-DBCNT is set after the ENDSELECT statement. In Native SQL, SY-DBCNT is set after the ENDEXEC statement.

DELETE sets SY-DBCNT to the number of lines deleted.

FETCH sets SY-DBCNT to the number of lines already read by the current cursor.

INSERT sets SY-DBCNT to the number of lines inserted.

MODIFY sets SY-DBCNT to the number of lines processed.

UPDATE sets SY-DBCNT to the number of lines changed.

COUNT

count gives the total number of records present in the database table

Apart from that no other use as such

Hope this clears your doubt.

reward if useful

Regards,

Saumya

Re: Select Count

Former Member — Wed, 28 Feb 2007 15:48:50 GMT

Hi,

count Returns the number of lines selected.

sy-dbcnt DB operations, number of table lines processed

Regards,

Sruthi

Re: Select Count

Former Member — Wed, 28 Feb 2007 15:53:41 GMT

Saumya, Thanks you say..count gives the total number of records present in the database table, Apart from that no other use as such.

Where does it give the total no of records? in sy-dbcnt, because I check this without using COUNT.

Thanks everybody all feedback is appreciated.

Re: Select Count

alex_m — Wed, 28 Feb 2007 16:08:54 GMT

Hi Tom,

Finally u got a answer, example. Count function u can use for particular col name.

SELECT COUNT( CARRID )

INTO COUNT FROM SPFLI

WHERE

CITYTO = 'NEW YORK'.

WRITE: / COUNT.

For performance concern not advaisable to use COUNT statement.