Error 3707 In Teradata
Contents |
All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as syntax error expected something like %vstr you type. Showing results for Search instead for Did you mean:
3707 Syntax Error Teradata
Teradata : Product Forums : Database : 3707 Syntax error,expected something like a '"||"'... Options Subscribe to RSS teradata error 3706 Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page anvaysule N/A Options Mark as New Bookmark Subscribe Subscribe
Teradata Error Code 3707
to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 07-18-2013 01:16 PM 07-18-2013 01:16 PM 3707 Syntax error,expected something like a '"||"'or a 'FROM' keyword between a string or a Unicode character literal Hi,I am getting the following syntax error when I am trying to run my Query:3707 Syntax error,expected something like a '"||"'or 3707 error message a 'FROM' keyword between a string or a Unicode character literal and the integer '20132014'.I have narrowed down the error to the following portion of the WHERE clause in the SQL:a11.BRDCAST_QTR_ID in (SELECT BRDCAST_QUARTER_ID FROM CALENDAR_BROADCAST_QUARTER WHERE BRDCAST_YEAR_ID = (substring('a11.DEAL_YEAR_CD in ('20132014')' from POSITION('(' IN 'a11.DEAL_YEAR_CD in ('20132014')') + 1 for 8) )) Please Help.. 0 Kudos Reply All Forum Topics Previous Topic Next Topic 3 REPLIES VBurmist Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 07-19-2013 06:01 AM 07-19-2013 06:01 AM Re: 3707 Syntax error,expected something like a '"||"'or a 'FROM' keyword between a string or a Unicode character literal Hi,you might want to put double '' around20132014, so that you include the wholea11.DEAL_YEAR_CD in ('20132014') string inside a character literal (if that is what you are trying to achieve).Regards,Vlad. 0 Kudos Reply Divine786 Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 09-26-2013 12:11 AM 09-2
All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches
Teradata Error 3504
as you type. Showing results for Search instead for Did you
3707 Syntax Error Expected Something Like A Name Or A Unicode Delimited Identifier
mean: Teradata : Product Forums : Database : New to teradata RDBMS error 3707: Syntax error, ex... Options select failed 3707 teradata Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page elbebo Fan Options Mark as New http://community.teradata.com/t5/Database/3707-Syntax-error-expected-something-like-a-quot-quot-or-a-FROM/td-p/31697 Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 12-22-2011 06:46 AM 12-22-2011 06:46 AM New to teradata RDBMS error 3707: Syntax error, expected something like a name or a Unicode delimited identifier I am trying to transport data from SQL server to teradata and I get a syntax http://community.teradata.com/t5/Database/New-to-teradata-RDBMS-error-3707-Syntax-error-expected-something/td-p/29652 error. This is the script, any help will be well appreciated. DEFINE JOB Queue_Transfer ( DEFINE OPERATOR W_1_o_Queue_Transfer TYPE LOAD SCHEMA * ATTRIBUTES ( VARCHAR UserName, VARCHAR UserPassword, VARCHAR LogTable, VARCHAR TargetTable, INTEGER BufferSize, INTEGER ErrorLimit, INTEGER MaxSessions, INTEGER MinSessions, INTEGER TenacityHours, INTEGER TenacitySleep, VARCHAR AccountID, VARCHAR DateForm, VARCHAR ErrorTable1, VARCHAR ErrorTable2, VARCHAR NotifyExit, VARCHAR NotifyExitIsDLL, VARCHAR NotifyLevel, VARCHAR NotifyMethod, VARCHAR NotifyString, VARCHAR PauseAcq, VARCHAR PrivateLogName, VARCHAR TdpId, VARCHAR TraceLevel, VARCHAR WorkingDatabase ); DEFINE SCHEMA W_0_s_Queue_Transfer ( objid INTEGER, dev INTEGER, Id_Number VARCHAR(40), Queue VARCHAR(100), Start_date INTDATE, End_Date INTDATE, Queue2Case INTEGER, Queue2Subcase INTEGER ); DEFINE OPERATOR W_0_o_Queue_
All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by http://community.teradata.com/t5/Database/Create-volatile-table-failed-3707-expected-Unicode-delimited/td-p/33517 suggesting possible matches as you type. Showing results for Search instead for Did you mean: Teradata : Product Forums : Database : Create volatile table failed 3707 expected Unicode... Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic syntax error to the Top Bookmark Subscribe Printer Friendly Page laurastreng Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 07-26-2013 08:22 AM 07-26-2013 08:22 AM Create volatile table failed 3707 expected Unicode delimited identifier... syntax error expected Hi-I'm trying to learn how to create a temporary table and am getting this error messageCREATE TABLE Failed 3707: Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between ')' and the 'WITH' keyword.Here is the code. What do I need to fix? Thank you-CREATE VOLATILE TABLE STRENLR.TriMedAdm AS(SelectClnSorCd,RefNbr,MembKey,SrcCaseTypeCd,PlaceSrvSumDesc,AdmDt,PrimDxCd,ActlLOSNbr From ( Select REQ.CLNCL_SOR_CD As ClnSorCd,REQ.RFRNC_NBR As RefNbr,REQ.MBR_KEY As MembKey,REQ.SRC_CASE_TYPE_CD As SrcCaseTypeCd,REQ.PLACE_OF_SRVC_SMRY_TXT As PlaceSrvSumDesc,REQ.ADMT_DT As AdmDt,REQ.PRMRY_DIAG_CD As PrimDxCd,REQ.ACTL_LOS_NBR As ActlLOSNbrFrom UM_RQST REQWhere (REQ.CLNCL_SOR_CD IN ('870') and REQ.MBRSHP_SOR_CD IN ('868','869', '886')) and REQ.ADMT_DT = '2013-07-24'and REQ.CASE_TYPE_CD In ('MED','SUR','MAT')and REQ.AUTHRZN_STTS_CD = 'A' and REQ.APRVD_INPAT_DAYS_NBR > 0))WITH DATAPRIMARY INDEX (MembKey)ON COMMIT PRESERVE ROWS;select *from STRENLR.TriMedAdm ; Everyone's Tags (1): volatile table 0 Kudos Reply All Forum Topics Previous Topic Next Topic 1 REPLY Fred Teradata Employee Options Mark as New Bookmark Subscribe Subscr