#DateForumTypeThreadPost
1923 Aug 2011 @ 10:50 PDTDatabaseReplyMore elegant way of stripping spaces from a postcode?Since Teradata version 12 doesn't have regular expressions available and they won't let me use a UDF, I created a Talend ETL job that pulls the data out of Teradata cleans with a regular expression...
1823 Aug 2011 @ 10:38 PDTDatabaseReplyFinding next change in valueThis may not be the best way, but I think it does the job. --OUTER STATEMENT: SELECT pull_1.myTimeStamp , pull_1.STATUS FROM myDatabase.TEST_DEVICE pull_1 ,( --INNER STATEMENT:...
1722 Aug 2011 @ 05:29 PDTDatabaseTopicTable or view that contains the NumberOfRows & NumberOfColumns?Is there a table or view that contains the NumberOfRows, NumberOfColumns, DataBaseName, TableName? In Oracle its called all_tables and in Netezza its called _v_table_only_storage_stat. Her...
1619 Jul 2011 @ 11:40 PDTDatabaseReplyTeradata to teradata replication using Golden GateYou could use the ETL software Talend http://www.talend.com/demo/
1519 Jul 2011 @ 11:37 PDTDatabaseReplyRegular Expressions?Are there any plans for Regular Expressions to be available in the future without needing rights to create a UDF?
1411 Jul 2011 @ 05:09 PDTUDAReplyto check is a string is numeric or notThe link posted by rkeith01 doesn't work for me, anyone know how to get to the post?
1306 Jul 2011 @ 04:23 PDTDatabaseReplyVOLATILE TABLE - Where is it located?In SQL Data Definition Language – Syntax and Examples page 778 it shows: HELP VOLATILE TABLE sales_temp; The above didn’t work for me, but this SQL does: HELP TABLE myTableName; The res...
1206 Jul 2011 @ 03:47 PDTDatabaseTopicVOLATILE TABLE - Where is it located?When you create a VOLATILE TABLE what location is it created in? I know it is a temp table that is gone when the session ends. The following SQL will give me the SQL that was used to create the ...
1127 Apr 2011 @ 09:43 PDTDatabaseTopicRegular Expressions?Is there any way to use a Regular Expression with Teradata version 12?
1012 Apr 2011 @ 10:49 PDTDatabaseTopicTeradata JDBC Driver Error - Error 1338I have a Talend job that is using JDBC to connect to Teradata. I think the driver being used is 13.00.00.27 and I know the Teradata system I am connecting to is 12.00.1.29 I think only the top m...
908 Apr 2011 @ 07:25 PDTDatabaseTopicTIMESTAMP: FORMAT - TimeZoneIs it possible to get the timestamp to display the timezone like this using SQL? 2011-04-08 09:16:10 PM Central Standard Time What I have so far: SQL: SELECT current_timestamp as myDef...
806 Apr 2011 @ 06:05 PDTDatabaseReplyInteger (with Unix epoch time) convert to timestamp?Thanks! This what I ended up with: SELECT CAST(DATE '1970-01-01' + (my_time / 86400) AS TIMESTAMP(6)) + ((my_time MOD 86400) * INTERVAL '00:00:01.000000' HOUR TO SECOND) AS myTIMESTAMP FROM my...
706 Apr 2011 @ 05:53 PDTDatabaseReplyGMT to EDT conversion in TeradataOne small correction, it's "hour" no "s" at the end: - INTERVAL '4' HOUR
606 Apr 2011 @ 05:17 PDTDatabaseReplyReverse string search (right to left)?Are there plans for a right() function to be added in a future version of Teradata?
506 Apr 2011 @ 01:22 PDTDatabaseTopicInteger (with Unix epoch time) convert to timestamp?This gets the date, how can I get the full timestamp? SELECT (CAST('1970/01/01' AS DATE FORMAT 'yyyy/mm/dd')) + CAST(my_time/86400 AS INTEGER) AS CONVERTED_TIME FROM myDatabase.myTable I hav...
431 Mar 2011 @ 06:44 PDTDatabaseTopicLinux - Bteq - Export data to file - How can I remove the extra spaces?Using these settings the results of my SQL ran using Bteq is written to a file with no column headers, the only thing I can't figure out is how to get rid of the 10 spaces that are written to the e...
331 Mar 2011 @ 01:11 PDTDatabaseTopicLinux - Bteq - Logging On in Batch ModeChapter 2: Starting and Exiting BTEQ Logging on to the Teradata Database Page 37 Submit the LOGON command in an input file, including the password, as follows: .LOGON tdpid/userid, password ...
228 Mar 2011 @ 04:29 PDTDatabaseReplyTeradata Table Naming Is there an admin setting that can be changed to increase the size limit for a table name?
128 Mar 2011 @ 03:36 PDTDatabaseTopicTPT - TIMESTAMP FORMAT - century of '19' instead of '20'My data: 15-MAR-11 07.54.08.000000 AM 15-MAR-11 07.53.40.000000 AM 15-MAR-11 07.53.04.000000 AM 15-MAR-11 07.52.55.000000 AM 15-MAR-11 07.52.16.000000 AM My current DDL: CREATE multiset TA...

Pages