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
