If an alias, alternative name, is specified and it is mixed case then it
appears to be enclosed in double qoutes. See original e-mail.
This morning I duplicated the problem I am seeing with Java / JDBC on the
green screen using QM and interactive SQL.
When using QM to run a query the alias / alternative name must be enclosed
in double quotes. For example:
SELECT
-- Columns
A."xfrCtrlKey", A."xfrType", A."xfrSendRcv", A."xfrId", A."ifsPath",
A."fileRegex"
-- Tables
FROM "SYSMONDB"/"XFRCTL00" A
Removing the double quotes from the library and file doesn't seem to cause
a problem.
Removing the double quotes from the field/column names causes a problem.
SELECT
-- Columns
A.xfrCtrlKey, A.xfrType, A.xfrSendRcv, A.xfrId, A.ifsPath,
A.fileRegex
Gives this error:
Column FILEREGEX not in table XFRCTL00 in SYSMONDB.
See how the SQL engine upper cased the column name fileRegex?
I am trying to use Ibasis to map DS/400 SQL tables to Java objects. I ran
into this problem.
Circling back to my original questoin, is there a property or something in
the JDBC which would allow mixed case column names without enclosing them
in double qoutes?.
"Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>
10/23/2007 08:13 AM
Please respond to Java Programming on and around the iSeries / AS400
To: Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>
cc: (bcc: Bill Blalock/TUS/US/Certegy)
Subject: RE: SQL problem with Java -- JDBC driver seems to
be turningmixedcase names into UPPERCASE
[SQL0206] Column DUEDAY4WEEKENDACTION not in specified tables.
Because the column name is actually "dueDay4WeekendAction"
Are you saying column names on the 400 are case sensitive?
midrange.com
