topic Re: indexes in Application Development and Automation Discussions

indexes

Former Member — Wed, 04 Apr 2007 10:38:04 GMT

hi!

diffrence between sy-index, sy-tabix, sy-dbcnt.

regards

Re: indexes

Former Member — Wed, 04 Apr 2007 10:40:18 GMT

Hi!

SY-INDEX is actualized within a DO ... ENDDO cycle.

SY-TABIX is actualized within LOOP ... ENDLOOP, and it points to the actual record in the internal table.

SY-DBCNT contains the number, how many records have you selected into an internal table, after a SELECT command. If it is 0, the no records were found.

Regards

Tamás

Message was edited by:

Tamás Nyisztor

Re: indexes

Former Member — Wed, 04 Apr 2007 10:41:16 GMT

Hi..

SY-INDEX :: it is the SYSTEM FIELD THAT gives the of current loop pass in DO or while loops.

SY-TABIX:: It is the loop counter in

LOOP AT..ITAB

ENDLOOP.

APPEND sets SY-TABIX to the index of the last table row, that is the total number of entries in the target table.

COLLECT sets SY-TABIX to the index of the existing or appended table row. With hashed tables, SY-TABIX is set to 0.

LOOP AT sets SY-TABIX to the index of the current table row at the beginning of every loop pass. After leaving a loop, SY-TABIX is set to the value it had before entering the loop. With hashed tables, SY-TABIX is set to 0.

READ TABLE sets SY-TABIX to the index of the table row read. If no row is found with binary search while reading, SY-TABIX contains the index of the next-highest row or the total number of rows +1. If no row is found with linear search while reading, SY-TABIX is undefined.

SEARCH <itab> FOR sets SY-TABIX to the index of the table row, in which the search string was found.

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

Message was edited by:

Rammohan Nagam

Message was edited by:

Rammohan Nagam

Re: indexes

Former Member — Wed, 04 Apr 2007 10:41:59 GMT

Hi,

sy-index: Loops, Current Loop Pass

sy-tabix: Internal Table, Current Row Index

sy-dbcnt: DB operations, number of table lines processed

Award if helps

Re: indexes

Former Member — Wed, 04 Apr 2007 10:42:38 GMT

SY-INDEX --- When using loops like DO... ENDO .. WHILE , other than internal tables

DO 5 times.

write : / sy-index.

ENDDO.

SY-TABIX.. When processing internal tables

loop at itab.

write : / sy-tabix.

endloop.

SY-DBCNT..

number of records in database table.

SELECT * from ZTABLE...

here SY-DBCNT will store the number of records