All Forums

Topics related to the Teradata Database, excluding database connectivity (e.g. JDBC) and extensibility (e.g. UDFs) . Typical topics are about SQL syntax and usage (SELECT, GROUP BY etc), database performance, use of database functions, comparison with / migration from Oracle or DB2, and generally why the Teradata Database rocks. For articles, blogs and more, see the Database section of the site.

You must login to post to the forums.
How to verify Data Pattern in a Column Topic by rajanihara 9 hours ago

Hi,
In a Select / CASE statement I need to perform a verification on the column data as follows
 
1. Verify if column A have an 8 Numerics  e.g 99999999 then assign a value
2. Verify if column A have a pattern ZZ999999, first 2 are any alphabets, then assign a different value.
 

34 views
2 replies, 27 min ago
Grants needed for a trigger Topic by I_Luv_SQL 11 hours ago trigger, grant option, 3523

A Delete trigger on table T1 is intended to populate an audit table T1_Audit, but the insert fails with a 3523.  Here are the gory details;

 

CREATE MULTISET TABLE DEV_DB.T1 ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      TypeCode CHAR(1) NOT NULL,

8 views
1 reply, 28 min ago
Database backup failing due to untranslatable characters in a table Topic by EUsha 1 week ago

I have been trying to take a backup of a database and it failed with Internal failure ARC0001 :DBCHWAT and it said we had parcel but fetch code we got back on session -1 was 1 . On further investigation it was noted that it is due to untranslatable characters noted in the table.

130 views
5 replies, 2 hours ago
3. How to find Exisiting LAN ID in Teradata? Topic by yuvana 2 days ago

How to find Exisiting LAN ID in Teradata?

39 views
1 reply, 6 hours ago
all-AMPs MERGE into <table> from Spool N (Last Use) - Huge Estimation Difference Topic by nomadic_being 22 hours ago explain plan, different explain, teradata explain, INSERT INTO, join performance

Apologies if  might have already been answered in this forum, but my 5 minute search did not get me anywhere. Hence a new thread.
Running SQLA 14.01 on TD14
Issue:

45 views
1 reply, 18 hours ago
Character set Topic by spkother 1 day ago

Hi,
 
  What is the differnce between unicode and latin character set.How can we choose the character set while creating table.Is there any way to convert unicode characters into Latin.
Thank you

46 views
2 replies, 18 hours ago
On a Db object which all are the users having access? Topic by reddyrajendra2014 23 hours ago

hi , could you please tell me how to find
which all are the users having access On a Db object?.
 
ex : i have a table user_sales_table , i would like to know the users list who has access to this table.
 
Thanks in Adv....
-- Raj

30 views
1 reply, 20 hours ago
Identify the time zone from a timestamp column Topic by cheeli 1 day ago time zone, time stamp

Greetings All,
I have a requirement to identify the time zone of a record (from a time stamp or date column) from existing populated table.  Can you please help me on this.
 

106 views
3 replies, 23 hours ago
creating table with sum-function Topic by emilahlstrom 1 day ago create table errors, create table, Failed 3707

Hi everyone,
 
Im trying to create a table but when try to run it, it says:  
EXPLAIN Failed.  [3707] Syntax error, expected something like a 'CHECK' keyword between ',' and the 'SUM' keyword.
Is there someone out there who knows what this might mean?
CREATE SET TABLE QFU.QFU_Operation_material_cost ,NO FALLBACK ,NO BEFORE JOURNAL,NO AFTER JOURNAL,

151 views
10 replies, 1 day ago
No room available in Database testdb. Topic by parthmalhan 2 days ago

Hi,
i'm getting error of "no room available in Database testdb".
Even in dbc, there's no space left.
Now i want to add space in dbc. so that i can move that space to my testdb database.
 
I've 10GB of free space on HardDisk.
I tried to do same with TeraData Administrator.
But Got Error

89 views
5 replies, 1 day ago
RDBMS error 2635: Error tables are invalid when doing a fastload Topic by vniri.teradata 10 Mar 2009

Hi , I am getting the following error when doing a fast load.**** 15:21:00 RDBMS error 2635: Error tables are invalid OR TFL_SALE is in an invalid state for Loaddoes this mean the is a fastload lock on the table.Need help in solving this...Thanks Nick

12644 views
4 replies, 1 day ago
Overlap Function Purpose in Projects Topic by Jugalkishorebhatt1 1 day ago Overlap Function Purpose in Projects

Hello All,
How is the OVERLAP function used in the real time projects. I understand the functionality, not the purpose of its use.
Can anyone give a small example which explains the process?
 
Thanks in Advance
Jugal.

31 views
1 reply, 1 day ago
New Features in TD V15 Topic by maniamenon 2 days ago

Could you please let me know what are the new features in Teradata V15.  
Is there any comparision metrix available with Teradata 14 and 15?
Thanks,
Mani

87 views
3 replies, 1 day ago
Locking the table Topic by spkother 1 day ago

Hi,
 
  I have a requirement,i have to run multiple SQL statements but i need to make sure no one can access the table while running these sqls.How i can achieve this.
Ex:
BT
select * from tableA;
update tableA set col1='xyz' where col2=2;
ET

38 views
1 reply, 1 day ago
Export to excel Topic by john9 1 day ago

Hi -
Any body know how to export the result set from SQL assistant to excell....i know how to export to .txt file...but i want to export to excell.
Thanks
John

47 views
2 replies, 1 day ago
Dynamic partition elimination Topic by spkother 1 week ago

Hi,
 
  I am new to teradata.what is dynamic partitioning elimination when it is comes under picture.please clarify

83 views
2 replies, 1 day ago
Handling NULL values in the data Topic by john9 3 days ago

Hi -
Can you please help how to handle below situation in teradata...
There are some records from the source whoch has NULL in the data itself ....for example
 
John is from teraNULLdata corpNULLoration
when i am trying to load these through mload its failing.I am able to find these NULL when i open the file in notepad ++

87 views
4 replies, 1 day ago
Profiles and Account Strings Topic by Kishore_1 1 day ago profiles, Account Strings

A profile may be associated with multiple account strings.
What is the query to know the various account strings associated with a particular profile?
 
Thanks in Advance!!

32 views
1 reply, 1 day ago
A more efficient way to reload data Topic by emilahlstrom 1 day ago refresh, creating table, strategy

Hi everyone,
 
Im facing a small problem, having a procedure that drops the whole table and refreshes (i'm not totally sure that this is the correct way to describe it) will
cause some problems in my opionion if that table consists of possibly 10,000,000 rows and even more. 
 

27 views
0 replies
TPT10508: RDBMS error 2634: Existing ERROR table(s) or Incorrect use of TS_IDP_MM in Fast Load operation Topic by Aleja 13 Jun 2014 TPT10508:

Buenas tardes,
Estoy realizando un proceso de cargue por Fast Load pero la ejecucion del archivo .tpt me genera el siguiente error:
TPT10508: RDBMS error 2634: Existing ERROR table(s) or Incorrect use of TS_IDP_MES_AAAA_MM in  Fast Load operation
Si alguien sabe o me puede indicar porque razón ocurre, se lo agradeceria enormemente.
Muchas gracias,

162 views
2 replies, 1 day ago
Teradata migration to Sql Server Topic by eejimkos 2 days ago

Hello,
Has anyone done a migration from Teradata to Sql server?
My main concern is to match the datatypes . Primary key , partition and other constraints i will check them.
I am thinking to produce a mapping table with all the information needed and do the migration from there.
 
Thank you.

32 views
0 replies
Composite index Vs join index Topic by khatriprad 3 days ago

What is the difference between Composite index and join index
Is it this difference that composite index creates sub tables to store pointers to data but Join index re-distribute the entire data
Which is better to use between two

83 views
3 replies, 2 days ago
error handler for CAST FAILED BAD CHARACTER IN FORMAT OF DATA Topic by subbu.balu93 2 days ago error handling, Bad character in format or data

Hi all,
I have a scenario where i have to CAST most of the columns and create and create a view.
Now the issue i am having is some CASTS fail because of bad format in data. In this case i have to put all failed values as NULL.
becaus of this i am writing a custom code everywhere based on the context.

64 views
2 replies, 2 days ago
Procedure Issues Topic by mithunganguly 2 days ago

Hi All,
   I have created a Teradata Procedure using SYSDBA ID in Database A. I am trying to execute the procedure through a different User - USER B. The procedure creates some temporary tables in Database C. The procedure is failing saying The user does not have the CREATE TABLE access to database C.
 

52 views
1 reply, 2 days ago
Requirement for Grouping records Topic by abhilash.nair 4 days ago

I have a requirement where a single Database table with 1600 columns of which 2 are key columns and part of primary index , is to be split into 2 tables such that 
Each table will have the above 2 key columns in common and one table will have around 80 columns which have been identified as fast changing and the other will have remaining 1520 columns identified as slow changing. 

66 views
1 reply, 2 days ago

Pages