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


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

"Working list requires SERVICE_LIST keyword"



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.