topic Re: SQLMX: In SQLMX how to write query SELECT 1 like as other RDBMS ? in HPE NonStop Compute

SQLMX: In SQLMX how to write query SELECT 1 like as other RDBMS ?

Rajakumarp — Thu, 02 Apr 2020 12:37:29 GMT

SQLMX: In SQLMX how to write query SELECT 1 like as other RDBMS

When i was trying in SQLMX throw below error. Could you please help me how to write a form SELECT 1.

Thanks!!

Re: SQLMX: In SQLMX how to write query SELECT 1 like as other RDBMS ?

Rajakumarp — Thu, 02 Apr 2020 15:27:37 GMT

Sorry i for got post the error details

here is error details when query SELECT 1;

>>SELECT 1;

*** ERROR[15001] A syntax error occurred at or be
SELECT 1;
^ (9 characters from start of SQL stateme

*** ERROR[8822] The statement was not prepared.