General discussion

Locked

MS SQL Server-Delete -Openquery-Teradata-Linked

By sateesh_tummaganti ·
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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums