Re: [HACKERS] Decicision needed for connect statement

The : is used in Informix as the delimiter to a remote tablename like:
dns(at)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(at)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(at)localhost:5432.

Michael

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