?
Solved

wepshere studio 5 + db2 problem

Posted on 2003-02-22
3
Medium Priority
?
386 Views
Last Modified: 2010-08-05
I"m going through a tutorial and encounter the same error "TRADE.QTYAVAILABLE" is an undefined name.  I"m sure taht I follow every step in the tutorial. Thank for reviewing
_________________________________
SELECT

   AVG((TRADE.QTYAVAILABLE.UNITPRICE * TRADE.QTYAVAILABLE.MINQUANTITY))

FROM

   TRADE.QTYAVAILABLE

WHERE

   TRADE.QTYAVAILABLE.MINQUANTITY >= 250

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0204N  "TRADE.QTYAVAILABLE" is an undefined name.  SQLSTATE=42704
_______________________________________-

SELECT *

FROM

   TRADE.QTYAVAILABLE

WHERE

   TRADE.QTYAVAILABLE.MINQUANTITY >= 250

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0204N  "TRADE.QTYAVAILABLE" is an undefined name.  SQLSTATE=42704
0
Comment
Question by:second_comet
1 Comment
 

Accepted Solution

by:
MisterBL earned 200 total points
ID: 8037038
Make sure that TRADE is the database owner ID.  If the ID you are using is the database owner, than you don't need it on there.  You can just put QTYAVAILABLE
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses
Course of the Month8 days, 15 hours left to enroll

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question