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
