ok - so i'll take another 2 tracks with this one. with universe set up in SQL Server as a linked database using unioledb :
1. how do we DELETE from a uv table ? DELETE FROM [LINKEDUVDB]...[TAB1] WHERE [FLD1] = 'SOMEVAL' DELETE FROM [LINKEDUVDB]...[TAB1] SELECT [EMAIL PROTECTED] FROM [LINKEDUVDB]...[TAB1] WHERE [FLD1]='SOMEVAL' DELETE FROM [LINKEDUVDB]...[TAB1] WHERE [EMAIL PROTECTED] IN ( SELECT [EMAIL PROTECTED] FROM [LINKEDUVDB]...[TAB1] WHERE [FLD1]='SOMEVAL') all generate : Server: Msg 7306, Level 16, State 2, Line 1 Could not open table 'TAB1' from OLE DB provider 'IBM.UniOLEDB'. The provider could not support a row lookup position. why is this ? I would have though that all universe tables have a unique column (row lookup position) in @ID ? select * from openquery([ODBC-BASIC] , 'DELETE FROM TAB1 WHERE FLD1 = ''SOMEVAL''') results in this 'informative' message : Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'IBM.UniOLEDB' reported an error. The provider did not give any information about the error. 2 . does anyone know how to execute a universe subroutine/command ? select * from openquery([ODBC-BASIC] , '*X'') select * from openquery([ODBC-BASIC] , 'CALL *X'') select * from openquery([ODBC-BASIC] , '{CALL *X}'') all result in : Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'IBM.UniOLEDB' reported an error. The provider did not give any information about the error. this seems to be the case for any statment other than SELECT exec [LINKEDUVDB]...[*X] results in : Server: Msg 7212, Level 17, State 1, Line 1 Could not execute procedure '*X' on remote server 'ODBC-BASIC'. gerry -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users