$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
0

Is FOR JSON statement support cancelled in IQ?

Jan 06, 2017 at 08:36 AM

182

avatar image
Former Member

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

Regards.

SAP IQ
json
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
Former Member Answered
Feb 14, 2017 at 06:44 PM
1

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Serkan Birkan
Mar 24, 2017 at 08:15 AM

Hi John,

Thank you very much for this valuable information.

Kind regards,

Serkan Birkan

0
Comment