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
Post a Comment