#DateForumTypeThreadPost
230301 Oct 2013 @ 11:16 PDTDatabaseReplyGoing mad with the record going to UV tableWhen you check the data in the UV table you should find an empno 1002, which clearly fails the BETWEEN check :-) .field EmpNo 1 char(4);     Dieter
230201 Oct 2013 @ 11:57 PDTDatabaseReplyNO OF PE's in SYSTEM  Some of the ResUsage tables got that info, e.g. SELECT NodeId, VProc1 AS "AMPs", VProc2 AS "PEs" FROM dbc.ResUsageSpma WHERE TheDate = DATE QUALIFY RANK() OVER ...
230101 Oct 2013 @ 09:56 PDTDatabaseReplyDate Field(yyyy-mm-dd). Remove Day from Date FieldThere's no way to store only YYYY-MM in a DATE column, when you add FORMAT 'YYYY-MM' it's just for a typecast to a string, but the day is still included. When you only need it for ...
230030 Sep 2013 @ 06:58 PDTDatabaseReplyConvert date month from a number to Jan, Feb, Mar, etc.No nested SELECT needed :-) Posting text removed based on formal request from Owner of the associated Intelectual Property.
229930 Sep 2013 @ 05:50 PDTDatabaseReplyConvert date month from a number to Jan, Feb, Mar, etc.Simply use the CASE and GROUP BY it: SELECT CASE VintageMonth WHEN 1 THEN 'Jan' WHEN 2 THEN 'Feb' WHEN 3 THEN 'Mar' WHEN 4 THEN 'Apr&...
229830 Sep 2013 @ 05:48 PDTToolsReplySouring data from multiple sources and combinedly loading the final table in TD(TPT)In a TPT script there's only support for UNION ALL to combine multiple data streams. Of course you might load both sources independently in a staging table and then perform the outer join. &n...
229730 Sep 2013 @ 01:29 PDTCloud ComputingReplyTD 14.10 Express: What are the systemrequirements or where do I find them?Hi Martin, at least 2GB RAM assigned to the 40GB version and 4GB for 1TB + Viewpoint: http://developer.teradata.com/database/articles/teradata-express-14-10-for-vmware-player-user-guide   ...
229629 Sep 2013 @ 04:24 PDTUDAReplyto check is a string is numeric or notAre you actually joining the same table several times? What is this query trying to achieve? Could you share the actual query? Any join using LIKE (and any non equi-join) will result in a product...
229529 Sep 2013 @ 03:19 PDTDatabaseReplyTeradata installation on MacWhich installation, TD Express on VMWare? There's no free VMWare Player for Mac, but  there's VMWare Fusion ($), Parallels ($) or VirtualBox (free).  Both Parallels and VirtualB...
229428 Sep 2013 @ 05:52 PDTDatabaseReplyWhere can I access a public sample Teradata database (read only mode)?Hi Dave, this "public instance" was probably referring to the Express edition running on VMWare. Btw, did you try to convert it to run on your Hyper-V? Otherwise you should try to get s...
229328 Sep 2013 @ 05:47 PDTDatabaseReplySelect statements to get metadataI don't know who the "Teradata Senior Engineer" was and what he exactly said, but you probably got something wrong: A logical datamodel is database independent, what is stored within...
229228 Sep 2013 @ 05:17 PDTDatabaseReplyDynamically Determine Date Range Based on System DateAssuming "calendar" is a table in Teradata: calendar.first_day_of_month BETWEEN ADD_MONTHS(CURRENT_DATE - (EXTRACT(DAY FROM CURRENT_DATE)-1),-12) AND ...
229128 Sep 2013 @ 04:46 PDTDatabaseReplyConvert date month from a number to Jan, Feb, Mar, etc.You do it exactly the way you would do in any other DBMS :-) CASE VintageMonth WHEN 1 THEN 'Jan' WHEN 2 THEN 'Feb' WHEN 3 THEN 'Mar' WHEN 4 THEN 'Apr...
229028 Sep 2013 @ 04:28 PDTDatabaseReplybackups and timestamps in table namesDynamically creating a tablename is not possible without some kind of Dynamic SQL, you need a Stored Procedure for this and your DBA probably didn't grant you this right. A BTEQ script will ne...
228927 Sep 2013 @ 06:25 PDTDatabaseReplysnap to scd using sqlCan you alaborate on the rules for combining rows? Why are there 2 rows for JILL and how are CURR_IN and RCV_IN calculated?   Dieter
228826 Sep 2013 @ 02:19 PDTDatabaseReply3707 Syntax error,expected something like a '"||"'or a 'FROM' keyword between a string or a Unicode character literalAre you an Oracle user? :-) You need to add an alias name before the final ";".   Dieter
228726 Sep 2013 @ 02:16 PDTDatabaseReplyUpdate frequency of CurrentSpool in dbc.DiskSpaceCould you please post unrelated questions as a new post?   2646 indicates running out of spool. If this load was running previously without problems there might have been multiple parallel ...
228626 Sep 2013 @ 01:38 PDTDatabaseReplyObtain a result from the diference between 2 timestampsWhen you substract 2 timestamps the result is an INTERVAL: select (timestamp2 - timestamp1) day(4) to second Caution: this will fail if the difference is >= 10000 days (27 years)   Di...
228526 Sep 2013 @ 11:10 PDTDatabaseReplyDifference between the partition by syntax There should be no performance difference when partition stats are current. But #1 is recommended because it's defining only the actual possible year/month values while #2 also defines partiti...
228426 Sep 2013 @ 10:50 PDTGeneralReplyCan the Teradata database memory footprint be adjusted on the Express Images?The available RAM can be modified using the "ctl" command line tool to modify the "FSG Cache Percent", e.g. a value of 30 means after starting the Teradata software 30 perceont ...
228325 Sep 2013 @ 12:26 PDTDatabaseReplysubstring or trim a text string up to a specific character SUBSTRING(col FROM 1 FOR POSITION('_' IN col) - 1) Dieter
228225 Sep 2013 @ 11:22 PDTDatabaseReplyGet Most Current DateHi Charles, simply add a PARTITION BY: qualify rank() over (PARTITION BY ACCT order by ORD_DUE_DT desc) = 1 Dieter
228125 Sep 2013 @ 09:37 PDTDatabaseReplySQL Error in FROM clause: SQL Editor: Encountered B. Was expecting: "of"......Well, there's no alias after the Derived Table, no ON and no JOIN to B: Posting text removed based on formal request from Owner of the associated Intelectual Property. Dieter  
228025 Sep 2013 @ 09:32 PDTTeradata StudioReplyConnect to the VM Teradata sample. TDExpress14.0.3_Sles10: ?Hi Boris, there is a link on the TD Express download site: http://developer.teradata.com/database/articles/teradata-express-14-0-for-vmware-user-guide   Dieter
227925 Sep 2013 @ 09:00 PDTData ModelingReplyHistory maintenanceHi Raja, you can use PPI to put all currently active rows in a single partition to avoid splitting it into two tables. If you don't want to call it "Slowly Changing Dimension" in a ...

Pages