I have defined a linked server for db2/400. I have a sp on the db2 and when I execute the squel command I do not see any results:
Exec ('Call QGPL.getallcompanies') AT AS400SRV_IBMDASQL_OLEDB
Result: Command(s) completed successfully.
When I execute the same sp from iSeries navigator it shows me the result.
Could data be placed in a buffer since I cannot see them??
Also I am trying to change my query and use following (to see if that would show me the result):
select * from openquery (AS400SRV_IBMDASQL_OLEDB, 'Exec ('Call QGPL.getallcompanies')').
Here I get an error: Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'Call'.
Can anyone help?Try: (extra single quotes, not double)
select * from openquery (AS400SRV_IBMDASQL_OLEDB, 'Exec (''Call QGPL.getallcompanies'')').
No comments:
Post a Comment