SQLQuery: Cannot use JSON_OBJECT with literals

Question

Question

Rubens Silva · Sep 4, 2017

Hello, I just noticed that the following query is not allowing when using cached queries.

The compiler will accuse the code about missing a closing quote.
Just so you know, if I use this query dynamically it works, so I guess it's related to the code linting.

Query T() As %SQLQuery [ SqlProc ]
{
SELECT TOP 3 JSON_OBJECT('lit':'Employee from','t':%TABLENAME,'name':Name,'num':SSN) FROM Sample.Employee
}

The bold part is what is causing the error.

Version 2017.

Discussion (4)0

Log in or sign up to continue

Dmitry Maslennikov · Sep 4, 2017

I got the same error, with %SQLQuery and embedded SQL (&sql), and in 2017.2 too.

Looks like some error, and you should say about it to the WRC.

  SQLCODE=-3 : Closing quote (') missing
 SELECT TOP 3 JSON_OBJECT('lit':'Employee from','t':%TABLENAME,'name':Name,'num':SSN) FROM Sample.Employee

While it works perfectly with %SQL.Statement, and through Management Portal

Or just from the documentation page, here.

1 0

score 1 · Answer 1 · 2017-09-04T15:47:00-04:00

The bold part is what is causing the error.

And where error?

And version just 2017, is not enough. Is it 2017.1 or 2017.2?

score 2 · Answer 2 · 2017-09-05T03:57:45-04:00

Notice that if you put space after ':' then it compiles OK:

Query T() As %SQLQuery [ SqlProc ]
{
SELECT TOP 3 JSON_OBJECT('lit': 'Employee from','t':%TABLENAME,'name':Name,'num':SSN) FROM Sample.Employee
}

score 0 · Answer 3 · 2017-09-04T15:55:38-04:00

Rubens Silva · Sep 4, 2017

Cache for Windows (x86-64) 2017.1 (Build 792U) Mon Mar 20 2017 19:13:14 EDT

0 0