EXEC sp_addlinkedserver
@server='DB2'
@srvproduct='Microsoft OLE DB Provider fro DB2',
@catalog='DB2',
@provider='DB2OLEDB',
@provstr='Initial catalog='PUBS;
Data Source=DB2;
HostCCSID=1252;
NetWork Address=XYZ;
NetWork Port=50000;
Package Collection=admin;
Default Schema=admin;


This is an example of the command line to link a dtabase on a DB2
server to SQL Server

How do I define the @provstr (NetWork Address, NetWork Port, HostCCSID) ?