× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 26 Feb 2013 09:26, James H. H. Lampert wrote:
We've had a request, in connection with BIRT reports on our
Wintouch product, to have lowercase field names in our SQL views
<<SNIP>>
while the SQL source members did indeed have all lowercase field
names, when I then looked at the file from Squirrel SQL, the field
names still came up all-uppercase.

Is that just the nature of DB2/400?

For DB2, the column names are automatically folded to upper case, except when they are enclosed with [delimited by] quotation marks [aka double-quotes]. Other databases operate differently.

Thus the SQL identifier specified as the mixed-case
column name of Field_Name, the identifier is folded to the upper-case
column name of FIELD_NAME but when specified instead as the delimited
column name of "Field_Name", the identifier remains the mixed-case
column name of Field_Name

From my recollection, depending on client [settings], the specification of columns in a statement requested from that client may be passed to the server without folding, because the client could automatically delimit the identifiers. For example the request to SELECT Library FROM QUSRSYS.QAUGDBLL could be sent to the server as the request SELECT "Library" FROM "QUSRSYS"."QAUGDBLL", whereby all of the identifiers had been delimited to prevent the identifiers from being folded to upper-case. If passed as the former SELECT with undelimited identifiers, the error would be -206 because there is no column named "LIBRARY" in the TABLE named QAUGDBLL in library QUSRSYS.

I expect the metadata method storesUpperCaseIdentifiers() of the class AS400JDBCDatabaseMetaData will return True for the DB2; i.e. "the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in uppercase."


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.