[Info-vax] Rdb question

[Arne Vajhøj]

On 7/21/2022 10:08 PM, Richard Maher wrote:
> 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?
> 
> 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

That worked. Thanks.

Arne