Answer / guest

cursor is basically used for fetching the multi record...

Answer / ashwin mane

Cursors do provide a number of benefits. These benefits
follow from the fact that if you do not use a cursor, the
entire result set must be transferred to the client for
processing and display:

1.Client-side memory - For large results, holding the
entire result set on the client can lead to demanding
memory requirements.
2.Response time -Cursors can provide the first few rows
before the whole result set is assembled. If you do not use
cursors, the entire result set must be delivered before any
rows are displayed by your application.
3.Concurrency control -If you make updates to your data
and do not use cursors in your application, you must send
separate SQL statements to the database server to apply the
changes. This raises the possibility of concurrency
problems if the result set has changed since it was queried
by the client. In turn, this raises the possibility of lost
updates.

Cursors act as pointers to the underlying data, and so
impose proper concurrency constraints on any changes you
make.

Answer / riyaz chaus

Cursor is client side memory to be used to perform bunch of sql transactions.it also use to perform to hold the result of operations like sorting,joining.
instead of doing single by single sql transaction we can creat the cursor and do multiple transaction at single time.

why can't we convert spool wp to dialog or backgrd in operation modes

2 Answers   TCS,

---

For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?

0 Answers  

---

Screenshot document for solution manager installation.

0 Answers  

---

which is the t- code for system landscape

3 Answers   ABC,

---

When I go to SAP Management Console, the tree is not appearing ; and i cannot start the console from yesterday. So I went to "Run" services.msc option to check the SAP program files appear there or not. I checked there, the two sap files "SAPC11_00" and SAPOSCOL" are appearing there but not started. If i double click this for making it started, it gives the following message. "THE SERVICE DID NOT START DUE TO LOGON FAILURE" Can anybody suggest any solution to solve this problem. Awaiting for the reply . Please.

2 Answers  

---

I want to change five dialog work processes into batch. Where can I do this?

0 Answers  

---

How do find the SNOTE?

1 Answers  

---

How can you find a list of objects that have been repaired in the system?

0 Answers  

---

What is Transport domain and Domain controller?

5 Answers   HCL, Infosys, Patni,

---

what to do, if a workprocess is in hold status

2 Answers  

---

Can one application server have multiple instances and if yes then how many dispatchers we have per application server?

4 Answers  

---

How to assign a mass Tables in Auth Group by using T-code:se54

0 Answers   Accenture, SASA,

---