topic Re: sy-dbcnt in Application Development and Automation Discussions

sy-dbcnt

Former Member — Thu, 19 Apr 2007 14:14:34 GMT

what is sy-dbcnt

Re: sy-dbcnt

Former Member — Thu, 19 Apr 2007 14:16:57 GMT

Database Count. It will count number of records in a database table.

Regards

Haritha.

Re: sy-dbcnt

Former Member — Thu, 19 Apr 2007 14:17:19 GMT

SY-DBCNT gives the number of records in database table

After an open SQL statement, the system field sy-dbcnt contains the number of database lines processed.

REPORT ychatest.

DATA : v_matnr LIKE mara-matnr.

SELECT matnr FROM mara INTO v_matnr UP TO 1 ROWS.

ENDSELECT.

WRITE : sy-dbcnt.

Message was edited by:

Chandrasekhar Jagarlamudi

Re: sy-dbcnt

Former Member — Thu, 19 Apr 2007 14:18:15 GMT

it will return the number of records processed in the database.

Re: sy-dbcnt

Former Member — Thu, 19 Apr 2007 14:19:36 GMT

hi,

Welcome to SDN

SY-DBCNT:: no. of records processed in database table after a query.

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.

Return Value

~~Guduri

Re: sy-dbcnt

Santosh_Kezkhepatmelathil — Thu, 19 Apr 2007 14:24:04 GMT

it is a System Field which gives you the Number of Records In database table

regards,

santosh.

Re: sy-dbcnt

Former Member — Thu, 19 Apr 2007 18:52:57 GMT

Hi,

Number of elements in edited dataset with DB operations

WRITE: /12 'Number of selected records:', SY-DBCNT CENTERED.

Regards,

Bhaskar

Re: sy-dbcnt

Former Member — Thu, 19 Apr 2007 18:56:23 GMT

when a selct query was executed it will have how many records fetched from database

Re: sy-dbcnt

Former Member — Thu, 05 Mar 2009 09:14:45 GMT

nmhnh

Re: sy-dbcnt

Former Member — Sat, 08 Sep 2012 11:41:26 GMT

no of records read (rows processed) in database.

Re: sy-dbcnt

bharat_rathod2 — Sat, 08 Sep 2012 11:50:09 GMT

Dear,

this thread is marked as answered s no need to give answer

Re: sy-dbcnt

Former Member — Sat, 08 Sep 2012 11:58:13 GMT

ohh...okk...new here so didn't noticed that.