NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
U-15
Considerations—UPSHIFT
Considerations—UPSHIFT
•
Effect of collations
If the character expression you specify as an argument to UPSHIFT is associated
with a collation, SQL upshifts the string based on the rules specified in that
collation.
If the argument is not associated with a collation, SQL converts lowercase
characters to uppercase characters according to the usual rules of English.
•
Version management considerations
In version 2, the argument to UPSHIFT could be a column name, a string literal
(without an associated character set), a parameter name, or a host variable name, but
could not be any other form of character expression.
If you use the UPSHIFT function according to version 2 rules, the program will be at
least version 2. If you use the UPSHIFT function according to version 3 rules, the
program will be at least version 3.
Examples—UPSHIFT
•
The following statement selects all values from the column CUSTNAME and
returns them in uppercase:
>> SELECT UPSHIFT(CUSTNAME) FROM =CUSTOMER;
•
The following statement performs a case-insensitive search for the customer name
HOTSYS. (In the table, the name can be in lowercase, uppercase, or mixed case.)
>> SELECT * FROM =CUSTOMER
+> WHERE UPSHIFT(CUSTNAME) = "HOTSYS";
•
The following statement returns all rows from two tables in which department
names have the same value, regardless of case:
>> SELECT * FROM =DEPT1, =DEPT2
+> WHERE UPSHIFT(DEPT1.DEPTNAME) = UPSHIFT(DEPT2.DEPTNAME);
USAGES Table
The USAGES table is a catalog table that keeps records of dependencies between
objects and between programs and objects. The following table describes the contents of
the USAGES table. In the column descriptions, the terms initial object and used object