Thomas, Knut wrote: > I have the problem, that the dbmcli 7.3.0 on linux answer > with more less > data rows as SQL Studio on Windows NT. > The connection was built with the same DB-User. > > The database runs on the linux. > > The problem is the SQL-statement: > > select * from ind_uses_col > > In my case I miss all rows mit REFCOLUMNNAME = 'SYSKEY' and some other > rows.
Just to make sure not to misunderstand: you expect the implicit created column (PRIMARY KEY-column) named SYSKEY to be returned if you ask for columns which are indexed ??? Did you manage (somehow, how?) to create an index where you specify this column in? The creation of an index specifying SYSKEY should not be possible. Do you think the so-called primary key is an index ? It is NOT, therefore there is no reason to include this primary key-column in the list of indexed columns. BTW: please do NOT use those systemviews xxx_USES_yyy. We are thinking of throwing them away and if you get used to use them, .... Please use those systemtables described in the reference manual. Ok, oops, I just found out that exactly the systemtable you were looking for was not described in there, grrrmpf. Sorry. It will be done with the next docu-version. The systemview is named DOMAIN.INDEXCOLUMNS. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
