Skip to Content
avatar image
Former Member

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

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'.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 13, 2017 at 03:10 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded