All Forums General
vchadala 2 posts Joined 07/14
02 Jul 2014
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=%';

)

 

krishaneesh 140 posts Joined 04/13
02 Jul 2014

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

dnoeth 4628 posts Joined 11/04
02 Jul 2014

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

Dieter

You must sign in to leave a comment.