Thanks for the quick answer!
This is working indeed if I use dbmcli. But now I want to use the
query in my application, which creates an ODBC connection.
I changed the connection such that it logs in as DBA, which works
nicely. But now again the query retrieves 0 rows.
Is there some difference between dbmcli and UNIX-ODBC?
> Mathias Kettner wrote:
>
> > some months ago you told me that with
> >
> > SELECT * FROM serverdbstatistics
> >
> > i can get information about how much space is left in my
> > database. Unfortunately the answer to this statement
> > is always:
> >
> > ERR
> > -24988,ERR_SQL: sql error
> > 100,Row not found
> >
> >
> > Do I do something wrong here? I'm using 7.3.0.18 on SuSE 7.3
>
>
> Sorry, I should have mentioned that this systemview will result in 100,Row
> not found
> if a normal user will select it.
>
> If a DBA or the Database System Administrators (SYSDBA) selects this
> systemview
> it will show what you want to see.
>
--
Mathias .'\ /.
.'.-.-'.-..
..._: .-. .-. :_...
.' '-.(o ) (o ).-' .
: _ _ _~(_)~_ _ _ :
: /: ' .-=_ _=-. ;\ :
: :|-.._ ' _..-|: :
: :| |:-:-.-:-:'| |:' :
. .| | | | | | |.' .'
. -:_| | |_:-' .'
-._ ` _.-'
-------''
