Skip to Content
avatar image
Former Member

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

Feb 13, 2017 at 02:10 PM | 82 Views

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

Sybase Adaptive Server Enterprise
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Mark A Parsons
    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