topic Re: Transaction or standard program for testing Open SQL statements in Application Development and Automation Discussions

Transaction or standard program for testing Open SQL statements

Former Member — Wed, 11 Aug 2010 16:24:51 GMT

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

Re: Transaction or standard program for testing Open SQL statements

Former Member — Wed, 11 Aug 2010 16:36:35 GMT

check transactions SE30, ST05

Re: Transaction or standard program for testing Open SQL statements

former_member848108 — Thu, 12 Aug 2010 05:44:59 GMT

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.

Re: Transaction or standard program for testing Open SQL statements

Former Member — Fri, 13 Aug 2010 13:41:29 GMT

Hi,

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

regards

Re: Transaction or standard program for testing Open SQL statements

Former Member — Fri, 13 Aug 2010 13:46:57 GMT

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

Re: Transaction or standard program for testing Open SQL statements

former_member848108 — Fri, 13 Aug 2010 13:55:20 GMT

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.

Re: Transaction or standard program for testing Open SQL statements

Former Member — Fri, 13 Aug 2010 13:58:57 GMT

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

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

Cheers

Sujay

Re: Transaction or standard program for testing Open SQL statements

Former Member — Mon, 20 Sep 2010 06:31:09 GMT

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

Re: Transaction or standard program for testing Open SQL statements

Former Member — Tue, 02 Nov 2010 20:39:03 GMT

Thank you all for your interest in this question