iSeries Token Error

365 pts.
Tags:
iSeries
iSeries Navigator
Query
Token Error
Need help with this query - it will not run token error.  Here is the query:

SELECT   SUM  ("T16.CTDT".TD_DETAIL_AMT_01 * .10) AS TOTAL, "T16.CPRP".CP_DISTRICT_CODE

Software/Hardware used:
Iseries Navigator
ASKED: January 14, 2010  5:12 PM
UPDATED: January 15, 2010  4:22 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

As Tom noted, it appears that you are missing half of the command. The From ..join .. on .. and group by. Without the rest of the command you will get a token error.
Phil

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...And the rest of the query is... what? The query isn't complete. There is no FROM clause shown. Since there is a SUM() function and a second detail column, there should also be a GROUP BY clause. Tom
    125,585 pointsBadges:
    report
  • lorit
    Sorry - when I copied the Query - I did not copy the whole thing. From your response, I was just missing the "Group by" with one of the same fields in the select statement. Thanks for the quick response.
    365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following