MVSFORUMS.com

ramu_mohan21 · Posted: Tue Apr 17, 2007 8:57 am Post subject: SQL Query Help Needed?

HI Board,
I have the data in Table-A(Fields: F1, F2, F3) and Table-B(Fields:Q1,Q2) like below:

Table-A
---------

kolusu · Posted: Tue Apr 17, 2007 9:10 am Post subject:

ramu_mohan21,

Unless I am missing something , this is a simple query. Try this untested solution

ramu_mohan21 · Posted: Tue Apr 17, 2007 9:56 am Post subject:

HI Kolusu,

I have already tried as you mentioned above. At that time I have below error:

DSNT408I SQLCODE = -122, ERROR: A SELECT STATEMENT WITH NO GROUP BY CLAUSE CONTAINS A COLUMN NAME AND AN AGGREGATE FUNCTION IN THE SELECT CLAUSE OR A COLUMN NAME IS CONTAINED IN THE SELECT CLAUSE BUT NOT IN THE GROUP BY CLAUSE
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer

kolusu · Posted: Tue Apr 17, 2007 10:14 am Post subject:

ramu_mohan21,

If you run the query as is then you will NOT get the -122 error. I am selecting 2 columns and those 2 columns are present in my GROUP by clause. You must be running a different query. Run the query as is shown above in spufi/qmf and shows us the error messages if you get any

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

ramu_mohan21 · Posted: Wed Apr 18, 2007 1:02 am Post subject:

You are right. I wrote a wrong SQL Query. I didn't keep B.Q2 in GROUP BY Clause. Now it is working fine.

Thank you for your immediate answer.
_________________
Best Regards,
----------------
Rammohan Pabba
Software Engineer