Does LANSA Integrator support COUNT, AVG, MAX and etc on SELECT statement?

Date:06 October 2006
Product/Release:LANSA Integrator
Abstract:Unable to use the COUNT keyword with SELECT
Submitted By:LANSA Technical Support

Description:

Using the following KEYWORDS in a select statement gives the error:

"Working list requires SERVICE_LIST keyword"

COUNT
AVG
MAX

Solution:

Using quotes (") around the Select command before the SERVICE_LIST parameter resolves the issue.

Change contents of field/list (CHANGE)

Type choices, press Enter.

Field / list name(s) : . . . . . > #JSMCMD #-#Z99999999, *ALL...
+ for more values
To value : . . . . . . . . . . . > 'EXECUTE QUERY("SELECT COUNT(*) from DEPTAB") SERVICE_LIST(W01)'

So ensure it has double quotes "" for the SELECT command to process the SELECT COUNT statement and this should resolve the issue.