Transaction or standard program for testing Open SQL statements

[Former Member]

Hi experts,

Is there a standard program or transaction that can be used to test Open SQL statements?, I was thinking in something similar to a SQL client like sqlcli, but for Open SQL and within SAP GUI.

I know i can write a test ABAP program for this matter but I rather a standard testing facily in this case

Thank you for any help

regards

[Former Member]

check transactions SE30, ST05

[Former Member]

Hi,

thank you for the info, but in TC ST05 I can´t see the output of the SQL statement, right?

regards

[former_member848108]

Hi Garduno,

You can try tcode DB02 - SQL Command Line functionality, which is avaible under Diagnostics as an alternative sql client.

Hope it helps.

Ozcan.

[Former Member]

Hi Ozcan

I tried DB02 -> Diagnosis -> SQL Command editor , but I couldn't made it work. It is for Open SQL or for Native SQL?

I tried the following simple Open SQL statements inside the SQL Code tab there were erros

SELECT *

FROM /BI0/PCOMP_CODE

error was: Incorrect syntax near '/'.

SELECT * FROM DD03L

error was: Invalid object name 'DD03L'.

Where is the mistake?

regards

[former_member848108]

Hi Garduno,

I am sorry but it's for Native SQL only. And if your system ID were xyz, you should try something like this, using the database owner before the table name.

SELECT * FROM xyz.DD03L or

SELECT * FROM XYZ.DD03L

Hope it helps,

Ozcan.

[Former Member]

Hi Ozcan

There should be no need to specify the schema owner when running SQL statments from inside the SAP system. Using the SID as schema owner is in any case wrong and will not work from inside SAP, in SQLplus or any other DB tool.

When specifying objects containing slashes, you have to use quoteation marks.

E.g. SELECT * FROM "/BI0/PCOMP_CODE"

If the table name contains only letters and/or numbers, it's sufficient to just use the table name without quotation marks.

E.g. SELECT * FROM DD03L

I've tried both statments in my BW system and they work just fine.

Regards,

LEH

[Former Member]

In the DB02 -> Performance -> Additional functions -> SQL Command Editor

Give the query. It gives the output in the result.

Cheers

Sujay

[Former Member]

Thank you all for your interest in this question