Error Teradata Execute Syntax Error Expected Global Temporary
Contents |
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 failure 3706 syntax error in teradata for Search instead for Did you mean: Teradata : Product
Teradata 3706 Syntax Error Data Type
Forums : General : Stored procedure - Facing error while executing Ca... Options Subscribe to RSS Feed teradata global temporary table syntax Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page Madhum Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 07-08-2015 12:31 PM 07-08-2015 12:31 PM Stored procedure - Facing error while executing Call statement Hi,I have createda procedure and it was success but while execuing the call procedure statement by passing the parameter values I am facing an error stating Failure 3706:syntax error expected GLOBAL TEMPORARY.I have not defined any temporary tables insie the PRO.Please helpThanksMadhu 0 Kudos Reply All forum topics Previous Topic Next Topic 6 REPLIES mohammad_gouse Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 07-09-2015 03:33 AM 07-09-2015 03:33 AM Re: Stored procedure - Facing error while executing Call statement Hi,I have created a belo procedure for table baackup, But I am getting the error'3706 syntax error expected global temporary'call SAI_OPERATIONS.CHC_PRD_TABLE_BACKUP_1('CHC','CHC_TB','BKP');Please help on me on this....Thanks in advance.. CREATE PROCEDURE SAI_OPERATIONS.CHC_PRD_TABLE_BACKUP_1( IN DATABASENAME VARCHAR(20), IN TABLENAME1 VARCHAR(20), in TABLENAME1_bkp VARCHAR(20) ) BEGIN DECLARE P_DB_COUNT INTEGER; DECLARE P_TABLE_COUNT INTEGER; Declare MESSAGE Varchar(100); DECLARE SqlTxt VARCHAR(500); SELECT COUNT(*) INTO :P_DB_COUNT FROM DBC.DATABASES WHERE UPPER(DatabaseName) = UPPER(:DatabaseName); If P_DB_COUNT = 0 THEN SET MESSAGE = 'Database ' || DATABASENAME|| 'does not exists
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 for Did you mean: Teradata : Product Forums : Analytics : SELECT Failed. 3706: Syntax error: expected somet... Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page bdwebman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to http://community.teradata.com/t5/General/Stored-procedure-Facing-error-while-executing-Call-statement/td-p/19096 a Friend Report Inappropriate Content 03-31-2011 12:25 PM 03-31-2011 12:25 PM SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. I am troubling over this error as I am not sure what the cause might be. Any help would be greatly appreciated.select Id, (select case when Fall_score = b.MaxScore then 'Fall' when Spring_score = b.MaxScore then http://community.teradata.com/t5/Analytics/SELECT-Failed-3706-Syntax-error-expected-something-between-and/td-p/62131 'Spring' from sandbox.testtable t where t.Id = b.Id ) as MaxScoreCategory,MaxScorefrom (select Id, max(Score) as MaxScore from (select Id, 'Fall', Fall_score from sandbox.testtable union all select Id, 'Spring', Spring_score from sandbox.testtable) a (Id, Category, Score) group by Id) bResult:SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. Everyone's tags (2): 3706 errorsyntax 0 Kudos Reply All forum topics Previous Topic Next Topic 20 REPLIES Jim_Chapman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-31-2011 02:35 PM 03-31-2011 02:35 PM Re: SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. Which Teradata version are you using? Scalar subqueries in the select list were not supported until 13.0. 0 Kudos Reply bdwebman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-31-2011 02:45 PM 03-31-2011 02:45 PM Re: SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. The DB version is 12 (
here for a quick overview of the site Help Center Detailed answers to any questions you might http://stackoverflow.com/questions/31478994/error-while-creating-date-column-in-tables-teradata have 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 syntax error programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error while creating date column in tables- teradata up vote 0 down vote favorite proc sql; connect to teradata as tera(mode=teradata server=oneview user="&teraid." password="&terapwd."); execute(CREATE MULTISET TABLE UD497.PAN_AM_EMAIL ( ATHNUM DECIMAL(10,0), BLK_1_CDE CHAR(1), BLK_2_CDE CHAR(1), OPEN_DT DATE, LANGUAGE CHAR(7), 3706 syntax error MKTCELL CHAR(2), PROJECT_ID CHAR(15), CAMPAIGN CHAR(35); ) PRIMARY INDEX(ATHNUM); ) by tera; Error Message : ERROR: Teradata execute: Syntax error, expected something like a 'CHECK' keyword between ',' and the 'LANGUAGE' keyword. sql teradata share|improve this question edited Jul 17 '15 at 16:10 Andrew 4,5411726 asked Jul 17 '15 at 15:09 Bharat Guda 84 Teradata <> MySQL, I removed the tag. –Andrew Jul 17 '15 at 16:10 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted The error message suggests that LANGUAGE is a keyword in Teradata, simply double quote it: "LANGUAGE" CHAR(7), But now, whenever you use it in SQL, you must double quote it, e.g. select "LANGUAGE"... Maybe simply change the name. share|improve this answer answered Jul 17 '15 at 15:19 dnoeth 29.8k2926 1 Please please please, don't use reserved words as object names... –Andrew Jul 17 '15 at 16:03 Got it, Thanks so much –Bharat Guda Jul 17 '15 a