mtserver - explain plan fails with 'provided input stmt does not exist', works from sqlci

[Aruna Sadashiva]

Explain is not working with mtserver thru jdbc. It works ok from sqlci.

SQL>explain options 'f' select * from t4qa.taball;

LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------

1 . 2 root 1.00E+004
. . 1 trafodion_scan TABALL 1.00E+004

--- SQL operation complete.

SQL>prepare s02 from select * from t4qa.taball;

--- SQL command prepared.

SQL>explain s02;

*** ERROR[8804] The provided input statement does not exist in the current context.