The : is used in Informix as the delimiter to a remote tablename like:
	dns@dns1ifx:dnstab
but I like the look of your dbname syntax.

I think it might still be a good Idea to start using a connection file like
Informix (sqlhosts) and Oracle (tnsnames.ora) use it, so we could have short names 
for our Instances and a flexible way to add additional config options in this file.

Informix has:
# shortname	protocol		hostname	service		additional 
zeusifx 		onsoctcp 	zeus 		sqlexec
zeusifxshm 	onipcshm 	zeus 		zeusifxshm
zvrentifx 	onsoctcp 	a1880104 	sqlexec7

Therefore:
	connect to dbname@shortname

Andreas

The say the connect statement has to have the following form:

CONNECT TO <SQL-server> [AS <connection name>] [USER <user name>]

It is implementation dependant how to get database name, server name resp.
number and port number from SQL-server. How will we do this?

How about this?

<dbname>@<server>:<port>

Each missing entry will be set to the default value:
template1@localhost:5432.

Michael

-- 
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10



Thu, 7 May 1998 15:28:49 +0200
Andreas Zeugswetter <andreas.zeugswetter@telecom.at>
Re: [HACKERS] Decicision needed for connect statement