#DateForumTypeThreadPost
4613 Oct 2011 @ 01:38 PDTDatabaseReplyteradata procedure   Hi Amit, Teradata SP can be written in the same way in which you will write an Oracle procedure. Syntax is pretty much the same. For more details, please read the following post. ...
4505 May 2011 @ 01:38 PDTDatabaseTopicTeradata Datatype for large numbersHi, I want to store large numbers (like 2**99) in a Teradata table. I cannot use decimal since it's out of limits and gets truncated. If I use float, the value is getting rounded off and not acc...
4425 Nov 2009 @ 06:31 PSTUDAReplyNebulous MLOAD error message...fix?Are you using the same file for loading in both the environments? If the files are different, then you might have the failure due to bad data in the file.
4330 Jul 2009 @ 10:51 PDTUDAReplyto get datatypes of all column from tableWhy don't you try SHOW TABLE table_name; It will give the entire table definition.
4207 Jul 2009 @ 09:08 PDTDatabaseReplyHintsThe only way you can 'hint' Teradata optimizer is to collect stats and keep the statistics updated. Stale stats will lead to issues.This thread might help - http://www.teradata.com/teradataforum/sh...
4107 Jul 2009 @ 08:38 PDTDatabaseReplysql assistantTeradata SQL Assistant can be used to connect to any ODBC. You can connect to Oracle, MySQL, SQL Server, DB2 etc. You need to set up the DSN.Check the User Guide for SQL Assistant (Windows based).h...
4007 Jul 2009 @ 08:28 PDTDatabaseReplyVolatile Tables And StatisticsStatistics cannot be collected on a Volatile table.From Teradata Documentation:5341 Volatile table "%VSTR" not allowed in statement. Explanation: The user submits a statement that is not allo...
3917 Jun 2009 @ 01:43 PDTUDATopicTeradata LocksIs there a way to view locks on tables using Teradata Administrator?
3827 May 2009 @ 08:48 PDTDatabaseReplyHow to find disk space used by a table.This should give the space in MB.SELECT SUM(CURRENTPERM)/(1024*1024) ACTUALSPACE, (MAX(CURRENTPERM)*(HASHAMP()+1))/(1024*1024) EFFECTIVESPACEFROM DBC.TABLESIZEWHERE DATABASENAME = 'DB_NAME' AND TAB...
3719 May 2009 @ 08:06 PDTUDAReplyPerformance issue with the queryDo you mean to say that the insert is taking too much time or are you saying that you are running out of spool space? Can you try the select statement alone? Also, can you post the Explain plan?
3612 May 2009 @ 03:35 PDTUDAReplyTeradata SQL Assistant / Database Explorer TreeAre you able to view everything using Teradata Administrator?
3511 May 2009 @ 09:13 PDTUDAReplyQUERY HELPCan you post the Explain plan of your query?
3419 Feb 2009 @ 06:59 PSTDatabaseReplyimport dataDieter, you are being too ironic!! ;)Neeraj,Please don't post/share any information like the one you have uploaded. It may cost you your job!!
3319 Feb 2009 @ 06:27 PSTDatabaseReplyCost Comparison between teradata and oraclefor making such a decision, you have to consider lots of factors like1. the kind of data you are going to store2. the type of data3. the approx size of data and the expected growth of data4. usage ...
3219 Feb 2009 @ 06:15 PSTDatabaseReplyteradata jobsJob related news, please post it here....http://www.teradata.com/teradataforum/Forum14-1.aspx
3124 Dec 2008 @ 06:02 PSTUDAReplyWhat is the best way to copy data to the mainframe?use Fastexport to export the data to a mainframe dataset...
3013 Nov 2008 @ 04:42 PSTUDAReplyData ConversionIt should be a problem with your source data..the select statement you have given is correct..can you provide some sample data?
2931 Oct 2008 @ 04:41 PDTDatabaseReplyHow to avoid line feed?Hi Peirre..what i did was just a crude method..something similar to what we call brute-force..my prob was that i was having a column which was having LF in between..the column is a char(60)...so wh...
2829 Oct 2008 @ 05:38 PDTDatabaseReplySQL Error on 'Create Table'Checksum was included from V2R5.1 onwards. Your create looks perfectly fine and is working on Teradata 12.
2714 Oct 2008 @ 04:29 PDTUDAReplyVolatile table in MainframeThanks a lot Rob and Dnoeth...I just wanted to confirm the issue. I have got around the problem by not specifying the Database name.
2610 Oct 2008 @ 02:22 PDTUDATopicVolatile table in MainframeHi..I was writing a Mainframe job to create a volatile table and insert data into it. It is throwing an error when I am directly giving the database name. Error is:CREATE VOLATILE TABLE DATABASENAM...
2520 Aug 2008 @ 05:45 PDTUDAReplyMload Login ErrorHiI am trying to MLOAD into a table using Mainframe. I am getting the same error. (UTY3403)I tried adding quotes for the password field. But still I have the same problem. The query is fine and I a...
2431 Jul 2008 @ 09:23 PDTUDAReplyNeed SQL help to remove repeated records...Thanks SNI got over it by creating a multiset table and then using row_number function....
2330 Jul 2008 @ 10:46 PDTUDATopicNeed SQL help to remove repeated records...I have a case like below:Table_1 Table_2 A -> X B -> X C -> X D -> Y E -> YThe table_1 columns are merged to the table_2 columns...
2209 Jun 2008 @ 09:28 PDTDatabaseReplySelecting three words from a stringthis query worked...let me know if there is a better wayselect na_name,trim(substr(na_name,1,index(na_name,' '))) first_name,trim(substr(trim(substr(na_name,index(na_name,' '))),1,index(trim(substr...

Pages