#DateForumTypeThreadPost
1930 Jan 2007 @ 09:08 PSTDatabaseReplyTeradata and near-line storageAny rumors that such a solution might be available at some point in the future?Anybody here working with a solution they think comes close to this approach?We've got a budget crunch this year and o...
1830 Jan 2007 @ 09:01 PSTUDAReplyadvantages of teradata over other databasesDisadvantage: Teradata development and DBA resources are harder to come by and therefore more expensive.My opinion - people can learn something about Oracle by reading "Oracle for Dummies" for $20....
1702 Jan 2007 @ 05:26 PSTAnalyticsTopicmeaning of " ('0A'X) is not a valid Teradata SQL token. "In writing a stored procedure I received the above error message. I can't find a single reference to either "valid token" or "'OA'X" in any of the V2R6.1.x documentation on NCR.com.Does anyone hav...
1615 Dec 2006 @ 07:05 PSTAnalyticsReplyInsert into Teradata table via MS Access ODBC occasionally failsNo error message. The create new record button (>*) is greyed out. The table grid doesn't allow me to tab at the end of the table to create a new record.Re your other comment, how do you turn on ...
1506 Dec 2006 @ 07:18 PSTAnalyticsTopicInsert into Teradata table via MS Access ODBC occasionally failsI'm creating a front-end for some Teradata user maintenance tables in MS Access. I've started having problems in occasionally not being able to insert or update records in these tables. I've been...
1427 Nov 2006 @ 02:47 PSTAnalyticsReplyoutput parameter as input parameter?I'm still only getting only 1, null inserted into T_TEST.
1322 Nov 2006 @ 10:11 PSTAnalyticsTopicoutput parameter as input parameter?I have two stored procedures; sp_A calls sp_B. sp_B has an output parameter, varOutB. After I have called sp_B within sp_A, I'm trying to use varOutB in an INSERT statement in sp_A but I get a me...
1222 Nov 2006 @ 09:53 PSTAnalyticsReplyexamples on codeThe entire Teradata documentation is available at:http://www.info.ncr.com/eTeradata-BrowseBy-Results.cfm?pl=&PID=&title=%25&release=&kword=SQLREF&kword2=TNTSEQ&sbrn=7&nm=Teradata+Database+-+SQL+Ref...
1116 Nov 2006 @ 03:41 PSTAnalyticsTopicquerying across Teradata installations?Is it possible to query across two Teradata installations (instances?). I'd like to create a table in Teradata installation 01 from a view I've created in Teradata installation 02.TIA,Nolan
1007 Nov 2006 @ 08:24 PSTAnalyticsReplyvolatile table disappearsNevermind - a colleague suggested that my connection through MS Access might be considered a separate session and, so, the table would not be visible in a simultaneous connection through SQL Assist...
907 Nov 2006 @ 06:07 PSTAnalyticsTopicvolatile table disappearsI've created a SQL pass-through query in MS Access that creates a volatile table in my logon user database. After I create that table, I can query the table in Access and get the expected results....
831 Oct 2006 @ 01:53 PSTAnalyticsReplyCall a macro from a stored procedure?Can you point me to the page number in the Teradata documentation? I'm not seeing the text you referenced.Thx,N.
730 Oct 2006 @ 02:27 PSTAnalyticsReplyCall a macro from a stored procedure?Well, I see in Teradata magazine that EXECUTE doesn't work to call a macro from a stored procedure. However, the FAQ item doesn't give any further example of how to use this syntax."The EXECUTE ma...
627 Oct 2006 @ 07:11 PDTAnalyticsTopicCall a macro from a stored procedure?Can one call a macro from a stored procedure?In the Teradata documentation "SQL Reference: Stored Procedures and Embedded SQL" I see the following:Rules for Using DECLARE CURSOR (Macro Form)The fol...
517 Oct 2006 @ 04:06 PDTAnalyticsTopicmultiple results in CASE statementIs it possible to return more than one result from a CASE statement?E.g.,CASE WHEN (condition-test1) THEN (true-result1), (true-result2) WHEN (condition-test2) THEN (true-result3), (true-result...
402 Oct 2006 @ 10:23 PDTDatabaseReplyInstr equivalent in Teradata....> But there's a UDF available from teradata.com for > that function, that makes life easier...> DieterAny suggestions as to where on teradata.com to find that UDF? I looked under "Oracle functions...
318 Sep 2006 @ 09:25 PDTAnalyticsTopicDecile for two variablesI want to divide the sales for each store into deciles and then I want to get the sales amount for the bottom of each decile. However when I do:select store_nm, sales, QUANTILE(10, store_nm, sales...
214 Sep 2006 @ 09:55 PDTAnalyticsTopicsimple formatting questionHow do I force Teradata to give me decimal values? I've tried a number of other FORMAT variations beyond the example below and I can't get the mantissa to display other than my "123.45" calculatio...
107 Sep 2006 @ 04:33 PDTAnalyticsTopicINSERT SELECT and other valuesCan anyone tell me what the correct syntax would be when I'm attempting to insert one value using a SELECT statement and the other values as fixed? Using the syntax below, I get an error message, ...

Pages