Friday, March 9, 2012

Linked Server and db2/400

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