Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
Posted: Thu Jan 27, 2005 12:12 pm Post subject: The NOT symbol
Hi,
One of our screens allows users to enter the NOT symbol. Now, I do not know, whether the user entered lazy-L (X'5F') or the caret (X'B0'). But, in the database, it appears as the Greek letter alpha.
I queried the table with HEX(COLUMN_NAME). The result has X'B0'. But, in a mainframe dataset, when I type in the same with HEX ON, I am shown the caret symbol.
What can be the reason for this difference? It is probably because of some keyboard mapping. But, I do not know for sure. _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
Posted: Thu Jan 27, 2005 12:45 pm Post subject:
Hi Kolusu,
Thank you for the response.
Actually, I had checked the catalog (from E.D; I do not know if this is available to you) and found the Encoding scheme to E (EBCIDIC). However, I would like to know about this part in the manual:
Quote:
In a local environment, character conversion can occur when:
An overriding CCSID is specified in the SQLDA (see "SQL descriptor area (SQLDA)" in topic C.2). For languages other than REXX, the CCSID is in the SQLNAME field. For REXX, the CCSID is in the SQLCCSID field.
A mixed character string is assigned to an SBCS column or host variable.
I am quite sure, it is not the first one. But, what does the second one actually mean? Especially, the "mixed character string..." part. _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
