Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

echo "Your stdio isn't very std." -- Larry Wall in Configure from the perl distribution


computers / comp.os.vms / Re: Rdb question

SubjectAuthor
* Rdb questionArne Vajhøj
+* Re: Rdb questionArne Vajhøj
|`* Re: Rdb questionRichard Maher
| `- Re: Rdb questionArne Vajhøj
`* Re: Rdb questionJan-Erik Söderholm
 `* Re: Rdb questionArne Vajhøj
  `* Re: Rdb questionIanD
   `* Re: Rdb questionJan-Erik Söderholm
    `* Re: Rdb questionIanD
     +- Re: Rdb questionGreg Tinkler
     `* Re: Rdb questionArne Vajhøj
      `* Re: Rdb questionGreg Tinkler
       `* Re: Rdb questionRichard Maher
        `* Re: Rdb questionGreg Tinkler
         `* Re: Rdb questionRichard Maher
          `* Re: Rdb questionGreg Tinkler
           +* Re: Rdb questionRichard Maher
           |`* Re: Rdb questionGreg Tinkler
           | `* Re: Rdb questionRichard Maher
           |  `* Re: Rdb questionGreg Tinkler
           |   `* Re: Rdb questionRichard Maher
           |    `* Re: Rdb questionDave Froble
           |     `* Re: Rdb questionSimon Clubley
           |      `- Re: Rdb questionDave Froble
           `- Re: Rdb questionArne Vajhøj

1
Rdb question

<62d9e144$0$703$14726298@news.sunsite.dk>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23769&group=comp.os.vms#23769

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Thu, 21 Jul 2022 19:29:06 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Newsgroups: comp.os.vms
Content-Language: en-US
From: arn...@vajhoej.dk (Arne Vajhøj)
Subject: Rdb question
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 22
Message-ID: <62d9e144$0$703$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: 7002badc.news.sunsite.dk
X-Trace: 1658446149 news.sunsite.dk 703 arne@vajhoej.dk/68.9.63.232:55765
X-Complaints-To: staff@sunsite.dk
 by: Arne Vajhøj - Thu, 21 Jul 2022 23:29 UTC

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'

?

Arne

Re: Rdb question

<62d9ebe9$0$698$14726298@news.sunsite.dk>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23772&group=comp.os.vms#23772

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Thu, 21 Jul 2022 20:14:35 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Subject: Re: Rdb question
Content-Language: en-US
Newsgroups: comp.os.vms
References: <62d9e144$0$703$14726298@news.sunsite.dk>
From: arn...@vajhoej.dk (Arne Vajhøj)
In-Reply-To: <62d9e144$0$703$14726298@news.sunsite.dk>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Lines: 30
Message-ID: <62d9ebe9$0$698$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: 67fba77e.news.sunsite.dk
X-Trace: 1658448873 news.sunsite.dk 698 arne@vajhoej.dk/68.9.63.232:57083
X-Complaints-To: staff@sunsite.dk
 by: Arne Vajhøj - Fri, 22 Jul 2022 00:14 UTC

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

Re: Rdb question

<tbd0qu$v0b$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23774&group=comp.os.vms#23774

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!PqOvX6IGnPQwKdKFsHVyRA.user.46.165.242.75.POSTED!not-for-mail
From: maher_rj...@hotmail.com (Richard Maher)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Fri, 22 Jul 2022 10:08:33 +0800
Organization: Aioe.org NNTP Server
Message-ID: <tbd0qu$v0b$1@gioia.aioe.org>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<62d9ebe9$0$698$14726298@news.sunsite.dk>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Info: gioia.aioe.org; logging-data="31755"; posting-host="PqOvX6IGnPQwKdKFsHVyRA.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Content-Language: en-US
X-Notice: Filtered by postfilter v. 0.9.2
 by: Richard Maher - Fri, 22 Jul 2022 02:08 UTC

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

Re: Rdb question

<tbdjvm$2v4r1$1@dont-email.me>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23781&group=comp.os.vms#23781

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: jan-erik...@telia.com (Jan-Erik Söderholm)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Fri, 22 Jul 2022 09:35:19 +0200
Organization: A noiseless patient Spider
Lines: 44
Message-ID: <tbdjvm$2v4r1$1@dont-email.me>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Fri, 22 Jul 2022 07:35:18 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="768f9c2e03a14bacc200cb00e15aa259";
logging-data="3117921"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/8Afej79t9jmrMEIbNwYar"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.0.2
Cancel-Lock: sha1:SSn4dnM91i5PiBVp+PuOWycWg6M=
Content-Language: sv
In-Reply-To: <62d9e144$0$703$14726298@news.sunsite.dk>
 by: Jan-Erik Söderholm - Fri, 22 Jul 2022 07:35 UTC

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.

Re: Rdb question

<62dac5f2$0$699$14726298@news.sunsite.dk>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23793&group=comp.os.vms#23793

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.uzoreto.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Fri, 22 Jul 2022 11:44:50 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Subject: Re: Rdb question
Content-Language: en-US
Newsgroups: comp.os.vms
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<62d9ebe9$0$698$14726298@news.sunsite.dk> <tbd0qu$v0b$1@gioia.aioe.org>
From: arn...@vajhoej.dk (Arne Vajhøj)
In-Reply-To: <tbd0qu$v0b$1@gioia.aioe.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Lines: 40
Message-ID: <62dac5f2$0$699$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: c97ba3af.news.sunsite.dk
X-Trace: 1658504690 news.sunsite.dk 699 arne@vajhoej.dk/68.9.63.232:53477
X-Complaints-To: staff@sunsite.dk
 by: Arne Vajhøj - Fri, 22 Jul 2022 15:44 UTC

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

Re: Rdb question

<62dac65e$0$699$14726298@news.sunsite.dk>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23794&group=comp.os.vms#23794

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!news.uzoreto.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Fri, 22 Jul 2022 11:46:38 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Subject: Re: Rdb question
Content-Language: en-US
Newsgroups: comp.os.vms
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me>
From: arn...@vajhoej.dk (Arne Vajhøj)
In-Reply-To: <tbdjvm$2v4r1$1@dont-email.me>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Lines: 42
Message-ID: <62dac65e$0$699$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: c97ba3af.news.sunsite.dk
X-Trace: 1658504798 news.sunsite.dk 699 arne@vajhoej.dk/68.9.63.232:53477
X-Complaints-To: staff@sunsite.dk
 by: Arne Vajhøj - Fri, 22 Jul 2022 15:46 UTC

On 7/22/2022 3:35 AM, Jan-Erik Söderholm wrote:
> 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.

Yes. I just doesn't know where that connection comes from.

>> 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.

DISCONNECT did not help.

> From where are you doing that? Rdb interactive SQL?

Program using SQL Services.

> Do you need multiple connections? If not, just use
> a default connection and only use ATTACH.

That works!

:-)

Arne

Re: Rdb question

<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23822&group=comp.os.vms#23822

  copy link   Newsgroups: comp.os.vms
X-Received: by 2002:a37:af04:0:b0:6b5:e908:b2c7 with SMTP id y4-20020a37af04000000b006b5e908b2c7mr6289450qke.214.1658678508111;
Sun, 24 Jul 2022 09:01:48 -0700 (PDT)
X-Received: by 2002:a37:8a44:0:b0:6b5:f371:a183 with SMTP id
m65-20020a378a44000000b006b5f371a183mr6565484qkd.492.1658678507882; Sun, 24
Jul 2022 09:01:47 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Sun, 24 Jul 2022 09:01:47 -0700 (PDT)
In-Reply-To: <62dac65e$0$699$14726298@news.sunsite.dk>
Injection-Info: google-groups.googlegroups.com; posting-host=159.196.118.223; posting-account=0tEijwoAAAAMP4aWao59DU5bzWsrJu9_
NNTP-Posting-Host: 159.196.118.223
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me>
<62dac65e$0$699$14726298@news.sunsite.dk>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
Subject: Re: Rdb question
From: iloveope...@gmail.com (IanD)
Injection-Date: Sun, 24 Jul 2022 16:01:48 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 3072
 by: IanD - Sun, 24 Jul 2022 16:01 UTC

On Saturday, July 23, 2022 at 1:46:41 AM UTC+10, Arne Vajhøj wrote:
> On 7/22/2022 3:35 AM, Jan-Erik Söderholm wrote:
> > 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.
> Yes. I just doesn't know where that connection comes from.
> >> 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.
> DISCONNECT did not help.
> > From where are you doing that? Rdb interactive SQL?
> Program using SQL Services.
> > Do you need multiple connections? If not, just use
> > a default connection and only use ATTACH.
> That works!
>
> :-)
>
> Arne

I don't have access to RDB anymore so sorry if what I remember is wrong...

I think you used to be able to define a logical SQLINI that points to an initialization file where you can execute SQL commands prior to being dropped into interactive SQL. See if one exists and is pre-defining your db handle

DISCONNECT ALL; from memory is how you can disconnect from all prior attachments/aliases or perhaps DISCONNECT RDB$DBHANDLE ?

Looks like you've solved your issue anyhow, so this post is late to the call

Re: Rdb question

<tbk60e$p6u1$1@dont-email.me>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23823&group=comp.os.vms#23823

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: jan-erik...@telia.com (Jan-Erik Söderholm)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Sun, 24 Jul 2022 21:19:44 +0200
Organization: A noiseless patient Spider
Lines: 93
Message-ID: <tbk60e$p6u1$1@dont-email.me>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 24 Jul 2022 19:19:43 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="949c359dc7e7ce358fb47e995b304cb6";
logging-data="826305"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX195BGP0CbXoJikOEgLslZ3w"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.0.2
Cancel-Lock: sha1:rOyEhS3iJzl+Apm7Ax73mGZcK18=
In-Reply-To: <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
Content-Language: sv
 by: Jan-Erik Söderholm - Sun, 24 Jul 2022 19:19 UTC

Den 2022-07-24 kl. 18:01, skrev IanD:
> On Saturday, July 23, 2022 at 1:46:41 AM UTC+10, Arne Vajhøj wrote:
>> On 7/22/2022 3:35 AM, Jan-Erik Söderholm wrote:
>>> 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.
>> Yes. I just doesn't know where that connection comes from.
>>>> 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.
>> DISCONNECT did not help.
>>> From where are you doing that? Rdb interactive SQL?
>> Program using SQL Services.
>>> Do you need multiple connections? If not, just use
>>> a default connection and only use ATTACH.
>> That works!
>>
>> :-)
>>
>> Arne
>
>
> I don't have access to RDB anymore so sorry if what I remember is wrong...
>
> I think you used to be able to define a logical SQLINI that points to an initialization file wre you can execute SQL commands prior to being dropped into interactive SQL. See if one exists and is pre-defining your db handle
>
> DISCONNECT ALL; from memory is how you can disconnect from all prior attachments/aliases or perhaps DISCONNECT RDB$DBHANDLE ?
>
> Looks like you've solved your issue anyhow, so this post is late to the call

If you do not have an SQLINI file, or hasn't defined SQL$DATABASE, you
are not connected to any database when entering the SQL interactive CLI.
So you must do:

$ sql
SQL> ATTACH ....
SQL> SELECT ... FROM ...;

The easiest way is to simply define SQL$DATABASE in your LOGiN.COM, in
particluar if you usually access the same database.

SQLINI is usually used to "SET TRANSACTION READ ONLY;" since the default
transaction mode is READ WRITE, and that might give you to much locking
if you usually want to just read things.

When you need to actually update some thing, it is easy to do:

$ def/User sqlini " "
$ sql update ... SET xxx=1234;
$

The empty sqlini definition will only be active in that SQL session.

I ask my developers to try to *never* do:

$ SQL
SQL> select ...
SQL> commit (exit)
$

Since it is very easy to forget that "commit" and lock up things
for the production processes. So always do:

$ sql select ...
$

And you'll get an automatic commit when the select has finished.

You just need to have the SQL$DATABASE logical defined...

Jan-Erik.

Re: Rdb question

<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23827&group=comp.os.vms#23827

  copy link   Newsgroups: comp.os.vms
X-Received: by 2002:a05:6214:d82:b0:473:b41:aabf with SMTP id e2-20020a0562140d8200b004730b41aabfmr8921272qve.115.1658713538305;
Sun, 24 Jul 2022 18:45:38 -0700 (PDT)
X-Received: by 2002:ac8:5705:0:b0:31e:f49b:ed27 with SMTP id
5-20020ac85705000000b0031ef49bed27mr8865763qtw.16.1658713538130; Sun, 24 Jul
2022 18:45:38 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Sun, 24 Jul 2022 18:45:37 -0700 (PDT)
In-Reply-To: <tbk60e$p6u1$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=159.196.118.223; posting-account=0tEijwoAAAAMP4aWao59DU5bzWsrJu9_
NNTP-Posting-Host: 159.196.118.223
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me>
<62dac65e$0$699$14726298@news.sunsite.dk> <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
Subject: Re: Rdb question
From: iloveope...@gmail.com (IanD)
Injection-Date: Mon, 25 Jul 2022 01:45:38 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 6424
 by: IanD - Mon, 25 Jul 2022 01:45 UTC

On Monday, July 25, 2022 at 5:19:45 AM UTC+10, Jan-Erik Söderholm wrote:
> Den 2022-07-24 kl. 18:01, skrev IanD:
> > On Saturday, July 23, 2022 at 1:46:41 AM UTC+10, Arne Vajhøj wrote:
> >> On 7/22/2022 3:35 AM, Jan-Erik Söderholm wrote:
> >>> 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.
> >> Yes. I just doesn't know where that connection comes from.
> >>>> 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.
> >> DISCONNECT did not help.
> >>> From where are you doing that? Rdb interactive SQL?
> >> Program using SQL Services.
> >>> Do you need multiple connections? If not, just use
> >>> a default connection and only use ATTACH.
> >> That works!
> >>
> >> :-)
> >>
> >> Arne
> >
> >
> > I don't have access to RDB anymore so sorry if what I remember is wrong....
> >
> > I think you used to be able to define a logical SQLINI that points to an initialization file wre you can execute SQL commands prior to being dropped into interactive SQL. See if one exists and is pre-defining your db handle
> >
> > DISCONNECT ALL; from memory is how you can disconnect from all prior attachments/aliases or perhaps DISCONNECT RDB$DBHANDLE ?
> >
> > Looks like you've solved your issue anyhow, so this post is late to the call
> If you do not have an SQLINI file, or hasn't defined SQL$DATABASE, you
> are not connected to any database when entering the SQL interactive CLI.
> So you must do:
>
> $ sql
> SQL> ATTACH ....
> SQL> SELECT ... FROM ...;
>
> The easiest way is to simply define SQL$DATABASE in your LOGiN.COM, in
> particluar if you usually access the same database.
>
> SQLINI is usually used to "SET TRANSACTION READ ONLY;" since the default
> transaction mode is READ WRITE, and that might give you to much locking
> if you usually want to just read things.
>
> When you need to actually update some thing, it is easy to do:
>
> $ def/User sqlini " "
> $ sql update ... SET xxx=1234;
> $
>
> The empty sqlini definition will only be active in that SQL session.
>
> I ask my developers to try to *never* do:
>
> $ SQL
> SQL> select ...
> SQL> commit (exit)
> $
>
> Since it is very easy to forget that "commit" and lock up things
> for the production processes. So always do:
>
> $ sql select ...
> $
>
> And you'll get an automatic commit when the select has finished.
>
> You just need to have the SQL$DATABASE logical defined...
>
> Jan-Erik.

The point of creating your own definition of SQLINI is to ensure you can start with your own clean slate as it was stated they already had a default connection and they didn't know where it came from

>>> Yes. I just doesn't know where that connection comes from.

Totally agree about the SET TRANS READ ONLY
Not sure why Digital made the default to READ WRITE, not smart from Production environments.

We used to drive everything explicitly through scripts wherever possible rather than rely on expected environment logicals to be there. If developers felt the need to define rdb*m$ logicals then push them through managed scripts. rdb debug flags are an exception of course.

I wonder how fast rdb on x86 hardware will be?

We could never fix the database Page Size on some of our databases as they could not be exported/imported with a new options definition due to their large sizes (some projections calculated we would need more than a two week outage! - that was on an Alpha GS1280 though)

I used to use Oracle trace a lot to nut out performance issues with acms + rdb (if you want to chew through disk space real quick fire up a debug Oracle Trace collection with acms+rdb!).

I even had a crack at rdb expert, not that I could get much sense out of it, our databases exceeded what the product was originally sized to cope for, and after logging a number of tickets to get help, I realised the product was more hype than expert, lol.

What a fantastic product rdb was/is, shame Digital 'gave it away', I wonder if Oracle would ever consider selling it back to VSI ?

It all brings back fond memories...

Re: Rdb question

<d3125bff-78c4-4d39-bb3d-de0c6f798d96n@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23831&group=comp.os.vms#23831

  copy link   Newsgroups: comp.os.vms
X-Received: by 2002:a05:622a:19a2:b0:31e:eecb:2af8 with SMTP id u34-20020a05622a19a200b0031eeecb2af8mr9452859qtc.651.1658738442960;
Mon, 25 Jul 2022 01:40:42 -0700 (PDT)
X-Received: by 2002:a05:6214:4015:b0:474:15d9:ce76 with SMTP id
kd21-20020a056214401500b0047415d9ce76mr9225681qvb.86.1658738442782; Mon, 25
Jul 2022 01:40:42 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Mon, 25 Jul 2022 01:40:42 -0700 (PDT)
In-Reply-To: <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=49.176.150.5; posting-account=N9Q8kAoAAACE4Wg6nhCkJI0wEBaOLnQX
NNTP-Posting-Host: 49.176.150.5
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me>
<62dac65e$0$699$14726298@news.sunsite.dk> <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me> <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d3125bff-78c4-4d39-bb3d-de0c6f798d96n@googlegroups.com>
Subject: Re: Rdb question
From: tinkl...@gmail.com (Greg Tinkler)
Injection-Date: Mon, 25 Jul 2022 08:40:42 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1480
 by: Greg Tinkler - Mon, 25 Jul 2022 08:40 UTC

>>> What a fantastic product rdb was/is, shame Digital 'gave it away', I wonder if Oracle would ever consider selling it back to VSI ?

Now there is an idea....
gt

Re: Rdb question

<62df2710$0$705$14726298@news.sunsite.dk>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23853&group=comp.os.vms#23853

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!news.uzoreto.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Mon, 25 Jul 2022 19:28:15 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Subject: Re: Rdb question
Content-Language: en-US
Newsgroups: comp.os.vms
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
From: arn...@vajhoej.dk (Arne Vajhøj)
In-Reply-To: <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 28
Message-ID: <62df2710$0$705$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: fdd636c5.news.sunsite.dk
X-Trace: 1658791696 news.sunsite.dk 705 arne@vajhoej.dk/68.9.63.232:50536
X-Complaints-To: staff@sunsite.dk
 by: Arne Vajhøj - Mon, 25 Jul 2022 23:28 UTC

On 7/24/2022 9:45 PM, IanD wrote:
> I wonder how fast rdb on x86 hardware will be?
>
> We could never fix the database Page Size on some of our databases as
> they could not be exported/imported with a new options definition due
> to their large sizes (some projections calculated we would need more
> than a two week outage! - that was on an Alpha GS1280 though)

A lot of database work is IO bound not CPU bound.

SSD disks would speed up things a lot.

> What a fantastic product rdb was/is, shame Digital 'gave it away', I
> wonder if Oracle would ever consider selling it back to VSI ?

I think it was a big mistake to sell Rdb to Oracle back then.
There were obviously a lot of money to be made.

But today? The VMS market has shrunk a lot. And I suspect
most totally new development would go for MySQL/MariaDB or
PostgreSQL (when it becomes available). Unless Oracle
is willing to sell it cheap then I don't see a good
business case for VSI. And selling cheap is not Larry's
MO.

Arne

Re: Rdb question

<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23885&group=comp.os.vms#23885

  copy link   Newsgroups: comp.os.vms
X-Received: by 2002:a37:6c5:0:b0:6b5:ba8e:6673 with SMTP id 188-20020a3706c5000000b006b5ba8e6673mr15081274qkg.774.1658901040338;
Tue, 26 Jul 2022 22:50:40 -0700 (PDT)
X-Received: by 2002:a05:622a:24b:b0:31f:9e4:2875 with SMTP id
c11-20020a05622a024b00b0031f09e42875mr17498405qtx.492.1658901040177; Tue, 26
Jul 2022 22:50:40 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Tue, 26 Jul 2022 22:50:39 -0700 (PDT)
In-Reply-To: <62df2710$0$705$14726298@news.sunsite.dk>
Injection-Info: google-groups.googlegroups.com; posting-host=49.176.150.5; posting-account=N9Q8kAoAAACE4Wg6nhCkJI0wEBaOLnQX
NNTP-Posting-Host: 49.176.150.5
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me>
<62dac65e$0$699$14726298@news.sunsite.dk> <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me> <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
Subject: Re: Rdb question
From: tinkl...@gmail.com (Greg Tinkler)
Injection-Date: Wed, 27 Jul 2022 05:50:40 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1865
 by: Greg Tinkler - Wed, 27 Jul 2022 05:50 UTC

> And selling cheap is not Larry's MO.
Buying cheap is... Rdb cost Oracle $US108M, which was made back from license charges in the first 12 months!
The sale was inked 29 years ago (1993), and went through in 1994. Such a sad time at Digital, the 1993 recommendation to the board was for Digital to become a software company with Rdb as the center piece, this was rejected as Rdb had already been sold. Mumble!

Oh well, MariaDB and PostgreSQL for OpenVMS.

gt

Re: Rdb question

<tbqqhs$c0n$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23887&group=comp.os.vms#23887

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!PqOvX6IGnPQwKdKFsHVyRA.user.46.165.242.75.POSTED!not-for-mail
From: maher_rj...@hotmail.com (Richard Maher)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Wed, 27 Jul 2022 15:47:07 +0800
Organization: Aioe.org NNTP Server
Message-ID: <tbqqhs$c0n$1@gioia.aioe.org>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="12311"; posting-host="PqOvX6IGnPQwKdKFsHVyRA.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Content-Language: en-US
X-Notice: Filtered by postfilter v. 0.9.2
 by: Richard Maher - Wed, 27 Jul 2022 07:47 UTC

On 27/07/2022 1:50 pm, Greg Tinkler wrote:
>> And selling cheap is not Larry's MO.
> Buying cheap is... Rdb cost Oracle $US108M, which was made back from
> license charges in the first 12 months! The sale was inked 29 years
> ago (1993), and went through in 1994. Such a sad time at Digital,
> the 1993 recommendation to the board was for Digital to become a
> software company with Rdb as the center piece, this was rejected as
> Rdb had already been sold. Mumble!
>
> Oh well, MariaDB and PostgreSQL for OpenVMS.
>
> gt

Don't forget that *all* the Rdb "engineers" were gloating about leaving
VMS and going to Windows :-(

Sadly those assassins have eked out a living watching Rdb/VMS flounder

Re: Rdb question

<065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23905&group=comp.os.vms#23905

  copy link   Newsgroups: comp.os.vms
X-Received: by 2002:ac8:7fcd:0:b0:31f:393a:7320 with SMTP id b13-20020ac87fcd000000b0031f393a7320mr13229047qtk.11.1658966393727;
Wed, 27 Jul 2022 16:59:53 -0700 (PDT)
X-Received: by 2002:a05:622a:47:b0:31f:3320:6956 with SMTP id
y7-20020a05622a004700b0031f33206956mr18019675qtw.350.1658966393552; Wed, 27
Jul 2022 16:59:53 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Wed, 27 Jul 2022 16:59:53 -0700 (PDT)
In-Reply-To: <tbqqhs$c0n$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=49.176.150.5; posting-account=N9Q8kAoAAACE4Wg6nhCkJI0wEBaOLnQX
NNTP-Posting-Host: 49.176.150.5
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me>
<62dac65e$0$699$14726298@news.sunsite.dk> <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me> <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk> <0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
Subject: Re: Rdb question
From: tinkl...@gmail.com (Greg Tinkler)
Injection-Date: Wed, 27 Jul 2022 23:59:53 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 2537
 by: Greg Tinkler - Wed, 27 Jul 2022 23:59 UTC

> Don't forget that *all* the Rdb "engineers" were gloating about leaving
> VMS and going to Windows :-(
>
> Sadly those assassins have eked out a living watching Rdb/VMS flounder

SORRY WHAT!!! No they where not.
Yes, they where in the process of porting Rdb on to other platforms, which was the correct business thing to do. At the time was very much looking forward to it, and that it would help drive the OpenVMS sales...

As a group they where collateral damage of the decision by Palmer, and nothing they had a choice in.

The fact that the Rdb group still exists after such a long time is incredible, and due in part that they where probably the best engineering team in Digital at the time, and some of that skill has been used in the main Oracle RDMS toolset...

What we need to focus on now is getting OpenVMS back to where it should be, a fully 64 bit premier secure OS.

OpenVMS floundering has a lot more to do with the lack of engineering foresight and skill over the last 30 years, driven by commercial interests that did not understand the product and wanting to keep the cost low.

gt

Re: Rdb question

<tbsmgi$1hks$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23907&group=comp.os.vms#23907

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!PqOvX6IGnPQwKdKFsHVyRA.user.46.165.242.75.POSTED!not-for-mail
From: maher_rj...@hotmail.com (Richard Maher)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Thu, 28 Jul 2022 08:50:26 +0800
Organization: Aioe.org NNTP Server
Message-ID: <tbsmgi$1hks$1@gioia.aioe.org>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org>
<065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="50844"; posting-host="PqOvX6IGnPQwKdKFsHVyRA.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Content-Language: en-US
X-Notice: Filtered by postfilter v. 0.9.2
 by: Richard Maher - Thu, 28 Jul 2022 00:50 UTC

On 28/07/2022 7:59 am, Greg Tinkler wrote:
>> Don't forget that *all* the Rdb "engineers" were gloating about leaving
>> VMS and going to Windows :-(
>>
>> Sadly those assassins have eked out a living watching Rdb/VMS flounder
>
> SORRY WHAT!!! No they where not.
> Yes, they where in the process of porting Rdb on to other platforms, which was the correct business thing to do. At the time was very much looking forward to it, and that it would help drive the OpenVMS sales...
>
> As a group they where collateral damage of the decision by Palmer, and nothing they had a choice in.
>
> The fact that the Rdb group still exists after such a long time is incredible, and due in part that they where probably the best engineering team in Digital at the time, and some of that skill has been used in the main Oracle RDMS toolset...
>
> What we need to focus on now is getting OpenVMS back to where it should be, a fully 64 bit premier secure OS.
>
> OpenVMS floundering has a lot more to do with the lack of engineering foresight and skill over the last 30 years, driven by commercial interests that did not understand the product and wanting to keep the cost low.
>
> gt

I beg to differ. My recollection is Rdb/VMS was being considered
technical debt. Before Larry canned Rdb/Windows

Re: Rdb question

<0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23909&group=comp.os.vms#23909

  copy link   Newsgroups: comp.os.vms
X-Received: by 2002:ac8:5953:0:b0:31f:3566:8cff with SMTP id 19-20020ac85953000000b0031f35668cffmr16519751qtz.96.1658974241772;
Wed, 27 Jul 2022 19:10:41 -0700 (PDT)
X-Received: by 2002:a05:620a:240b:b0:6b5:f9af:2412 with SMTP id
d11-20020a05620a240b00b006b5f9af2412mr18662534qkn.457.1658974241629; Wed, 27
Jul 2022 19:10:41 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Wed, 27 Jul 2022 19:10:41 -0700 (PDT)
In-Reply-To: <tbsmgi$1hks$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=49.176.150.5; posting-account=N9Q8kAoAAACE4Wg6nhCkJI0wEBaOLnQX
NNTP-Posting-Host: 49.176.150.5
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me>
<62dac65e$0$699$14726298@news.sunsite.dk> <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me> <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk> <0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org> <065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
Subject: Re: Rdb question
From: tinkl...@gmail.com (Greg Tinkler)
Injection-Date: Thu, 28 Jul 2022 02:10:41 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1915
 by: Greg Tinkler - Thu, 28 Jul 2022 02:10 UTC

> I beg to differ. My recollection is Rdb/VMS was being considered
> technical debt. Before Larry canned Rdb/Windows

'Technical debt' by whom? Larry canned Rdb/Windows (&Unix) as it would have competed against Oracle RDMS...
More interesting is what happened to Rdb*Star :-)) and why.
If you noticed at the time a lot of the Rdb technology/memes where used in the re-engineering of Oracle RDMS.

gt

Re: Rdb question

<tbt7ur$e6f$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23910&group=comp.os.vms#23910

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!PqOvX6IGnPQwKdKFsHVyRA.user.46.165.242.75.POSTED!not-for-mail
From: maher_rj...@hotmail.com (Richard Maher)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Thu, 28 Jul 2022 13:48:11 +0800
Organization: Aioe.org NNTP Server
Message-ID: <tbt7ur$e6f$1@gioia.aioe.org>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org>
<065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org>
<0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="14543"; posting-host="PqOvX6IGnPQwKdKFsHVyRA.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
X-Notice: Filtered by postfilter v. 0.9.2
Content-Language: en-US
 by: Richard Maher - Thu, 28 Jul 2022 05:48 UTC

On 28/07/2022 10:10 am, Greg Tinkler wrote:
>> I beg to differ. My recollection is Rdb/VMS was being considered
>> technical debt. Before Larry canned Rdb/Windows
>
> 'Technical debt' by whom? Larry canned Rdb/Windows (&Unix) as it would have competed against Oracle RDMS...
> More interesting is what happened to Rdb*Star :-)) and why.
> If you noticed at the time a lot of the Rdb technology/memes where used in the re-engineering of Oracle RDMS.
>
> gt
1) Stephen Smith
2) Norm La Stoviva
.. . .

Re: Rdb question

<935a7373-b12e-4e00-b4fe-11daede2fdd8n@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23911&group=comp.os.vms#23911

  copy link   Newsgroups: comp.os.vms
X-Received: by 2002:a05:6214:e4e:b0:474:60d:94c5 with SMTP id o14-20020a0562140e4e00b00474060d94c5mr22152965qvc.11.1658989062274;
Wed, 27 Jul 2022 23:17:42 -0700 (PDT)
X-Received: by 2002:ac8:58d2:0:b0:31e:eecb:2b1d with SMTP id
u18-20020ac858d2000000b0031eeecb2b1dmr21053076qta.30.1658989062093; Wed, 27
Jul 2022 23:17:42 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Wed, 27 Jul 2022 23:17:41 -0700 (PDT)
In-Reply-To: <tbt7ur$e6f$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=49.176.150.5; posting-account=N9Q8kAoAAACE4Wg6nhCkJI0wEBaOLnQX
NNTP-Posting-Host: 49.176.150.5
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me>
<62dac65e$0$699$14726298@news.sunsite.dk> <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me> <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk> <0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org> <065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org> <0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
<tbt7ur$e6f$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <935a7373-b12e-4e00-b4fe-11daede2fdd8n@googlegroups.com>
Subject: Re: Rdb question
From: tinkl...@gmail.com (Greg Tinkler)
Injection-Date: Thu, 28 Jul 2022 06:17:42 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1857
 by: Greg Tinkler - Thu, 28 Jul 2022 06:17 UTC

> 1) Stephen Smith
Don't recognize the name.., Ian Smith on the other hand.
> 2) Norm La Stoviva
I assume you mean Norm Lastovica, who did a lot of interesting engineering with Rdb, record caching for one.

So just what do you mean by 'technical debt'?

gt

Re: Rdb question

<62e31dc8$0$703$14726298@news.sunsite.dk>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23935&group=comp.os.vms#23935

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!news.uzoreto.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Thu, 28 Jul 2022 19:37:42 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
Subject: Re: Rdb question
Content-Language: en-US
Newsgroups: comp.os.vms
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org>
<065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org>
<0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
From: arn...@vajhoej.dk (Arne Vajhøj)
In-Reply-To: <0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 13
Message-ID: <62e31dc8$0$703$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: 7484f2e4.news.sunsite.dk
X-Trace: 1659051464 news.sunsite.dk 703 arne@vajhoej.dk/68.9.63.232:53997
X-Complaints-To: staff@sunsite.dk
 by: Arne Vajhøj - Thu, 28 Jul 2022 23:37 UTC

On 7/27/2022 10:10 PM, Greg Tinkler wrote:
>> I beg to differ. My recollection is Rdb/VMS was being considered
>> technical debt. Before Larry canned Rdb/Windows
>
> 'Technical debt' by whom? Larry canned Rdb/Windows (&Unix) as it would have competed against Oracle RDMS...

The usual explanation is that Oracle could not get any guarantees
that Bliss would continue to be available on Windows so they
dropped Rdb on Windows.

Arne

Re: Rdb question

<tbvf2k$129u$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23938&group=comp.os.vms#23938

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!PqOvX6IGnPQwKdKFsHVyRA.user.46.165.242.75.POSTED!not-for-mail
From: maher_rj...@hotmail.com (Richard Maher)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Fri, 29 Jul 2022 10:01:57 +0800
Organization: Aioe.org NNTP Server
Message-ID: <tbvf2k$129u$1@gioia.aioe.org>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org>
<065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org>
<0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
<tbt7ur$e6f$1@gioia.aioe.org>
<935a7373-b12e-4e00-b4fe-11daede2fdd8n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="35134"; posting-host="PqOvX6IGnPQwKdKFsHVyRA.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
X-Notice: Filtered by postfilter v. 0.9.2
Content-Language: en-US
 by: Richard Maher - Fri, 29 Jul 2022 02:01 UTC

On 28/07/2022 2:17 pm, Greg Tinkler wrote:
>> 1) Stephen Smith
> Don't recognize the name.., Ian Smith on the other hand.
>> 2) Norm La Stoviva
> I assume you mean Norm Lastovica, who did a lot of interesting engineering with Rdb, record caching for one.
>
> So just what do you mean by 'technical debt'?
>
> gt

Yes, Ian. I slipped with my memory's more recently accessed Cricket ball
tampering Aussie.

By technical debt, I mean "legacy", "mothballed patch only", "on it's
way to being deprecated",

Re: Rdb question

<bdcb71e4-c16d-4574-b46e-0d8a1fb772ffn@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23939&group=comp.os.vms#23939

  copy link   Newsgroups: comp.os.vms
X-Received: by 2002:a05:6214:1c8c:b0:473:408f:ddd6 with SMTP id ib12-20020a0562141c8c00b00473408fddd6mr1650757qvb.74.1659060933367;
Thu, 28 Jul 2022 19:15:33 -0700 (PDT)
X-Received: by 2002:a05:620a:45a9:b0:6b6:895:2d2 with SMTP id
bp41-20020a05620a45a900b006b6089502d2mr1325619qkb.70.1659060933214; Thu, 28
Jul 2022 19:15:33 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.os.vms
Date: Thu, 28 Jul 2022 19:15:32 -0700 (PDT)
In-Reply-To: <tbvf2k$129u$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=49.176.150.5; posting-account=N9Q8kAoAAACE4Wg6nhCkJI0wEBaOLnQX
NNTP-Posting-Host: 49.176.150.5
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me>
<62dac65e$0$699$14726298@news.sunsite.dk> <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me> <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk> <0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org> <065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org> <0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
<tbt7ur$e6f$1@gioia.aioe.org> <935a7373-b12e-4e00-b4fe-11daede2fdd8n@googlegroups.com>
<tbvf2k$129u$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <bdcb71e4-c16d-4574-b46e-0d8a1fb772ffn@googlegroups.com>
Subject: Re: Rdb question
From: tinkl...@gmail.com (Greg Tinkler)
Injection-Date: Fri, 29 Jul 2022 02:15:33 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 2493
 by: Greg Tinkler - Fri, 29 Jul 2022 02:15 UTC

> Yes, Ian. I slipped with my memory's more recently accessed Cricket ball tampering Aussie.
Thought the name was sort of familiar, dam the sand-paper :-]
> By technical debt, I mean "legacy", "mothballed patch only", "on it's way to being deprecated",
That sort of has been the case for almost 30 years, but it is still there, and from a SQL point of view Rdb is in an ok place. Ian has not been backward in adding new features, so not just patch only.
Does the engine need work, yup, as does OpenVMS internals..., and some of the limitations will be because Rdb is limited to OpenVMS. Still the best database engine on OpenVMS.

Besides at $US40k/core Rdb (Oracle) is far too expensive for most sites. Bring back Rdb runtime for free on OpenVMS I say. Won't happen but a nice thought.

gt

Re: Rdb question

<tc00s0$bcq$1@gioia.aioe.org>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23940&group=comp.os.vms#23940

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!PqOvX6IGnPQwKdKFsHVyRA.user.46.165.242.75.POSTED!not-for-mail
From: maher_rj...@hotmail.com (Richard Maher)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Fri, 29 Jul 2022 15:05:36 +0800
Organization: Aioe.org NNTP Server
Message-ID: <tc00s0$bcq$1@gioia.aioe.org>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org>
<065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org>
<0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
<tbt7ur$e6f$1@gioia.aioe.org>
<935a7373-b12e-4e00-b4fe-11daede2fdd8n@googlegroups.com>
<tbvf2k$129u$1@gioia.aioe.org>
<bdcb71e4-c16d-4574-b46e-0d8a1fb772ffn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="11674"; posting-host="PqOvX6IGnPQwKdKFsHVyRA.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101
Thunderbird/91.11.0
X-Notice: Filtered by postfilter v. 0.9.2
Content-Language: en-US
 by: Richard Maher - Fri, 29 Jul 2022 07:05 UTC

On 29/07/2022 10:15 am, Greg Tinkler wrote:
>> Yes, Ian. I slipped with my memory's more recently accessed Cricket ball tampering Aussie.
> Thought the name was sort of familiar, dam the sand-paper :-]
>
>> By technical debt, I mean "legacy", "mothballed patch only", "on it's way to being deprecated",
> That sort of has been the case for almost 30 years, but it is still there, and from a SQL point of view Rdb is in an ok place. Ian has not been backward in adding new features, so not just patch only.
> Does the engine need work, yup, as does OpenVMS internals..., and some of the limitations will be because Rdb is limited to OpenVMS. Still the best database engine on OpenVMS.
>
> Besides at $US40k/core Rdb (Oracle) is far too expensive for most sites. Bring back Rdb runtime for free on OpenVMS I say. Won't happen but a nice thought.
>
> gt

Look, the game's over :-(

Was Rdb technical elegance? Sure!

There's lots to dislike about Orrible Oracle, but shit like Cache
Fusion, RLAC/Fine-Grained security, sheer weight of numbers and SQL
Server is still brilliant.

VGI should have sold their mother to get Oracle continued on VMS!!! :-(

For those of us still dreaming; that my friends, was the death knell.

Re: Rdb question

<tc116l$3i1lq$1@dont-email.me>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23947&group=comp.os.vms#23947

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: dav...@tsoft-inc.com (Dave Froble)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Fri, 29 Jul 2022 12:17:25 -0400
Organization: A noiseless patient Spider
Lines: 52
Message-ID: <tc116l$3i1lq$1@dont-email.me>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org>
<065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org>
<0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
<tbt7ur$e6f$1@gioia.aioe.org>
<935a7373-b12e-4e00-b4fe-11daede2fdd8n@googlegroups.com>
<tbvf2k$129u$1@gioia.aioe.org>
<bdcb71e4-c16d-4574-b46e-0d8a1fb772ffn@googlegroups.com>
<tc00s0$bcq$1@gioia.aioe.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 29 Jul 2022 16:17:25 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="26cfb782fa98bed09f011a585a2627a7";
logging-data="3737274"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+n9imNkJPbZyMXAD4fQ6DgxU47o2Tsfo4="
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:45.0) Gecko/20100101
Thunderbird/45.8.0
Cancel-Lock: sha1:KAo2I78tOu1uIP9m+lz67lZ+H8Y=
In-Reply-To: <tc00s0$bcq$1@gioia.aioe.org>
 by: Dave Froble - Fri, 29 Jul 2022 16:17 UTC

On 7/29/2022 3:05 AM, Richard Maher wrote:
> On 29/07/2022 10:15 am, Greg Tinkler wrote:
>>> Yes, Ian. I slipped with my memory's more recently accessed Cricket ball
>>> tampering Aussie.
>> Thought the name was sort of familiar, dam the sand-paper :-]
>>
>>> By technical debt, I mean "legacy", "mothballed patch only", "on it's way to
>>> being deprecated",
>> That sort of has been the case for almost 30 years, but it is still there, and
>> from a SQL point of view Rdb is in an ok place. Ian has not been backward in
>> adding new features, so not just patch only.
>> Does the engine need work, yup, as does OpenVMS internals..., and some of the
>> limitations will be because Rdb is limited to OpenVMS. Still the best
>> database engine on OpenVMS.
>>
>> Besides at $US40k/core Rdb (Oracle) is far too expensive for most sites.
>> Bring back Rdb runtime for free on OpenVMS I say. Won't happen but a nice
>> thought.
>>
>> gt
>
> Look, the game's over :-(
>
> Was Rdb technical elegance? Sure!
>
> There's lots to dislike about Orrible Oracle, but shit like Cache Fusion,
> RLAC/Fine-Grained security, sheer weight of numbers and SQL Server is still
> brilliant.
>
> VGI should have sold their mother to get Oracle continued on VMS!!! :-(
>
> For those of us still dreaming; that my friends, was the death knell.

I partly understand, but, I still have to ask, why when there is a personal
"death knell", that person then extends it to everyone else?

Yeah, one can go on and on about some nice product/feature, but that does not
mean that everyone uses it.

I've never used Rdb, nor Oracle. I've produced some fine (in my opinion)
applications over the years, and the only opinion that matters is the customer's
opinion, and I've had some very satisfied customers.

So Richard, I'm sorry for you that you do not have what you wish for, but just
because your boat is sinking doesn't mean that the whole planet is in your boat.

--
David Froble Tel: 724-529-0450
Dave Froble Enterprises, Inc. E-Mail: davef@tsoft-inc.com
DFE Ultralights, Inc.
170 Grimplin Road
Vanderbilt, PA 15486

Re: Rdb question

<tc1627$3iirh$1@dont-email.me>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23954&group=comp.os.vms#23954

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: club...@remove_me.eisner.decus.org-Earth.UFP (Simon Clubley)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Fri, 29 Jul 2022 17:40:23 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 28
Message-ID: <tc1627$3iirh$1@dont-email.me>
References: <62d9e144$0$703$14726298@news.sunsite.dk> <tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk> <4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com> <tbk60e$p6u1$1@dont-email.me> <e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com> <62df2710$0$705$14726298@news.sunsite.dk> <0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com> <tbqqhs$c0n$1@gioia.aioe.org> <065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com> <tbsmgi$1hks$1@gioia.aioe.org> <0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com> <tbt7ur$e6f$1@gioia.aioe.org> <935a7373-b12e-4e00-b4fe-11daede2fdd8n@googlegroups.com> <tbvf2k$129u$1@gioia.aioe.org> <bdcb71e4-c16d-4574-b46e-0d8a1fb772ffn@googlegroups.com> <tc00s0$bcq$1@gioia.aioe.org> <tc116l$3i1lq$1@dont-email.me>
Injection-Date: Fri, 29 Jul 2022 17:40:23 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="2a662feb64c91951e26a6f7699435391";
logging-data="3754865"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19CpNchTonkW0CzpMy9PQt+OkkQMmJ6Bkw="
User-Agent: slrn/0.9.8.1 (VMS/Multinet)
Cancel-Lock: sha1:JMeFh8ulq/NDz/GFk4Rsa08hjWM=
 by: Simon Clubley - Fri, 29 Jul 2022 17:40 UTC

On 2022-07-29, Dave Froble <davef@tsoft-inc.com> wrote:
> On 7/29/2022 3:05 AM, Richard Maher wrote:
>>
>> VGI should have sold their mother to get Oracle continued on VMS!!! :-(
>>
>> For those of us still dreaming; that my friends, was the death knell.
>
> I partly understand, but, I still have to ask, why when there is a personal
> "death knell", that person then extends it to everyone else?
>

Because while you might be comfy in your own little world, you only get
to play in that world because there's enough people doing other things
that makes it profitable enough for VSI to continue making software for
you to play with.

> Yeah, one can go on and on about some nice product/feature, but that does not
> mean that everyone uses it.
>

Losing enough major third-party applications can be the difference
between a port to x86-64 being viable and not being viable.

Simon.

--
Simon Clubley, clubley@remove_me.eisner.decus.org-Earth.UFP
Walking destinations on a map are further away than they appear.

Re: Rdb question

<tc1726$3imom$2@dont-email.me>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=23958&group=comp.os.vms#23958

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: dav...@tsoft-inc.com (Dave Froble)
Newsgroups: comp.os.vms
Subject: Re: Rdb question
Date: Fri, 29 Jul 2022 13:57:27 -0400
Organization: A noiseless patient Spider
Lines: 37
Message-ID: <tc1726$3imom$2@dont-email.me>
References: <62d9e144$0$703$14726298@news.sunsite.dk>
<tbdjvm$2v4r1$1@dont-email.me> <62dac65e$0$699$14726298@news.sunsite.dk>
<4dd8800c-abdf-41d1-82e5-80a06f66a354n@googlegroups.com>
<tbk60e$p6u1$1@dont-email.me>
<e80041b5-949f-454b-8b9c-4bbd6fe4f63dn@googlegroups.com>
<62df2710$0$705$14726298@news.sunsite.dk>
<0fa4c020-7e45-44d4-a45a-6ea8454be3ebn@googlegroups.com>
<tbqqhs$c0n$1@gioia.aioe.org>
<065e0f25-5928-423f-ad0e-989035b0e47dn@googlegroups.com>
<tbsmgi$1hks$1@gioia.aioe.org>
<0b78041b-e056-4521-be3b-e3e226960dfan@googlegroups.com>
<tbt7ur$e6f$1@gioia.aioe.org>
<935a7373-b12e-4e00-b4fe-11daede2fdd8n@googlegroups.com>
<tbvf2k$129u$1@gioia.aioe.org>
<bdcb71e4-c16d-4574-b46e-0d8a1fb772ffn@googlegroups.com>
<tc00s0$bcq$1@gioia.aioe.org> <tc116l$3i1lq$1@dont-email.me>
<tc1627$3iirh$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 29 Jul 2022 17:57:26 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="26cfb782fa98bed09f011a585a2627a7";
logging-data="3758870"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+IkD8hqk22HOL06IPEwZ/UCEkydV5rJsg="
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:45.0) Gecko/20100101
Thunderbird/45.8.0
Cancel-Lock: sha1:cEmqvilDP/XjpgHiCZ3aF61AoFc=
In-Reply-To: <tc1627$3iirh$1@dont-email.me>
 by: Dave Froble - Fri, 29 Jul 2022 17:57 UTC

On 7/29/2022 1:40 PM, Simon Clubley wrote:
> On 2022-07-29, Dave Froble <davef@tsoft-inc.com> wrote:
>> On 7/29/2022 3:05 AM, Richard Maher wrote:
>>>
>>> VGI should have sold their mother to get Oracle continued on VMS!!! :-(
>>>
>>> For those of us still dreaming; that my friends, was the death knell.
>>
>> I partly understand, but, I still have to ask, why when there is a personal
>> "death knell", that person then extends it to everyone else?
>>
>
> Because while you might be comfy in your own little world, you only get
> to play in that world because there's enough people doing other things
> that makes it profitable enough for VSI to continue making software for
> you to play with.

Just as Richard has done, you're making assumptions Simon. Now, if you had any
facts, numbers, and such to support your statement ...

>> Yeah, one can go on and on about some nice product/feature, but that does not
>> mean that everyone uses it.
>>
>
> Losing enough major third-party applications can be the difference
> between a port to x86-64 being viable and not being viable.
>
> Simon.
>

--
David Froble Tel: 724-529-0450
Dave Froble Enterprises, Inc. E-Mail: davef@tsoft-inc.com
DFE Ultralights, Inc.
170 Grimplin Road
Vanderbilt, PA 15486

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor