All Forums

For topics that do not belong to another forum. This includes general development topics, such as Java, .NET, User Interface design, etc., as well as discussion of the Teradata Developer Exchange itself. For articles, blogs and more, see the General section of the site. Do not post SQL or database questions here; they belong in the Database forum. JDBC/ODBC questions belong in Connectivity.

You must login to post to the forums.
Export LOB objects with size greater than 64K Topic by indra91 08 Sep 2016 #FASTEXPORT #FEXP, #TPT, #BLOB, #CLOB

We want to offload LOB objects from Teradata tables where  size is greater than 64K.I am trying to evaluate all the options at disposal here.

23 views
0 replies
Working with XMLTABLE, problem extracting data where elements have no prefixes/namespaces Topic by mikemadrinan 07 Sep 2016 xml, xmltable, namespace

I am working on an XML parsing requirement using XML Table.  I am running into a problem with data from elements with no namespaces or prefixes.  Extraction using XMLTable doesn't seem to work.  Extraction from elements with prefixes seem to work normally.  Say I have an XML below (not actual as I am working with sensitive data):

45 views
1 reply, 1 year ago
Converting Unix/EPOCH time to PST Topic by manish237 06 Sep 2016

I have a column in my teradata table which stores timestamp in UNIX/EPOCH form. I want to run a query and get the corresponding Date in PST and number of records against that date. I got the following query to convert the EPOCH time to Date, but not able to figure out how to get the corresponding PST date.
 

53 views
1 reply, 1 year ago
Converting varchar into timestamp Topic by jabbarahmed 31 Aug 2016 #varchar to timestamp

Can someone please give me the exact code to convert the following varchar data into a teradata recognised timestamp format. I have searched through existing topics but have not found an exact match for the below formats.
2016-01-07T11:52:49.113Z
and
May 25 2004  5:02:19:906AM

Please help!

45 views
1 reply, 1 year ago
6034 views
59 replies, 1 year ago
Last 6 Month in Query - Failing on August 30 Topic by aaibinder 30 Aug 2016 teradata, date, interval, select statement

...WHERE DB.LOG_DATE > DATE - INTERVAL '6' MONTH;
 
This has been working for weeks, until today. I wasn't sure what broke my script until I tried dropping the date requirement and then it started working perfectly. 6 month ago is February 30, I am guessing, by TD logic, which doesn't exist.
Any general solutions?
 
 
 

53 views
2 replies, 1 year ago
Teradata Partition table used in Informatica - TPT (update) Topic by tnshankar 24 Aug 2016

Hi ,
 
I am getting the below error when i try to run the Teradata partition table (Case_N) in Informatica -TPT connectivity . 
 
Error : Target [TABLE_NAME] is an invalid database partition target type
 
Could anyone help me on this ?
 

21 views
0 replies
BTEQ .IF ERRORCODE <> 0 THEN <QUERY> Topic by AMIT_TERSE 14 Nov 2014 @dnoeth, dnoeth;Raja_KT;fred;feinholz

Hi,
 
I have a scenario where I need to writed a query if the ERRORCODE condition satisfies in BTEQ .the Query is quite large and have many Joins , so is there any way I can put it to next line, since when I put the next line it doesn't work.
Workaround for the same would be helpful but need to have it after then.
Thanks in advance.
 

2628 views
4 replies, 1 year ago
Concatenate Topic by Vidhya Praveen Prabhu 03 Aug 2016

  I am having 5 columns say Col1 to Col5. The data present in Col1 to Col 5 is either 0 or 1.
 My requirement is I need to populate the data in a FLG column as wherever the data as 1. 
If suppose my first row has values in Col1,Col3 and Col5. 
 
FLG column should populate as Col1,Col3,Col5.
 
Example
Col1 Col2 Col3 Col4 Col5 FLG

86 views
5 replies, 1 year ago
Disable Logging in TPT Topic by srivigneshkn 18 Aug 2016 logs, tpt, Disable Logs, disable logging.

Hi,
I am executing my TPT export and each time, it does a detailed logging in the following logs folder.
This detailed logging makes the tpt to fail with out of space error in the logs folder.
Log Folder : 
/opt/teradata/client/15.10/tbuild/logs

65 views
1 reply, 1 year ago
TPT Update operator Topic by Prashanta 20 May 2016

I do want to load different 5 tables using tpt update operator can anybody tell me. how it can be done in TPT update script.further help is appreciated.
 

165 views
1 reply, 1 year ago
Multi Column Primary Index and Secondary Index Topic by Smac 03 Aug 2016

Hi All,
My 1st post in this Forum. Could you please help me to define a table if table having index as mulit column.
acctid and bus date are going to be unique values in the table. i.e., Multi column Index. Creating table with unique index ( acctid, Bus_date) or  unique Primary index ( acctid, Bus_date) is good in terms of data retrieval?

144 views
7 replies, 1 year ago
Improve performance on an analytical query , mulitple columns using same set of partitions Topic by Soumyatg 08 Aug 2016 performance, ordered analytical functions
Hi,


I have a large query where there are two window sets, one over year and another over quarter. I think that since teh parttion by and order by clause is same for 1 set of column and another set of columns, this query can be re-written to avoid the partioning on rows being done again and again. Below is the query:

 
Sel yrmthId,
acctId,

116 views
6 replies, 1 year ago
Looking for help with regards to nested aggregates Topic by Seitarin 03 May 2016

Hi all,
I am new to Teradata and I am having trouble building a query, would appreciate all the help I can get thanks! I'm looking to identify the highest difference in value between people entering and exiting a rail station, Location A (over the course of a day) and finding out the average of this value (daily) over all weekdays in a certain month (e.g. October).

2039 views
11 replies, 1 year ago
First Teradata Aster Certification Exam Released Topic by TCPP-Admin 08 Aug 2016

The Teradata Certified Professional Program is excited to announce the release of  the first Teradata Aster Certification Exam – Teradata Aster Basics 6.10.  Passing this exam will earn you the Teradata Aster Certified Professional Credential.  Start preparing today and you’ll be one of the first to get Teradata Aster Cert

43 views
0 replies
error table's are invalid state or table is being loaded Topic by lokesh_meesala 31 Jul 2016

Hi,

 

we are getting the interminent issue for TPT both easy loader

and script as well while uploading file to teradata. the error getting as" error

table's are invalid state or table is being loaded".if this happens our upload

will not work until we drop and recreate target table and all error table's.but this is

153 views
7 replies, 1 year ago
Finding the Sub String Between < and > Topic by paranoid 01 Apr 2016

Hi All,
 
I am new to Teradata SQL and still in learning stage. I am sure that i will improve my skills in some time.
 
Could you please help me in finding out the substring between two characters < and >?
 
Thanks in avance,
 
Regards,
Sue

118 views
4 replies, 1 year ago
Invalid date supplied for a column - Error code 2666 Topic by arsagg 30 Jul 2016

Hi All,
 
  I have a union of two query, when I the SELECTs individually, I am able to execute it properly, however when I run them with UNION, I get the error message as "Failure 2666 Invalid date supplied for T89002_DATE_PROCESSED.JULIAN_YYYYDDD"
 
My Query is:

SELECT 'Table1' AS TblName,                                                    

70 views
0 replies
Selecting XML data (converting xml data to rows and columns) Topic by Sasi474 28 Jul 2016

Hi,
Trying to extract all the colums from below table 

CREATE SET TABLE A,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      RQST_NUM INTEGER,

      ACTVTY_LOG XML)

PRIMARY INDEX ( RQST_NUM );

 

Query:

37 views
0 replies
Similar Names SQL Topic by samirparmar79 27 Jul 2016

SQL to Extract Records Based on Approximate String Matching

29 views
0 replies
How to search multiple columns for specific text Topic by txrob74 25 Jul 2016

Hello,  I have a table with multiple columns that display similar information and am trying to query multiple columns for a specific value.  for example the columns ID1, ID2 ID3
id1            id2       id 3        cm#
dl123        dl321    null            1
dl321         dl456   dl345         2
dl567         dl123    dl987        3

84 views
4 replies, 1 year ago
50 views
0 replies
Use of TABLE Keyword select statement Topic by NewbieTD 18 Jul 2016
select subq.sub_col1,subq.sub_col2,c.c2,c.c3.c.c4
select a.col1 sub_col1,b.col2 sub_col2,b.col3 sub_col3
Schemaname.Tab1 a, (select col1,col2 col3 from Schemaname.Tab2) b
on a.col1=b.col1) as subq,
TABLE (Schemaname.Tab3 (subq.sub_col1,subq.sub_col3,null,null)) as c (c1,c2,c3,c4)
where subq.sub_col1=c.c1

Hi All,

46 views
1 reply, 1 year ago
Free text columns adding in the table Topic by Madhum 18 Jul 2016

 
Hi All,
 
We are getting requirements to add a list of free text (clob) columns from ODS to a table.
Potentially that will result in 5-6 columns of type varhcar(2000) or varchar(4000).
They may or may not be populated all the time.
This is a fact table.

45 views
0 replies
Converting Time stamp in UTC including Day light Saving Topic by Pinky_Jain 14 Jul 2016 @dnoeth@Raja_KT

Hi All,
 
Please can anybody help me out with below query.
We are receving timestamp values from our server which is located in UK right now.We need to convert all the timestamp values in UTC for our reports.
As per my understanding,UK will be in BST during Summers and will be in GMT, the rest of the year.

125 views
3 replies, 1 year ago

Pages