[Info-vax] Rdb question

[Jan-Erik Söderholm]

Den 2022-07-22 kl. 01:29, skrev Arne Vajhøj:
> I am not good at Rdb.
> 
> CONNECT TO 'ATTACH FILENAME disk4:[rdb]test'
> 
> should connect to that database.
> 
> But it fails with alias already in use.

Yes, you probably already have an active attach
which uses the "default connection", and since you
did not specify a new "alias", it tried to use the
same default connection.

> 
> CONNECT TO 'ATTACH ALIAS test FILENAME disk4:[rdb]test'
> 
> works fine, but I have to prefix all table names with "test." and
> I do not like that.
> 
> What is the correct syntax for:
> 
> CONNECT TO 'ATTACH JUSTOVERWRITETHEDEFAULTALIAS FILENAME disk4:[rdb]test'

If you want a new default connection you need to DISCONNECT the open one.

> 
> ?
> 
> Arne
> 
> 

 From where are you doing that? Rdb interactive SQL?
Do you need multiple connections? If not, just use
a default connection and only use ATTACH.

I have never used CONNECT, only ATTACH, but otoh usually
only works with one database at a time.

I usually just define sql$database and get an automatic attach.