I am trying to execute the below query after I logged on to the liveCache with the SQL Studio/dbmcli as the liveCache user, and executed the following command.
I get the below error stating that the Table is invalid.
query : Sql_execute SELECT count(*) from "/SAPAPO/ORDKEY" where simid = '<noted VRSIOID>'
LCA>ERR= -24988
ERR_SQL: SQL error
-3009,Invalid table n
Name and Server : LCA - fmskb0lc.fm.intel.com
DBMRFC Function : DBM_EXECUTE
Command : sql_execute SELECT count(*) from SAPLCA./SAPAPO/ORDKEY
Error : DBM Error
Return Code : -24988
Error Message : ERR_SQL: SQL error
-3009,Invalid table n
-3009,Invalid table name
Actually I am trying to follow the note # 1383947 where it asks to run the above query. I understand I can get the result from SE16 but trying to find out why the above query doesn't work from both DBGUI & DBMCLI.
Thanks