#DateForumTypeThreadPost
2208 Apr 2014 @ 03:52 PDTTeradata StudioReplyjre 1.6 is required for TS application warning, failed TS installTo get around the install failure referring to JRE 1.6 install the following http://support.apple.com/kb/DL1572?viewlocale=en_US   davidpracy
2109 Jun 2009 @ 07:15 PDTToolsReplyFASTLOAD cannot find script fileHiThe following are example syntax to initiate a fastload job either interactivly or included in a .BAT file fastload C:\load\example.logfastload ..\log\example.log(remember the limitations of ...
2009 Jun 2009 @ 07:02 PDTToolsReplyextract ddlSELECT 'show table '|| trim(DATABASENAME) ||'.' || TRIM(TABLENAME) ||' ;' FROM DBC.TABLES WHERE DATABASENAMElike 'example_%' and tablekind = 'T' --AND TABLENAME LIKE '%example%' ORDER BY DATA...
1909 Jun 2009 @ 06:55 PDTToolsReplyReading uesr id and password from a file -- MLOADHi (Make changes to the following that are specific to your environment)Create a file called example.logon which contains the following line..LOGON TD_DEV/username,password;In your mload, tpump etc...
1817 Sep 2007 @ 06:51 PDTConnectivityReplyODBC driver removal - need help pleaseHave you restarted the PC after doing the uninstall?Why are you installing an older version of the driver?You should contact you sales rep / TD customer service to ensure that you are installing th...
1704 Sep 2007 @ 07:41 PDTToolsReplySQL Syntax CheckerAs Jim suggests use EXPLAIN.EXPLAIN actually p****s the sql so you get both syntax validataion and and understanding of how the opimisiser will interpret / execute the SQL. The F6 key will EXPLAIN ...
1627 Aug 2007 @ 11:01 PDTToolsReplyImport in TD SQL AssistantInsert into tablename values (?,?, etc) where each ? correlates with a field in you target table. Run the query and you will be prompted for the file that you wish to load.Hope this helpsDavidPracy
1521 Aug 2007 @ 07:16 PDTDatabaseReplyTeradata demo CDsYou should be able to register and get the CD sent to your home - I did.
1420 Aug 2007 @ 07:52 PDTDatabaseReplyShow Table and Data definitionLeoMy understanding is that a show object is a reconstruction of the objectdefinition from TVM not the request text which is the users definiton used to create the objectHope this helpsdavidpracy
1320 Aug 2007 @ 07:44 PDTUDAReplytrying generate a unique idUsing Generated Always will guarentee 'unique' rows but does not prevent 'duplicate' rows - i.e. rows that are duplicate from the source but are loaded with a unique ID. You will need to factor thi...
1214 Aug 2007 @ 08:19 PDTToolsReplyTeradata Utilities V2R6The Release Summary in the documentation for the release would be a good place to start.
1114 Aug 2007 @ 08:16 PDTTrainingReplyTeradata Demo CDKumarIt shouldn't take long at all - the last one I order arrived in a few days.davidpracy
1008 Aug 2007 @ 10:23 PDTAnalyticsReplySQL and spool spaceWhat can't you added the extra fields to the group by?Have you checked that the query isn't skewed - this could cause you to run out of spool.
905 Aug 2007 @ 10:56 PDTToolsReplyCan TPUMP load to one db and put error/log tables in another?Yes TPUMP can load to one database and create the error and log tables in a different databases. This would be the preferred way to do it.It would be easier to help if you included excerpts from yo...
812 Jul 2007 @ 01:24 PDTAnalyticsReplyConcatenate Number, How to remove dot (.) in the result?The examples that I provided were just examplesspecify the size of the Char field so as to meet you requirement/field sizeIt is easier to help questions when they have DDL,queries etc supplied.
711 Jul 2007 @ 06:46 PDTAnalyticsReplyConcatenate Number, How to remove dot (.) in the result?Try casting the fields as Chars then concatenate them.Essentially this is what you are doing (if the field is defined as numeric)select cast (123 as numeric) || cast(345 as numeric); 123. 345.E...
611 Jul 2007 @ 06:30 PDTDatabaseReplywhat does this error mean?it means that even though the rows in the derived table are unique, the fields used in the where clause are not enough to uniquely identify the row in the target table. Try adding additional fields...
511 Jul 2007 @ 05:54 PDTDatabaseReplyTable definitionsIts assigning 'As strSQL' as the result set / column name - it can then be referenced in other processes if required
409 Jul 2007 @ 07:57 PDTAnalyticsReplyRound Up and Round to Nearest?From what I can tell your example shouldn't round up to 15.47.Try playing around with the following examples.SELECT CAST((15.4632) AS DECIMAL (6,1));SELECT CAST((15.4632) AS DECIMAL (6,2));SELECT C...
304 Jul 2007 @ 11:38 PDTTrainingReplyWhere to download the Teradata database server and Utility packsThe Teradata demo CD that you ordered will have everything that you need.
204 Jul 2007 @ 09:38 PDTToolsReplyBTEQ logoncreate a 'logon' file called Example.logon that contains.logon system_DSN/user_name,password;call it in your bteq as follows:/* Example BTEQ */.Run file 'C:\script\logon\Example.logon';Exec Macro_N...
104 Jul 2007 @ 09:28 PDTToolsReplyFind SP Debugging toolsI normally use a debug table that has a 3 fields - Step_Num, Step_MSG, Step_TS that I write to at the beginning and end of each step of the sproc that I am writting. The content of the Step_MSG fie...