#DateForumTypeThreadPost
212802 Aug 2013 @ 10:23 PDTDatabaseReplyRemove of Period '.' from my concatnated string.CONCAT is not a built-in Teradata function. Instead of oREPLACE better use oTRANSLATE, both are built-in since TD14, before they have to be installed as C-UDFs by a DBA. Or concat the columns on ...
212702 Aug 2013 @ 10:10 PDTGeneralReplyReg: how to extract a week number from date columnWhat definition of week do you need? Does it start on sunday or monday? Do you need the actaul week number or just the date of the first day of a week? What rules do you have regarding the startin...
212602 Aug 2013 @ 09:44 PDTGeneralReplyHow would you access the table when simultanous loading is going on You should ask a new question in a new post. I don't completely understand what you want: sel min(column_name),max(column_name),count(*) from database.table; Btw, you don't need h...
212502 Aug 2013 @ 09:40 PDTDatabaseReplyUNION Vs MSRWhen you read the Explain you'll easily see that your assumption is not correct. LOCKING applies to all statements within a request. Dieter
212402 Aug 2013 @ 06:29 PDTGeneralReplyReg: how to extract a week number from date columnDefine "week_number", ISO or other? Depending on your TD release you might use an existing UDF or create a SQL-UDF. Or simply join to a calendar table.   Dieter
212302 Aug 2013 @ 12:55 PDTAsterReplyAster_function load_from_teradata  Don'T use your target table in load_from_teradata, use a dummy instead.   Teradata Aster Big Analytics Appliance Database User Guide Teradata-Aster Database Connector   C...
212201 Aug 2013 @ 10:29 PDTDatabaseReplyUNION Vs MSRWhen you read the Explain you'll easily see that your assumption is correct.   Dieter
212101 Aug 2013 @ 10:24 PDTDatabaseReplyDifferent text formating to decimalLeading/trailing blanks/zeroes and thousand separators are never a problem, but the wrong (i.e. european) separators. What's your TD release? When you have the oTRANSLATE function installed i...
212001 Aug 2013 @ 10:00 PDTDatabaseReplySearch for first substring in string with conditionHi Peter, in cases like this it's better to post the real life question instead of an overly simplified one :-)   Seems like you try to clean DBQL data from comments, this will be a tou...
211901 Aug 2013 @ 09:44 PDTTeradata ApplicationsReplynewbie question getting started  Hi Gerald, did you follow this link on the download page? http://developer.teradata.com/database/articles/introduction-to-teradata-express-for-vmware-player   In the "Getting ...
211801 Aug 2013 @ 01:52 PDTDatabaseReplyForming Groups which are circular in natureHi Sagar, how do you know that A is the starting point and not B or C? A ---> B ---> C ---> A B ---> C ---> A ---> B C ---> A ---> B ---> C Dieter
211731 Jul 2013 @ 11:29 PDTDatabaseReplySearch for first substring in string with conditionHi Peter, based on the data you provided this should work (i just use POSITION instead of INDEX): SELECT Seq, Str, CASE WHEN POSITION('a' IN Str) = 0 OR POSITION(...
211630 Jul 2013 @ 02:42 PDTDatabaseReplyOreplace function throws error select failed.9134Is this the old TDExpress version, 14.00.00.01? This might be an old bug, try the new 14.00.03.02 instead http://downloads.teradata.com/download/database/teradata-express/vmware Dieter
211527 Jul 2013 @ 05:35 PDTAsterReplyAster_function GraphGen with JDBCWhen you check the resulting SELECT string you will easily see why it fails. You concat all those parts of the SELECT statement without additional spaces. It's recommended not to execute a co...
211426 Jul 2013 @ 10:33 PDTAsterReplyAster_function GraphGen with JDBCSorry, but my crystal ball didn't show me any details, so it's your turn: What did you try and how did it fail?   Dieter
211326 Jul 2013 @ 03:13 PDTTeradata StudioReplyANSI vs TERA auto commit in Studio v14Hi Steve, in fact there's no BEGIN TRANSACTION in Standard SQL, a transaction is automatically opened by the first statement within a session until it's COMMITed (there's a SAVEPOINT s...
211226 Jul 2013 @ 02:53 PDTDatabaseReplyUpdating 2nd row values with 1st rowHi Subbu, you just have to add this condition to the query i posted in: developer.teradata.com/blog/dnoeth/2013/07/how-to-spell-a-numeric-value-in-english-words#comment-65238 update tab as t ...
211126 Jul 2013 @ 01:29 PDTConnectivityReply.NET Data provider - Canonical functions support Hi Sundar, sorry for the late answer. With "replace" i ment you could write it directly using Teradata SQL, afaik the .NET provider simply translates all those functions to valid Terada...
211025 Jul 2013 @ 05:25 PDTDatabaseReplyproblem extracting td-express-14.00.00.01-vm-40gb.zipHi Andre, assuming you downloaded correctly (check the MD5) some programs can't unzip files larger than 2GB, you should try 7-zip: www.7-zip.org/download.html   Dieter
210925 Jul 2013 @ 04:17 PDTDatabaseReplyCan I do select from fallback table?It's not your choice, it's already done by the system, that's why there's Fallback :-) When an AMP looses it's vDisk, the system restarts and all queries accessing Fallback-pro...
210825 Jul 2013 @ 04:04 PDTToolsReplywhen replacing view with comments from SQL assistant, comments get truncated on databaseIn some cases (in ODBC i think it's based on the "Disable Parsing" setting) all comments are removed by the client tool and/or ODBC, etc. before submitting a query. What usually work...
210725 Jul 2013 @ 01:54 PDTDatabaseReplyImmediately exit a query if a condition is verifiedThe numbering is based on whatever you want and 0001-01-01 was a monday. SELECT CURRENT_DATE, (CURRENT_DATE - DATE '0001-01-01') MOD 7; *** Query completed. One row found. 2 columns ...
210625 Jul 2013 @ 01:42 PDTDatabaseReplyImplicit and explicit castings results in a bad planHi Troels, i doubt that it performed better before the upgrade, all TD release ever (and probably all other DBMSes, too) show a similar behaviour. You simply can't get a good plan for queries ...
210525 Jul 2013 @ 01:18 PDTDatabaseReplyImmediately exit a query if a condition is verifiedOf course is TD12 ok, but you'll probably not migrate to TD12 as this is still a very old version, there's TD13, TD13.10, TD14 and TD14.10 already :-) You could tell the IT staff to add so...
210424 Jul 2013 @ 01:38 PDTDatabaseReplyIssues with MERGE QueryHi Saravanan, if this is "a most business critical process" you should open an incident with Teradata support.     Dieter  

Pages