Call DB2 stored procedure from SQL Server 2008 linked server -


i have linked server sql server 2008 db2. linked server uses ibm drivers , not microsoft ones.

so works sql server:

exec ('call rertebt.get_definition (69,'''','''')') @ mylinkeddb2server 

this works using openquery... returning different data table

select rpmg_ety_cd,      row_cu_data_in, row_ef_dt, row_xpr_dt, rpmg_ety_nm  openquery           (mylinkeddb2server,                 'select                        rpmg_ety_cd,                       row_cu_data_in,                       row_ef_dt,                       row_xpr_dt,                       rpmg_ety_nm                  rertebt.v1rerrmm') 

however cannot select return data db2 sproc

this fails -

select flt_dfn_id, flt_src_dfn_no, flt_vrsn_no, flt_stat_cd, flt_ty_cd, flt_name        openquery (mylinkeddb2server,                           'call rertebt.get_definition 69,'''','''')') 

has idea on how call db2 stored procedure sql server linked server , return data or can done. read somewhere db2 cant haven't seen real documentation on it.

thanks d

more explanation josef's answer: need right-click linked server's "properties" -> "server option" "rpc" , "rpc out" option in right pane need true

-- edited -- can't comment on answer yet (don't have 50 rep)


Comments