Discussion Locked

MS SQL Server-Delete -Openquery-Teradata-Linked

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Insert/Select/Delete openquery not working sql server to tereadata
1) successfully executed the bewlow query.
INSERT OPENQUERY(TeraDataSrv1, 'SELECT * from TVS.TVS1')values ('sateesh','sateesh','2003-10-24 00:00:00.000')
2)Select statement is working but not retrieving any records.
SELECT * from openquery(TeraDataSrv1, 'select * from TVS.TVS1')
3) Delete statement is giving error message.
Delete delete from openquery(TeraDataSrv1, 'select * from TVS.TVS1 where user_id = ''sateesh'' or appl_name = ''sateesh'' ')
4) Error:
Server: Msg 7345, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' could not delete from table '
select * from TVS.TVS1
where
user_id = 'ASYS012' or appl_name = 'sateesh'
'. There was a recoverable, pr...
[OLE/DB provider returned message: [NCR][Teradata RDBMS] Column User//ID not found in wrkdvp01.wrkvw005. ]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange:eleteRows returned 0x80040e21: DBROWSTATUS_E_FAIL].
5)TVS is a user and TVS1 is a View
I am having select, insert and delete permissions for that view and user in teradata.

Please reply

--Sateesh

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.