dbaccess - case ?
User unable to query remote Informix database with mixed-case server name (wmsDBTC58) via dbaccess; system converts it to lowercase (wmsdbtcp58) causing failures. Setting DELIMIDENT=1 environment variable did not resolve the issue. User decided to add lowercase aliases or convert names to lowercase.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I have a legacy server that we just got in a merger ...
Servername wmsDB%CP58
when trying to select from the table within a dbaccess session remotely
...
select * from ipod@wmsDBTC58:ipod;
It fails because dbaccess is looking for wmsdbtcp58 (no uppercase)...
Obviously I can add an additional alias to be lowercase ... but just
wondered if there was a way to get the upper and lower to work ... trying
not to touch anything on the legacy server ..
Aix 7.1
IDS 12.10 ... remote 9.40
Thanks ...
Peter Logan
Database Administrator
SpartanNash INC.
Office: 616/878-8309
Mobile: 616/304-9672
E-Mail: peter.logan@spartannash.com
Peter,
I don't have any ANSI databases defined but I seem to recall that ANSI
databases are case sensitive. Is your source database ANSI? Just a thought.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter.Logan@spartannash.com
Sent: Tuesday, February 09, 2016 7:40 AM
To: ids@iiug.org
Subject: dbaccess - case ? [36531]
I have a legacy server that we just got in a merger ...
Servername wmsDB%CP58
when trying to select from the table within a dbaccess session remotely ....
select * from ipod@wmsDBTC58:ipod;
It fails because dbaccess is looking for wmsdbtcp58 (no uppercase)...
Obviously I can add an additional alias to be lowercase ... but just wondered
if there was a way to get the upper and lower to work ... trying not to touch
anything on the legacy server ..
Aix 7.1
IDS 12.10 ... remote 9.40
Thanks ...
Peter Logan
Database Administrator
SpartanNash INC.
Office: 616/878-8309
Mobile: 616/304-9672
E-Mail: peter.logan@spartannash.com
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
No ...
I will just add aliases that are lowercase ....
Peter Logan
Database Administrator
SpartanNash INC.
Office: 616/878-8309
Mobile: 616/304-9672
E-Mail: peter.logan@spartannash.com
From: "Link, David A" <DALink@west.com>
To: ids@iiug.org
Date: 02/09/2016 09:47 AM
Subject: RE: dbaccess - case ? [36532]
Sent by: ids-bounces@iiug.org
Peter,
I don't have any ANSI databases defined but I seem to recall that ANSI
databases are case sensitive. Is your source database ANSI? Just a
thought.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Peter.Logan@spartannash.com
Sent: Tuesday, February 09, 2016 7:40 AM
To: ids@iiug.org
Subject: dbaccess - case ? [36531]
I have a legacy server that we just got in a merger ...
Servername wmsDB%CP58
when trying to select from the table within a dbaccess session remotely
....
select * from ipod@wmsDBTC58:ipod;
It fails because dbaccess is looking for wmsdbtcp58 (no uppercase)...
Obviously I can add an additional alias to be lowercase ... but just
wondered
if there was a way to get the upper and lower to work ... trying not to
touch
anything on the legacy server ..
Aix 7.1
IDS 12.10 ... remote 9.40
Thanks ...
Peter Logan
Database Administrator
SpartanNash INC.
Office: 616/878-8309
Mobile: 616/304-9672
E-Mail: peter.logan@spartannash.com
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Peter:
Set and export DELIMIDENT=1 in the environment. That might do it.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Tue, Feb 9, 2016 at 9:47 AM, Link, David A <DALink@west.com> wrote:
> Peter,
>
> I don't have any ANSI databases defined but I seem to recall that ANSI
> databases are case sensitive. Is your source database ANSI? Just a thought.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter.Logan@spartannash.com
> Sent: Tuesday, February 09, 2016 7:40 AM
> To: ids@iiug.org
> Subject: dbaccess - case ? [36531]
>
> I have a legacy server that we just got in a merger ...
>
> Servername wmsDB%CP58
>
> when trying to select from the table within a dbaccess session remotely
> ....
>
> select * from ipod@wmsDBTC58:ipod;>
> It fails because dbaccess is looking for wmsdbtcp58 (no uppercase)...
> Obviously I can add an additional alias to be lowercase ... but just
> wondered
> if there was a way to get the upper and lower to work ... trying not to
> touch
> anything on the legacy server ..
>
> Aix 7.1
> IDS 12.10 ... remote 9.40
>
> Thanks ...
>
> Peter Logan
> Database Administrator
> SpartanNash INC.
> Office: 616/878-8309
> Mobile: 616/304-9672
> E-Mail: peter.logan@spartannash.com
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1132f214748e50052b58ca81
Thanks .. but no dice ...
Will fix things to be all lower case ... or at least add another alias ...
thanks for the help anyways ...
Peter Logan
Database Administrator
SpartanNash INC.
Office: 616/878-8309
Mobile: 616/304-9672
E-Mail: peter.logan@spartannash.com
From: "Art Kagel" <art.kagel@gmail.com>
To: ids@iiug.org
Date: 02/09/2016 11:28 AM
Subject: Re: dbaccess - case ? [36534]
Sent by: ids-bounces@iiug.org
Peter:
Set and export DELIMIDENT=1 in the environment. That might do it.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Tue, Feb 9, 2016 at 9:47 AM, Link, David A <DALink@west.com> wrote:
> Peter,
>
> I don't have any ANSI databases defined but I seem to recall that ANSI
> databases are case sensitive. Is your source database ANSI? Just a
thought.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Peter.Logan@spartannash.com
> Sent: Tuesday, February 09, 2016 7:40 AM
> To: ids@iiug.org
> Subject: dbaccess - case ? [36531]
>
> I have a legacy server that we just got in a merger ...
>
> Servername wmsDB%CP58
>
> when trying to select from the table within a dbaccess session remotely
> ....
>
> select * from ipod@wmsDBTC58:ipod;>
> It fails because dbaccess is looking for wmsdbtcp58 (no uppercase)...
> Obviously I can add an additional alias to be lowercase ... but just
> wondered
> if there was a way to get the upper and lower to work ... trying not to
> touch
> anything on the legacy server ..
>
> Aix 7.1
> IDS 12.10 ... remote 9.40
>
> Thanks ...
>
> Peter Logan
> Database Administrator
> SpartanNash INC.
> Office: 616/878-8309
> Mobile: 616/304-9672
> E-Mail: peter.logan@spartannash.com
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1132f214748e50052b58ca81
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I just had a recent support case, we were having some problems with some informix utilities not running. Turns out it was because our informix instance was named in mixed case, which the installer allowed, but which turns out is against the rules. Support referenced me to http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/id s_adr_0045.htm?lang=en which includes "a database server name must begin with a letter and can include any printable character, execpt the following: *Uppercase characters ...". (never knew that, have had mixed case for about 20 years). The best fix for us was to just rename our informix instances to lowercase, and correct the sqlhosts, etc. Using an alias worked but was messy with two names around, especially as you can't name the alias to just the same but in lowercase as informix says the name already exists (in its mixed form)! So, the installer should enforce the rule, or everything informix should lowercase the name all the time to be consistent and keep working. At the moment with some informix things ok with mixed case and others not it can waste a lot of time. Regards, Bryce Stenberg. > -----Original Message----- >Will fix things to be all lower case ... or at least add another alias ... >thanks for the help anyways ... > >Peter Logan