Is FOR JSON statement support cancelled in IQ?

[serkan_birkan]

Hi,

When I try to use a simple "FOR JSON" statement in IQ16 SP11, I get a syntax error message. I searched the documents and found that after IQ16 SP04 (see below) there is no IQ document mentioning "FOR JSON". However I couldn't find any note/document that says it is not supported anymore. How can I be sure about that?

The query I ran:

select * from test for json raw -- syntax error near "json"

IQ16 SP04 - Reference: Statements and Options:

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00801.1604/doc/html/rhi1354740631017...

Regards.

[john_currie · Accepted solution]

Hello Serkan: "FOR JSON" is supported in SAP SQL Anywhere, but not SAP IQ. There were some "FOR JSON" instances in the SAP IQ 16.0.x documentation in error that were removed back in 2014. (For reference, the tracking number for this documentation correction was CR 773889.)

Hope this helps,

John C.

[serkan_birkan · Accepted solution]

Hi John,

Thank you very much for this valuable information.

Kind regards,

Serkan Birkan