Re: Renaming SQL Database?

[Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>]

Hello Patrik

If it is not the CHGNETA you are asking for - then maybe you need  WRKRDBDIRE
and/or ADDRDBDIRE add an entry for your local database (*LOCAL)



On Mon, Mar 9, 2020 at 1:56 PM Patrik Schindler <poc@xxxxxxxxxx> wrote:

> Hello,
>
> when I do a STRSQL, I get a greeting message that a connection is
> established to the relational database <local-name-here>.
>
> How can I change this name? I'm not talking about the default connection
> but about truly changing the name. On a LPAR (7.2) of mine, the database
> has not adopted the name change in CHGNETA at install time, so I'm getting
> the system/LPAR serial number as greeting each time.
>
> Second, does this rename have some side effects for just local processing
> of SQL (within RPG) or remote connections via ODBC? There's definitely no
> reference to the database name in these places.
>
> Thanks!
>
> :wq! PoC
>
> PGP-Key: DDD3 4ABF 6413 38DE - https://www.pocnet.net/poc-key.asc
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com