3707 error expecting something like')' between a string or a unicode charecter literal and ;

General

3707 error expecting something like')' between a string or a unicode charecter literal and ;

what is 3707 teratadata error?

In my query,

CREATE  table pkp_ojap_singader_venkat_t.hc_get_feedbck

 AS (

SELECT  wep.*,

td_sysfnlib.nvp(wep.payload ,'helpcenter_feedback','&','=',1) as hc_feedbk

FROM pp_eap_access_views.web_evnt_payload wep 

WHERE 

 wep.eap_stream_key = 2

AND wep.page_key = 56828

AND eap_evnt_key = 2

AND wep.sessn_start_dt between '2014-02-01' and  '2014-05-01'

AND payload like '%helpcenter_feedback=%';

)

2 REPLIES

Re: 3707 error expecting something like')' between a string or a unicode charecter literal and ;

Unless you are joining 2 tables * does not allow a comma to follow it. Hence TD is expecting a || . what is NVP??

N/A

Re: 3707 error expecting something like')' between a string or a unicode charecter literal and ;

There's a semicolon before the final ")", simply remove it