Error while executing sql commands thru dbmcli interface

[former_member330338]

Hi Folks,

While continuing with the post activities for homogenous livecache copy,w.r.t note 877203. I am encountering problem executing the 1st step of adapting livecache table /sapapo/ordmap. This is what the note says;

To adapt liveCache table /sapapo/ordmap please do the following

steps.

-> To show all used LOGSYS including count please run the

SQL statement ( you could use SQLStudio):

( logon as 'sapr3' user - the Standard liveCache user of the source

liveCache. )

select LOGSYS, count(*) from "SAPR3"."/SAPAPO/ORDMAP" group

by logsys

our livecache user is "SAPLCA"

from dbmcli this is the error i am getting;

dbmcli on LCA>sql_execute select LOGSYS, count(*) from "SAPLCA"."/SAPAPO/ORDMAP" group

by logsysERR

-24988,ERR_SQL: sql error

-5015,Missing keyword:BY

Even thru sqlcli it is the same;

sqlcli LCA=> select LOGSYS, count(*) from "SAPLCA"."/SAPAPO/ORDMAP" group

by logsys* -5015: POS(61) Missing keyword:BY SQLSTATE: 42000

Kindly help.

Regards

Vid

[markus_doehr2]

Make sure the command is entered in ONE LINE.

Markus

[Former Member]

Hey Markus!

Yea..it worked.man...i will keep bugging you...sorry..

Thanks!

Vid

[markus_doehr2]

good to hear it finally did

Markus