× 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.



Ron,

You missed out what I guess is supposed to be another "AND" between the
check on CPROP1 and CSTRET, i.e. I think the line should read

CRECA <> 'D' AND CPROP1 <> '   ' AND CSTRET = " + rs.getInt("CSTRET") + "

Good to see someone else on here from "the rock"!

Hope this helps,

Nigel Gay,
Computer Patent Annuities.



|---------+------------------------------>
|         |           RPower@xxxxxxxxxx  |
|         |           Sent by:           |
|         |           java400-l-bounces@m|
|         |           idrange.com        |
|         |                              |
|         |                              |
|         |           29/03/2005 11:11 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:                                                                   
                                 |
  |       Subject:  SQL Error??                                                 
                                 |
  
>--------------------------------------------------------------------------------------------------------------|




I'm running this statement against a DB2 file:
getProps = conn.prepareStatement("SELECT CPROP1 FROM TAXES.CAPMSTR WHERE
CRECA <> 'D' AND CPROP1 <> '   ' CSTRET = " + rs.getInt("CSTRET") + "
ORDER BY CPROP1");
and I'm getting the following error when I run the java program:
[3/29/05 11:04:16:906 NST] 5c2ab602 SystemErr     R java.sql.SQLException:
[SQL0104] Token CSTRET was not valid. Valid tokens: FOR WITH FETCH ORDER
UNION OPTIMIZE.
What am I doing wrong?

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. -
Sir Winston Churchill
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.








********************************************************************************
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee; access to this
email by anyone else is unauthorised.

If you are not the intended recipient: (1) you are kindly requested
to return a copy of this message to the sender indicating that you
have received it in error, and to destroy the received copy; and (2)
any disclosure or distribution of this message, as well as any action
taken or omitted to be taken in reliance on its content, is prohibited
and may be unlawful.
********************************************************************************


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.