DB2Explain the effects of using CURSOR WITH HOLD with GROUP BY and ORDER BY clauses in your queries.
I think we can not use GROUP BY and ORDER BY in the same cursor?
DB2Explain the effects of using CURSOR WITH HOLD with GROUP BY and ORDER BY clauses in your queries.
hmmm,,ok Thanks.Robert Sample wrote:It can make a big difference! If you want to know the return code of the program you ran in TSO, you CANNOT use IKJEFT01! And if you get an ABEND, you will see the difference between IKJEFT1A and IKJEFT1B in the ABEND code you get.