Table Name:	exch_protocol
Table Number:	5141
Group:	Exchange Mgr
Description:	Describes each exchange partner's data exchange and communication protocols. Also defines the channel to reach an external partner
Flags:
Baseline/Custom:	Baseline

select * from table_exch_protocol

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
active	LONG	tinyint				DIRECT	Current status of the exchange partner; i.e., 0=inactive, 1=active, 2=pending
clfy_site_ind	LONG	tinyint			1	DIRECT	Indicates whether the target site is a clarify installation; i.e., 0=no, 1=yes, default=1
comm_param_0	CHAR	varchar		255			Communications parameter used in processing the exchange
comm_param_1	CHAR	varchar		255			Communications parameter used in processing the exchange
comm_param_2	CHAR	varchar		255			Communications parameter used in processing the exchange
comm_param_3	CHAR	varchar		255			Communications parameter used in processing the exchange
create_date	CLK_TIME	datetime					The date and time the object was created
cstm_schm_ind	LONG	tinyint			1	DIRECT	Indicates whether the target site will understand customized Vendor Interchange schema, i.e., X.790 conditional packages; i.e, 0=no, 1=yes, default=1
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dflt_mode	LONG	tinyint				DIRECT	Default exchange mode; i.e., 0=unknown, 1=transfer, 2=collaborative
exch_protocol	LONG	tinyint				DIRECT	Exchange standard protocol: i.e., 0=Clarify, 1=Z790, 2=CSC
ip_address	CHAR	varchar		15			IP address to be used
live_ind	LONG	tinyint				DIRECT	Status of the server; i.e., 0=down, 1=up
modify_date	CLK_TIME	datetime					The date and time the object was last modified
objid	LONG	int	3			DIRECT	Internal record number
port	CHAR	varchar		10			Port address
protocol	LONG	tinyint				DIRECT	Communication exchange protocol: i.e., 0=DCOM, 1=CORBA, 2=MSMQ, 3=HTTP
routing_mode	LONG	tinyint			0	DIRECT	Controls automated routing of create requests i.e., 0=none, 1=pending intervention), 2=unattended (route all create requests to service provider), 3=attended, default=0
server_id	LONG	int				DIRECT	Server ID number
server_name	CHAR	varchar		40			Server logical name

Relations:

Relation	Type	Target Object	Inverse Relation	Comment
protocol2exch_cat	MTO	exch_cat	cat2exch_protocol	Related exchange category
proto2exch_timebomb	OTM	exch_timebomb	bomb2exch_protocol	Exchange time bombs for the protocol
protocol2object_bind	OTM	object_bind	bind2exch_protocol	Related object bindings
proto2pro_hgl_role	OTM	pro_hgl_role	pro_hgl2exch_protocol	Related User-defined popup list usage
exch_protocol2site	OTM	site	site2exch_protocol	The exchange partner's site

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
server_name_ind	server_name	UNIQUE
server_id_ind	server_id	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
server_id_ind	server_id	nonclustered, unique located on PRIMARY
server_name_ind	server_name	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

exch_protocol

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog