All forum activity

#DateUserForumTypeThreadPost
5771613 Jun 2016 @ 06:01 PDTyarekshy85DatabaseTopicConvert text to a timestampHi All, I am trying to replicate the below vertica conversion to timestamp to teradata, But I am getting error. Can someone please guide me? Vertica: to_timestamp('June 7, 2016, Hour 0',...
5771513 Jun 2016 @ 05:29 PDTVishnujpDatabaseReplyCurrent date as column name in select queryHi , I tried the same max((case order_dt when cast ((cast(current_date -9 as format 'ddmmmyyyy')) as char(9)) then "seq" else null end)) as "current_date", and this i...
5771413 Jun 2016 @ 03:44 PDTPinderpalsinghDatabaseReplyCopying trillions of data to new tableyea explain plan will help you to check if its going for whole partition(FastPath Delete) or not.  look for text something like   "We do an all-AMPs DELETE OF a single partition&quo...
5771313 Jun 2016 @ 02:24 PDTsmantryConnectivityReplyCommand line installation for ODBC Driver for Windows 15.00.00.00I am having the same problem deploying it in my organization. Did you get the answer you were looking for ?
5771213 Jun 2016 @ 12:46 PDTpkrishnamoorthi@shutterfly.comDatabaseTopicCREATE TABLE with INTERVAL option in DEFAULT clauseHi All, I am trying to create a table as shown below, but the statement fails with a 3706 error code due the usage of "INTERVAL" option in the DEFAULT TIMESTAMP clause.  Is there a...
5771113 Jun 2016 @ 12:35 PDTBRIANHDatabaseTopicCAN SOMEONE ADVISE ME AS TO THE LOCATION OF THE TERADATA STARTUP SCRIPT ON LINUX GUEST O/S RUNNING ON WIN 10 PROI recently had a severe perf. issue when running VNWare and during the time when I was trying to determine who/what/why I wanted to stop Teradata being started as part of the VMWare VM s...
5771013 Jun 2016 @ 12:11 PDTraghavan.tceToolsReplyTPT attributes SkipRows and SkipRowsEveryFileI think you need to split the TPT loader into 2 parts, 1 to load with SkipRows = 1 and another without.
5770913 Jun 2016 @ 12:04 PDTshavesDatabaseTopicFiltering records with SQLI have a parameter in a report (Report Builder 3.0) called REPORT_FILTER.  This parameter has 4 available values.  The labels are (1) Home Group, (2) Home Branch, (3) Other Group, an...
5770813 Jun 2016 @ 12:00 PDTraghavan.tceDatabaseTopicPerformance on having more than 30 Left outer joinHi Team, In one of my project, I have one stage table with 3500 columns and i need to do left outer join with a lookup table to find matching business description. This lookup is required atleast ...
5770713 Jun 2016 @ 11:47 PDTraghavan.tceToolsTopicCan TPT be used to load file with 10M records of 3500 attributes ???Hi, I have a pipe delimited file with 3500 attributes each of length varying between 2-5 and max length of the file records is 6500. No. of records is about 10Million and file will be landed to uni...
5770613 Jun 2016 @ 09:39 PDTtdreturnDatabaseReplySQL error using Teradata JDBCThe error is : SQL state [HY000]; error code [3536]; [Teradata Database] [TeraJDBC 15.00.00.20] [Error 3536] [SQLState HY000] UPPERCASE or CASESPECIFIC specified for non-CHAR data.; nested excepti...
5770513 Jun 2016 @ 09:38 PDTtdreturnDatabaseTopicSQL error using Teradata JDBCHas anybody run into this where the JDBC driver acts inconsistenly. We understand the inconsistency but there does not seem to be a pattern to the inconsistency. All we are trying to find out is th...
5770413 Jun 2016 @ 09:32 PDTsk8s3iDatabaseReplyTable data in Alphabetical Column Name order in SQLA Hi Nagendra, I don't think there is any straight forward query to achieve this. However, you can try this: CREATE MULTISET TABLE YourDBName.Tbl_ColOrderedQuery ( ColName VARCHAR(50), Co...
5770313 Jun 2016 @ 08:21 PDTJoxo72Teradata ApplicationsTopicError retrieving TWB root directory: Success (0)Hi,   When executing a script directly from the unix command line it works. When doing so via crontab i get this error;   Error retrieving TWB root directory: Success (0)   Ca...
5770213 Jun 2016 @ 07:53 PDTCarlosALDatabaseReplySubtracting Timestamps as decimals hoursHi. This is a 'signature error'. Try: SELECT Test_Sandbox.TimeStamp_Diff_Seconds(TIMESTAMP '2016-06-10 00:00:00', TIMESTAMP '2016-05-10 11:25:00'); Teradata changed this...
5770113 Jun 2016 @ 07:31 PDTPrivate Forum
5770013 Jun 2016 @ 06:59 PDTtomnolanToolsReplyTD utilities and JAVA.The Teradata JDBC Driver implements the wire protocol for FastLoad and FastExport. You do not need to understand the wire protocol.   The Teradata JDBC Driver's FastLoad and FastExport f...
5769913 Jun 2016 @ 05:01 PDTtosakoDatabaseReplyhandling of error “5878 – No error text is available”Thanks Dieter
5769813 Jun 2016 @ 04:31 PDTXKAMILOXIIDatabaseReplySubtracting Timestamps as decimals hours...jeje..sorry,  I change the name: This the script: REPLACE FUNCTION Test_Sandbox.TimeStamp_Diff_Seconds ( ts1 TIMESTAMP(6) ,ts2 TIMESTAMP(6) ) RETURNS DECIMAL(18,6) LANGUAGE SQ...
5769713 Jun 2016 @ 04:28 PDTsk8s3iDatabaseReplyCurrent date as column name in select queryYes, it works fine. You will just need to enclose the Alias in double quotes:   SELECT CASE WHEN ... THEN 1 ELSE 0 END AS "CURRENT_DATE" FROM DB_Na...
5769613 Jun 2016 @ 04:25 PDTM.Saeed KhurramDatabaseReplyCurrent date as column name in select queryHi, This is standard in teradata to eclose key words in double qoutes if you want to use them as Alias. I have tested and it works fine on SQLA. Which query tool are you using? Br, Khurram
5769513 Jun 2016 @ 03:55 PDTVishnujpDatabaseReplyCurrent date as column name in select querytried that... dint work
5769413 Jun 2016 @ 03:27 PDTrubenjdcGeneralReplyMerge with TIMESTAMP column PKSorry its OK, the problem was i was trying to merge the same data, i update the info to merge and there no problem
5769313 Jun 2016 @ 03:11 PDTnagendratrpthDatabaseTopicTable data in Alphabetical Column Name order in SQLA Hi, How can I get "Select * from tablename" result in alphabetical order of column names in SQLA window ? Ex. Table/view has columns defind in order A,C,D,B , then sel * from table shou...
5769213 Jun 2016 @ 02:48 PDTrubenjdcGeneralTopicMerge with TIMESTAMP column PKHi everyone. I need to merge some data what i  have a 3 column's UPI (col1,col2,col3), col 1 and col2 are a varchar but col3 it's a timestamp. Im trying to merge but teradata studio ...

Pages