Native SQL

[Former Member]

Hi,

What is the harm in using SQL statements...

There is a requirement to fetch data from V$SQL, Will there be any harm or impact?

Regards

Jiku

[Former Member]

Hi!

For more help on Native SQL, check the EXEC SQL statement help in ABAP.

If you want to read data from an external database (outside from SAP), you have to estabilish the connection between the two systems, which is different with every type of the systems.

There are some non catchable extensions when using native SQL. For this, check the docu of the commands TRY - CATCH.

Regards

Tamá

[Former Member]

Hi,

If you use Open SQL, your SQL statements will be passed to the database interface. Using Open SQL has <b>three main advantages</b>. All of these advantages are implemented via the database interface.

<b>Portability</b>

The first advantage is the fact that your SQL statements will be portable between databases. For example, if for some reason your company wanted to switch from an Oracle to an Informix database, it could change the database, and your ABAP/4 code would continue to run without modification.

<b>Buffering Data on the Application Server</b>

Secondly, the database interface buffers information from the database on the application server. When data is read from the database, it can be stored in buffers on the application server. If a request is then made to access the same records, they would already be on the application server, and the request is satisfied from the buffer without having to go to the database. This buffering technique reduces the load on the database server and on the network link between the database and application servers, and can speed up database access times by a factor of 10 to 100 times.

<b>Automatic Client Handling</b>

The third advantage of using Open SQL is automatic client handling. With Open SQL, the client field is automatically populated by the database interface. This gives your development and testing teams many advantages, such as the ability to perform multiple simultaneous testing and training on a single database without interference from each other.

Hope this helps.

Reward if helpful.

Regards,

Sipra

[Former Member]

Hi jiku,

1. There is a requirement to fetch data from V$SQL

Don't worry, there will not be any harm.

regards,

amit m.

[Former Member]

Dear Amit,

Can you tell me what is V$SQL???

Regards

Jiku