What is RSQL?

[Vitaliy-R]

Hi,

Can you please tell me what RSQL stands for?

And how should I interpret it in Detail Display in SM50:

Database                         Number              Time (usec)         Recs.

Direct read                         1                   0                   0
Sequential read                13,054            8.466622790500000E+   64,796
Insert                              0                   0                   0
Update                              0                   0                   0
Delete                              0                   0                   0
Sources                             0  (Bytes)
RSQL                        8,877,052  (Bytes)
Commit                                             21,877
DB procedure calls                  0                   0

Thank you

Vitaliy

[Former Member · Accepted solution]

Hi,

RSQL (Remote SQL or Open SQL). It refers to DB interface. To DBMS independent stack for Open SQL.

I hope it helps.

Kind regards, Jack

[Former Member]

Hi,

In general that is right that RSQL could stands for remote as described above.

But in SAP world (SM50 and ABAP stack) RSQL stands for OPEN SQL. When you look at the DB interfaces in the SAP ABAP stack architecture there are two:

- Native SQL

- Open SQL - this one is refered to as RSQL. Open SQL statements are a fully integrated subset of Standard SQL within ABAP. They enable the ABAP programs to access data irrespective of the database system installed.

Both above interfaces (Open and Native) use underplaying layer: database specific layer.

Most of the SQL calls from ABAP code will be RSQL (OPEN SQL) calls. An ABAP programmer has to explicitly specify that the call is NATIV SQL, using the following statement:

EXEC SQL [PERFORMING <form>].

<Native SQL statement>

ENDEXEC.

Kind Regards, Jack

[Former Member]

I am currently trying to install some patches into a 4.7/200 MSSQL/W2K3 system and am getting ALOT of problems...most of them point towards DBIFF_RSQL...

What could be the underlying cause of this....where should I start looking for the problem?

sorry, I dont mean to hijack the current thread, but it seems to be the best place to ask...

[Former Member]

RSQL means remote sql.

A remote query statement is a query that selects information from one or more

remote tables, all of which reside at the same remote node. For example, the

following query accesses data from the dept table in the scott schema of the

remote sales database:

SELECT * FROM scott.dept@sales.us.americas.acme_auto.com;

A remote update statement is an update that modifies data in one or more tables,

all of which are located at the same remote node. For example, the following query

updates the dept table in the scott schema of the remote sales database:

UPDATE scott.dept@mktng.us.americas.acme_auto.com

SET loc = 'NEW YORK'

WHERE deptno = 10;

Hope it helps.

Regards/Dilip

[charlie_gil]

Another question on this. What does the DB records (the number) in the Sequentail read row stand for?

[former_member257378]

Has anyone been able to explain the "Number" and "Recs." column yet?