Accessing database tables using sqlcli

[Former Member]

Hi,

I have created a table in database using Java WebDynpro and access it through code. My problem is that can not view the table using sqlcli ( SQL Commandline Interface ). my table name starts with TMP_ (eg: TMP_DATA).

When i use the Query select * from <schema>.TMP_DATA its showing that unknown table name. How can i see the table contents?

Thanks

Vinod V

[TTK · Accepted solution]

Hello Vinod,

maybe something like

select * from tables where tablename like 'TMP%'

may help.

Please note, that the underline '_' has a special meaning when used in like expressions.

Regards Thomas

[Former Member · Accepted solution]

Hi thomas,

I have tried the way and i could find the table name displayed as the same. But when i try the table name is select statement; the error message is displaying unknown table name: TMP_PHONEDICTIONARY.

Markus, i have logged in as superdba using MaxDB Commandline Tools( sqlcli )

Regards

Vinod V

[markus_doehr2 · Accepted solution]

try to log on with

sqlcli -U SAPJ2EEDB

or

sqlcli -U SAP<SID>DB

Markus

[Former Member · Accepted solution]

Hello markus,

I installed MaxDB SQL Studio, and connected to the server. Now the problem is that i am not able to see the tables that i created before using sqlcli. Where i went wrong?

Regards

Vinod V

[markus_doehr2 · Accepted solution]

You have to logon with the correct user

If this is a Java instance the user is SAP<SID>DB with the password you gave during installation.

Markus

[Former Member · Accepted solution]

Thanks Markus,

That was the ans.

[markus_doehr2]

With what SQL user are you trying this? How do you logon with sqlcli?

Markus