Skip to Content
0

Wich are the requeriments to use FOR JSON STATEMENT? Or Is it not working anymore?

Feb 13, 2017 at 02:10 PM

48

avatar image

SELECT * FROM TEMPLEADO WHERE iNumEmp =810335 FOR JSON RAW;

12:35:03.733DBMSPruebas -- Number (102) Severity (15) State (181) Server (DGPDESA) Incorrect syntax near 'JSON'.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mark A Parsons Feb 13, 2017 at 03:10 PM
0

Hmmmm, I've never seen a 'for json' statement in ASE (and can't find anything in the manuals).

What RDBMS, and version, are you using?

If 'for json' worked before ... in which RDBMS (and version) did it work?

---------------

UPDATE: I found 'for json' mentioned in the IQ (and of course SQL Anywhere) manuals. If you're using IQ (or SQL Anywhere) ... you've posted in the wrong community forum. If you need help finding a more appropriate forum/tag just let us know the RDBMS you're using.

Share
10 |10000 characters needed characters left characters exceeded