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. > > Do you have an solution ???
After some mail from him in which he told, that SQL Studio results in 91 columns and DBMCLI in 51 I found out the following: SQL Studio uses ODBC. For some reason (I have forgotten, we have to check if it is necessary any more) applications using ODBC will receive not only those indexcolumns DBMCLI and C++Precompiler and the catalog-extract will see (and which are used in indexes specified), but additionally those 'indexes' named SYSPRIMARYKEYINDEX , i.e. for all tables the primary key-columns as if they were was specified as index. Depending what you want (inclusive primary key or not) some additional WHERE indexname <> 'SYSPRIMARYKEYINDEX' or UNION SELECT .... FROM DOMAIN.columns WHERE keypos > 0 are needed. Have a nice weekend Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
