topic Re: array fetch in Application Development and Automation Discussions

array fetch

Former Member — Thu, 10 May 2007 03:52:52 GMT

what is mean by array fetch and what is the use of it

Re: array fetch

Former Member — Thu, 10 May 2007 06:19:48 GMT

The main difficulties is connecting the programming language with the sql interface is the transfer of retrieved data fecords..

when the system process an sql statement it does not know how long the result would be.

The system has to transfer these records to the calling of a program in the form of a structure that is an array.

*The disadvantage of the array is that it is a static definition..u have to specify the size before runtime..As u do noy know the size it will overflow.

*To avoid this problem sap system translates the open sql statements into an embeded sql...

*To do this the system defines a cursor and the cursor is the logical connection to the selected datasets in the database and transfer between abap programs.

*This FETCH operation passes one or more records to the database interface..

This is called as array fetch..

Reward if it's useful..

Regards,

Manoj @ Eminent.

Re: array fetch

Former Member — Fri, 11 May 2007 10:18:20 GMT

Hi,

Array fetch is noting but extracting all the field of a database table using * in the select clause.

for example select * from vbap

generally it should be avoid to improve the performance by selecting only required fields from the table as below

It is mostly used to fetch multiple records in a single command.

e.g.

select * from mara into table z_mara.

FYI:

Other type is sequential type, in which select...endselect is used and each recordis processed after fecthcing...

e.g.

select single * from mara

" process ur data

append mara into z_mara.

endselect.

Both of above statement performs same function but first one is using array fetch and second one is using sequential fetch.

Jogdand M B

Re: array fetch

Former Member — Fri, 11 May 2007 13:17:46 GMT

thanks guys