Select Statement

[Former Member]

Hello there,

i am new in MAX DB and want to make a easy select Statement.

I think this is right?

SELECT * FROM USR02 WHERE BNAME='zztest'

But i become an error:

Error Executing 'SELECT * FROM USR02 WHERE BNAME='zztest'' [-4004] (at 15): Unknown table name:USR02.

So can you tell me whta wrong with this statement?

Thanks

Bjoern

[Melanie · Accepted solution]

Hello Björn,

probably you are not logged on as the owner of that table.

Best regards,

Melanie

[Former Member · Accepted solution]

I logged on as superdba. I thought that is the right user? Is it not?

[Former Member · Accepted solution]

no you should login as schema user or give <schema user>.<tablename> under superdba

cheers,

-Sunil

[Melanie · Accepted solution]

No, it is not. Check out

https://wiki.sdn.sap.com/wiki/x/UC8.

You need to logon as the owner of the aaplication data.

Regards, Melanie

[Former Member]

Thanks,

i found now a other Thread too