#DateForumTypeThreadPost
41206 Nov 2015 @ 12:46 PSTCloud ComputingReplyTeradata Express+VMware with Windows10?Bill: I think the last version of VMWare Player is 12.1 (it is called Workstation 12 Player now though). Teradata Express 15 definitely does run on VMWare Player 7. There are documents in t...
41104 Nov 2015 @ 02:07 PSTDatabaseReplyParameterization of Layout fileHi. TDWallet could be one way to go... Cheers. Carlos.
41002 Nov 2015 @ 12:55 PSTDatabaseReplySumming a count (*) columHi. You could user aggregate clauses like GROUP BY ROLLUP, CUBE, etc... to get total results. HTH. Cheers. Carlos.
40902 Nov 2015 @ 12:44 PSTDatabaseReplySecondary Index and JoinsHi. The optimizer will use NUSIs in "covering query situations" when possible. Cheers. Carlos.
40828 Oct 2015 @ 09:47 PDTCloud ComputingReplyTeradata Express+VMware with Windows10?Hi. It will, as long as you install VMware Workstation / Player on Windows 10. HTH. Cheers. Carlos.
40728 Oct 2015 @ 09:31 PDTDatabaseReplyOREPLACE Hi. You can do it in one blow with:   SELECT oTRANSLATE('''a'',''b'',''c'',''d''', 'a,''', 'a/...
40628 Oct 2015 @ 02:25 PDTGeneralReplyStored proc in Teradata gives an error "Invalid State"Hi Marlon Brando. Get back to the Oracle forums where you belong ;-) Cheers. Carlos.
40522 Oct 2015 @ 07:04 PDTDatabaseReplySAS connect Teradata and executeHi. There is a comma missing after SELECT OID_RTDM_SOLICITACAO HTH. Cheers. Carlos.
40421 Oct 2015 @ 08:03 PDTDatabaseReplyHow to check an invalid date in TeradataHi. This is usually done with an OUTER JOIN to SYS_CALENDAR.CALENDAR. HTH. Cheers. Carlos.
40321 Oct 2015 @ 12:19 PDTDatabaseReplyhow to create output rows equal to comma saparated values in column fieldHi You may take a look at STRTOK_SPLIT_TO_TABLE(). HTH. Cheers. Carlos.
40215 Oct 2015 @ 07:52 PDTDatabaseReplyLeast/Greatest Function with DatesHi. CASTing is your friend. SELECT GREATEST(dt1 (INTEGER), dt2(INTEGER), dt3(INTEGER))(DATE); HTH. Cheers. Carlos.  
40129 Sep 2015 @ 12:15 PDTToolsReplyHigh ImpactcPUHi. Impact CPU = CPU time of the most used AMP * number of amps. So, roughly speaking, it usually means skew. Cheers. Carlos.  
40028 Sep 2015 @ 02:44 PDTDatabaseReplySyntax Not Working: "ALTER TABLE <TableName> DROP <ColumnName> CHECK;"Hi. For unnamed check constraints you can only drop them ALL with: ALTER TABLE... DROP CHECK; HTH. Cheers. Carlos.
39928 Sep 2015 @ 01:13 PDTDatabaseReplyTactical WorkloadHi. Parsing and/or dictionary blocks? (FirstStepTime-StartTime) Flow control? Cheers. Carlos.
39825 Sep 2015 @ 03:57 PDTGeneralReplyQUERY INVALID ERRORHi. When you say "run", what do you mean exactly? Can't you run the query in bteq, SQLAssistant, Studio, other? Cheers. Carlos.
39723 Sep 2015 @ 12:35 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi. Bloody drupal... I was pointing the same CASTing issue as Dieter did already. However, I think TIME - 3 will substract three seconds from TIME instead the three hours desired by the op. HTH...
39622 Sep 2015 @ 08:31 PDTDatabaseReplyIssue while converting float to time and inserting to tableHi. TheTime is FLOAT and you are comparing it with TIME in the BETWEEN clause. You must CAST it to TIME first. Also, you must CAST '03:00:00' to INTERVAL TYPE. HTH. Cheers. Carlo...
39511 Aug 2015 @ 12:14 PDTDatabaseReplyView creation.Hi. It is advisable to implement a layer of views upon the tables layer, tables shouldn't be accessed directly by users by no means (other than users for loading processes plus some 'super...
39411 Aug 2015 @ 12:08 PDTDatabaseReplyhow to get the current_timestamp value in micro format like 11/08/2015 12:22:09.754321Hi. CURRENT_TIMESTAMP precision is limited to hundreths (two digits after the point). If you need more precission you could go for an UDF. HTH. Cheers. Carlos.
39307 Aug 2015 @ 06:49 PDTConnectivityReplyscript for ODBC connectionPavel: Actually, in 64 bit Windows there are two different ODBC configurators(odbcconf.exe), one for 64 bit ODBC drivers (the 'default' one, which is, ironically, in Windows\SYST...
39207 Aug 2015 @ 05:48 PDTConnectivityReplyscript for ODBC connectionHi. Just a shoot in the dark but, could it be some 64bit - 32bit issue (driver & administrator)? Cheers. Carlos.
39107 Aug 2015 @ 01:02 PDTConnectivityReplyscript for ODBC connectionHi. The error message "Komponent ne nayden v reyestre" (Component not found in the registry) should give you an idea... Something wrong with the TD odbc install, as said before. Cheers....
39007 Aug 2015 @ 12:45 PDTToolsReplyjunk characters when trimming char in fast exportHi. TRIM() returns VARCHAR type, thus adding an integer value with the lenght of the string at the beginning of each line. These are your 'junk characters'. Cheers. Carlos.
38905 Aug 2015 @ 04:57 PDTDatabaseReplyImpact of unnecessary compress on all char and varchar columns.Dieter: I'm not sure what you meant with "always NOT CASESPECIFIC in a Teradata session". In Teradata session mode (which is the 'usual' mode, an the mode I was assuming for...
38805 Aug 2015 @ 03:43 PDTDatabaseReplyImpact of unnecessary compress on all char and varchar columns.Hi. #1: Yes, It will compless NULLs only. (BTW NULLs are NOT automagically compressed without the COMPRESS clause). #2: In general, shorter rows=>more rows per datablock=>less IO. I don'...

Pages