46 | 13 Oct 2011 @ 01:38 PDT | Database | Reply | teradata 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. ... |
45 | 05 May 2011 @ 01:38 PDT | Database | Topic | Teradata Datatype for large numbers | Hi,
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... |
44 | 25 Nov 2009 @ 06:31 PST | UDA | Reply | Nebulous 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. |
43 | 30 Jul 2009 @ 10:51 PDT | UDA | Reply | to get datatypes of all column from table | Why don't you try SHOW TABLE table_name; It will give the entire table definition. |
42 | 07 Jul 2009 @ 09:08 PDT | Database | Reply | Hints | The 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... |
41 | 07 Jul 2009 @ 08:38 PDT | Database | Reply | sql assistant | Teradata 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... |
40 | 07 Jul 2009 @ 08:28 PDT | Database | Reply | Volatile Tables And Statistics | Statistics 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... |
39 | 17 Jun 2009 @ 01:43 PDT | UDA | Topic | Teradata Locks | Is there a way to view locks on tables using Teradata Administrator? |
38 | 27 May 2009 @ 08:48 PDT | Database | Reply | How 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... |
37 | 19 May 2009 @ 08:06 PDT | UDA | Reply | Performance issue with the query | Do 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? |
36 | 12 May 2009 @ 03:35 PDT | UDA | Reply | Teradata SQL Assistant / Database Explorer Tree | Are you able to view everything using Teradata Administrator? |
35 | 11 May 2009 @ 09:13 PDT | UDA | Reply | QUERY HELP | Can you post the Explain plan of your query? |
34 | 19 Feb 2009 @ 06:59 PST | Database | Reply | import data | Dieter, 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!! |
33 | 19 Feb 2009 @ 06:27 PST | Database | Reply | Cost Comparison between teradata and oracle | for 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 ... |
32 | 19 Feb 2009 @ 06:15 PST | Database | Reply | teradata jobs | Job related news, please post it here....http://www.teradata.com/teradataforum/Forum14-1.aspx |
31 | 24 Dec 2008 @ 06:02 PST | UDA | Reply | What is the best way to copy data to the mainframe? | use Fastexport to export the data to a mainframe dataset... |
30 | 13 Nov 2008 @ 04:42 PST | UDA | Reply | Data Conversion | It should be a problem with your source data..the select statement you have given is correct..can you provide some sample data? |
29 | 31 Oct 2008 @ 04:41 PDT | Database | Reply | How 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... |
28 | 29 Oct 2008 @ 05:38 PDT | Database | Reply | SQL Error on 'Create Table' | Checksum was included from V2R5.1 onwards. Your create looks perfectly fine and is working on Teradata 12. |
27 | 14 Oct 2008 @ 04:29 PDT | UDA | Reply | Volatile table in Mainframe | Thanks a lot Rob and Dnoeth...I just wanted to confirm the issue. I have got around the problem by not specifying the Database name. |
26 | 10 Oct 2008 @ 02:22 PDT | UDA | Topic | Volatile table in Mainframe | Hi..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... |
25 | 20 Aug 2008 @ 05:45 PDT | UDA | Reply | Mload Login Error | HiI 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... |
24 | 31 Jul 2008 @ 09:23 PDT | UDA | Reply | Need SQL help to remove repeated records... | Thanks SNI got over it by creating a multiset table and then using row_number function.... |
23 | 30 Jul 2008 @ 10:46 PDT | UDA | Topic | Need 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... |
22 | 09 Jun 2008 @ 09:28 PDT | Database | Reply | Selecting three words from a string | this 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... |