Does LANSA Integrator support COUNT, AVG, MAX and etc on SELECT statement?
|Date:||06 October 2006|
|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.