Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
#Automation
Hi All,
I am using wM IS6.1 and SQL Server. Is it possible to apply group by clause to SelectSQL template?
Your response would be grealty appreciated.
-Pauly
Pauly,
Looks like for a GROUP BY clause, you’d have to use CustomSQL or DynamicSQL template. Doesn’t seem to be doable with the SelectSQL template.
Basically in that case you have to use customSQL template and specify your query with groupby clause.but standard selectSQL template doesnt have that option.
HTH, RMG