Re: Another SQL question: This time with VIEWs

As Chuck points out, lowercase a-z are variant in EBCDIC. Code page 290 (and
CCSID 5026 which is based on CP 290) do not have a-z where one would
traditionally expect (you will find Katakana at the traditional a-z code
points). And to also confirm his reference to the double quote, most EBCDIC
code pages have the double quote at x'7F'. Turkish CCSID 5026 however has
capital letter U with diaeresis ( Ü at this code point.
I am not aware of any problem (related to variance) with < though.

Bruce
On Thu, Apr 21, 2011 at 9:43 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

On Thu04-Apr-2011 16:27 , James Lampert wrote:

CRPence wrote:

Names delimited with quotation marks will maintain mixed-case. Of
course lower-case alphabetic characters are variant rather than
invariant . . .

Not in EBCDIC, they're not!

In EBCDIC, the entire upper and lower case alphabet, all 10 digits,
space, &, -, /, :, period, comma, (, ), _, single and double
typewriter quotes, +, ?, =, ;, and > are invariant, and < is
quasi-invariant.

One could wish that lowercase characters were invariant, but
unfortunately to suggest they are, is not entirely accurate.
Globalization documentation for thy IBM i OS specifically warns, among
other things, that "Lowercase alphabets should not be assumed to be
invariant." Consider that the EBCDIC code page 290 either has no
lowercase a-z or those characters are variant. Perform the following
scripted requests on a IBM i command line, honoring the specified case,
to infer there is an issue:

CHGJOB CCSID(290)
ChgJob CCSID(37) /* Fails: "Command ChgJob ... not found" */
CHGJOB CCSID(37)

If no CCSID based on code page 290 is going to be supported, then I
suppose lower case characters from the character set 00640 used in SQL
identifiers should be fine.

I believe both the "required space" and "quotation mark" characters
are quasi-invariant [he-heh; OK, rarely variant] for being invariant
across all but one or two EBCDIC CCSIDs, however I am unsure of the
accuracy of that claim about the less-than character. I do not recall
ever testing SQL for the variant delimiter, the [double] quote being a
possible problem. Perhaps the '<' character might be missing from one
or more default keyboard layouts, but I do not recall that character is
variant in any EBCDIC CCSID; though perhaps the Euro character changed
something I do not recall.?

Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.