$(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: true, vro: true, 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
avatar image
Former Member

Is FOR JSON statement support cancelled in IQ?

Jan 06, 2017 at 08:36 AM | 217 Views

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    John Currie
    Feb 14, 2017 at 06:44 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded