?
Solved

wepshere studio 5 + db2 problem

Posted on 2003-02-22
3
Medium Priority
?
356 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
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.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

770 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