Re: [HACKERS] Decicision needed for connect statement

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