Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by roopsingh
-
Case statement in Group by clause in IBM DB2 LUW 10.1
Hi, Please find below the error I an getting : “DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0119N An expression starting with "DEALER_NAME_ENG" specified in a SELECT clause, HAVING... -
Case statement in Group by clause in IBM DB2 LUW 10.1
Hi Frederico, I tried your suggestion by putting hard coded value in local variables as well as parameter variables to local variable. It didn't work. thanks Roop -
Case statement in Group by clause in IBM DB2 LUW 10.1
Yes. you are right. but it's not accepting host variable in group by clause. It works fine in DB2 9.7 LUW free version. But it's not working in DB2 10.1 Enterprise version. -
Case statement in Group by clause in IBM DB2 LUW 10.1
Hi, I have below scenario. I am just trying to avoid multiple queries by using case statement in group by clause in a Stored Procedure. I am using host variables in the case statement to decide what field to group by on. This code works fine in DB2 9.7 LUW free version. As soon as I run it on...
