Hi
I am As400 Professional. Now I want to learn Java on i-series how to start , I am confused?
Can anyone help me out?
Prasanna
java400-l-request@xxxxxxxxxxxx wrote:
Send JAVA400-L mailing list submissions to
java400-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/java400-l
or, via email, send a message with subject or body 'help' to
java400-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
java400-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of JAVA400-L digest..."
Today's Topics:
1. SQL problem with Java -- JDBC driver seems to be turning
mixed case names into UPPERCASE (bill.blalock@xxxxxxxx)
2. Re: SQL problem with Java -- JDBC driver seems to be turning
mixed case names into UPPERCASE (Simon Coulter)
3. RE: SQL problem with Java -- JDBC driver seems to be turning
mixedcase names into UPPERCASE (Walden H. Leverich)
4. RE: SQL problem with Java -- JDBC driver seems to be
turningmixedcase names into UPPERCASE (bill.blalock@xxxxxxxx)
----------------------------------------------------------------------
message: 1
date: Mon, 22 Oct 2007 18:28:15 -0500
from: bill.blalock@xxxxxxxx
subject: SQL problem with Java -- JDBC driver seems to be turning
mixed case names into UPPERCASE
I was trying to use more descriptive names in a data base created with
SQL. I admit this is a little overboard, but here is an example:
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
DUEDAY4 BINARY 4 0 2 414 Both
"dueDayOfMonth4"
Alternative name . . . . . . . . . . . . :
"dueDayOfMonth4"
Default value . . . . . . . . . . . . . . : None
DUEDAY4A CHAR 1 1 416 Both
"dueDay4WeekendActio
n"
Alternative name . . . . . . . . . . . . :
"dueDay4WeekendAction"
Allows the null value
Default value . . . . . . . . . . . . . . :
'0'
Coded Character Set Identifier . . . . . : 37
When I execute a SELECT statement I get a -206 error, here is the message:
[SQL0206] Column DUEDAY4WEEKENDACTION not in specified tables.
Notice that the variable name has been upper cased.
I am guessing that the field - DUEDAY4 is being used, not the alternative
name dueDay4WeekendAction. Does it have to be enclosed in double quotes
in the SQL?
Does that make sense?
If so, how do you tell the SQL engine to use the alternative name when
creating the connection. I looked at the properties to include in the
JDBC URL and didn't see anything.
Thanks
Bill Blalock
------------------
The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.
------------------
------------------------------
message: 2
date: Tue, 23 Oct 2007 19:36:35 +1000
from: Simon Coulter
subject: Re: SQL problem with Java -- JDBC driver seems to be turning
mixed case names into UPPERCASE
On 23/10/2007, at 9:28 AM, bill.blalock@xxxxxxxx wrote:
When I execute a SELECT statement I get a -206 error, here is the
message:
[SQL0206] Column DUEDAY4WEEKENDACTION not in specified tables.
Because the column name is actually "dueDay4WeekendAction"
Notice that the variable name has been upper cased.
Because it wasn't enclosed in quotes when you specified it in the
SELECT statement.
I am guessing that the field - DUEDAY4 is being used, not the
alternative
name dueDay4WeekendAction.
Why do you think that? If you'd specified the short name it would
have been used.
Does it have to be enclosed in double quotes in the SQL?
Yes (if by "it" you mean the alternative name).
Does that make sense?
Yes.
If so, how do you tell the SQL engine to use the alternative name when
creating the connection. I looked at the properties to include in the
JDBC URL and didn't see anything.
I don't think you can set a property for this. If you want to use the
short names then just specify them on the SQL statement.
Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists
http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------
------------------------------
message: 3
date: Tue, 23 Oct 2007 09:13:49 -0400
from: "Walden H. Leverich"
subject: RE: SQL problem with Java -- JDBC driver seems to be turning
mixedcase 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
