How to use SQL Command Editor on DBA Cockpit.

[Former Member]

Hi,

now,I'm using a DBACockpit and i' d like to use SQL Command Editor.

I have already tried "select * from xxxx." on SQL Command Editor, but it has displayed "cannot find a stored procedure."

what' s this???

Somebody please give me a solution!!

NW:SAP NW AS 7.0 ABAP

DB:MS SQL Server2005

OS:WIndows 2003 64 bit

Best Regards,

Tae

[Former Member · Accepted solution]

Hello,

Does it say which stored procedure?

What is the exact statement you used? The SQL Command Editor is case and schema sensitive.

i.e. you need to use 'select * from <schema>.<TABLE>'

Regards,

Michael

[Former Member · Accepted solution]

Hi,Michael

Thank you for your reply.

I have already executed follow statement.

"select * from XXX.TBTCO."

"select * from TBTCO."

"select * from xxx.tbtco."

"select * from xxx.TBTCO."

xxx and XXX, both were shcema name and their could not executed.

Does SQL Command Editor only stored procedure execute?

Best Regards,

Tae

[Former Member · Accepted solution]

Hi Tae,

a simple statement like this should work:

select * from <sid>.TBTCO;

No apostrophe or anything like that is necessary. Just copy the statement and replace <sid>. That works for me.

Sven

[Former Member · Accepted solution]

Hi,

Thank you for your advise.

I have successfully done this sqlstatement.

select * from sid.TBTCO

I appriciate your quick reply.(^^)/

Best Regards,

Tae