[Info-vax] Rdb question

[Richard Maher]

On 22/07/2022 8:14 am, Arne Vajhøj wrote:
> On 7/21/2022 7:29 PM, Arne Vajhøj wrote:
>> 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.
>>
>> 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'
>>
>> ?
> 
> Now I have come up with:
> 
> CONNECT TO 'ATTACH ALIAS test FILENAME disk4:[rdb]test
> SET ALIAS 'test'
> 
> Is that the best?
> 
> Arne
> 
> 

Do you need to attach to the database more than once? Have multiple txns 
concurrently?

If not just drop the CONNECT. eg: ATTACH 'FILE disk4:[rdb]tes'; IIRC