RE: Weird ODBC results

From what I can find, EBCDIC x'41' does not have an equivalent ASCII

character. I see ASCII x'41' is an A. Where did you find EBCDIC x'41' =
'A'?

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Nathan
Andelin
Sent: Monday, February 8, 2021 1:50 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Weird ODBC results

Assuming that the ODBC interface is extracting data to a PC, the x'41'
EBCDIC would be converted to "A" ASCII. Is that what they're seeing?

On Mon, Feb 8, 2021 at 11:12 AM <smith5646midrange@xxxxxxxxx> wrote:

We have a vendor file on three different machines and all three
machines have a record with a x'41' character in the vendor name. The
problem is that on two of the three machines, the x'41' is converted
to x'40' when the data is retrieved via ODBC.



I don't have access to what they are doing but I have been told they
are using ODBC driver "IBM i Access ODBC Driver 13.00.21.00" to
connect to all three machines and that all three ODBC configurations
are identical. I have confirmed with our tech team that all three
machines are identical for OS and PTF levels.



They are trying to convince me that the DB2 is configured differently
on two of the machines so the x'41' character is not returned in the
ODBC request on them and I'm not buying it. They did say that they
are receiving the x'41' when they connect via DB2Connect v. 11.1.4.5.



Can anyone tell me where to have them look in their ODBC config to
figure out why they are receiving different results across the machines?

--
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@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com