File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQL error message Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL error message" Watch "SQL error message" New topic

SQL error message

Jennifer Sohl
Ranch Hand

Joined: Feb 28, 2001
Posts: 455
I am using Visual Age for Java and am trying to connect with JDBC to DB2 AS/400. We have established a connection, but when we try to execute our query, we receive the following error message:
SQL Execution Failed:
[PWS0001]Function did not complete successfully
What the heck does that mean? It's not very explanatory. Could someone please help?
Here is my SQL query:
Just a note: this was done by using the SQL Smart Assist Guide. We did not manually wirte this code.
Thanks in advance.
Joel Cochran
Ranch Hand

Joined: Mar 23, 2001
Posts: 301
Hi Jennifer,
I just started using JDBC to DB2/400, so maybe I can help.
Here is my SQL code which works just fine. Notice that the SELECT lists the fields and the FROM specifies the LIBRARY.FILENAME, which is definitely different than your example.

Hope this helps!
I'm a soldier in the NetScape Wars...

Wait a minute, I'm trying to think of something clever to say...<p>Joel
I agree. Here's the link:
subject: SQL error message
It's not a secret anymore!