Failure 3707 Syntax Error
Contents |
All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for
3707 Syntax Error Expected Something Like A Name Or A Unicode Delimited Identifier
Search instead for Did you mean: Teradata : Product Forums : Database select failed 3707 teradata : 3707 Syntax error,expected something like a '"||"'... Options Subscribe to RSS Feed Mark Topic as New Mark Topic as select failed. 3707 syntax error Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page anvaysule N/A Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a
Teradata Error 3707 Create Table
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 a 'FROM' keyword between a string or a Unicode character literal and the integer '20132014'.I
3706: Syntax Error: Expected Something Between A String Or A Unicode Character Literal And ','
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-26-2013 12:11 AM Re: 3707 Syntax error,expected something like a '"||"'or a 'FROM' keyword between a string or a Unicode character literal The following query is thorwing an error3707 Syntax error,expec
All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead expected something like an 'except' keyword for Did you mean: Teradata : Product Forums : Database : New to
3706 Error In Teradata
teradata RDBMS error 3707: Syntax error, ex... Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read udfcallname teradata Float this Topic to the Top Bookmark Subscribe Printer Friendly Page elbebo Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate http://community.teradata.com/t5/Database/3707-Syntax-error-expected-something-like-a-quot-quot-or-a-FROM/td-p/31697 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 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 http://community.teradata.com/t5/Database/New-to-teradata-RDBMS-error-3707-Syntax-error-expected-something/td-p/29652 * 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_Transfer TYPE ODBC SCHEMA W_0_s_Queue_Transfer ATTRIBUTES ( VARCHAR UserName, VARCHAR UserPassword, VARCHAR SelectStmt, VARCHAR PrivateLogName, VARCHAR DSNName, VARCHAR ConnectString, VARCHAR TruncateData ); APPLY ( 'INSERT I
here for a quick overview of the site Help Center Detailed answers to any questions you might have http://stackoverflow.com/questions/36321808/create-table-failed-3707-syntax-error Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, syntax error just like you, helping each other. Join them; it only takes a minute: Sign up CREATE TABLE Failed. [3707] Syntax error, up vote 0 down vote favorite when i am trying to create a table like below CREATE SET TABLE pp_scratch.HADOOP_FPTI_DASHBOARD ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( 3707 syntax error id decimal(10,0) NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, MAXVALUE 999999999999, NO CYCLE) job_status VARCHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, current_processing_hr VARCHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL, no_of_files_moved VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL) PRIMARY INDEX id; CREATE TABLE Failed. [3707] Syntax error, expected something like a name or a Unicode delimited identifier or a 'CYCLE' keyword between an integer and ','. could you please help what went wrong. Thanks in advance sql teradata share|improve this question edited Mar 31 at 0:03 Gordon Linoff 467k20138212 asked Mar 30 at 23:51 GopiGowtham 94 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote There are no commas between the Identity options: CREATE SET TABLE pp_scratch.HADOOP_FPTI_DASHBOARD ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( id decimal(10,0) NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 MAXVALUE 999999999999 NO CYCLE), job_status VARCHAR(32)