#DateForumTypeThreadPost
4425 Mar 2013 @ 06:28 PDTToolsReply.NET Data Provider 14.10.00.00 - 'Windows Help' file doesn't workIt worked for me now after I right click the .chm file -> Properties -> Uncheck attribute 'Read-only' -> click 'Unblock' Since I downloaded the file from internet it...
4313 Mar 2013 @ 08:22 PDTToolsTopic.NET Data Provider 14.10.00.00 - 'Windows Help' file doesn't workHi, I download the 'Windows Help' file for '.NET Data Provider 14.10.00.00' at http://downloads.teradata.com/download/connectivity/dot-net-data-provider The downloaded file ...
4213 Sep 2012 @ 04:23 PDTDatabaseReplyTeradata .Net Dataprovider connection error The following the article from Teradata support for KAP1B0756    Teradata Knowledge Base    Solution    ID: KAP1B0756 Special character...
4108 Aug 2012 @ 08:22 PDTDatabaseTopicRestricted Words and Reserved Vs Non-Reserved words Hi, we are upgraded our database from TD 12.0 to TD 13.10 and I am looking at the list of Restricted Words from the query: SELECT * FROM TABLE (SQLRestrictedWords_TBF()) as t1 WHER...
4010 Jul 2012 @ 09:11 PDTDatabaseTopicCOALESCE on timestamp(2) datatype column Hi, i have a column defined: END_TM TIMESTAMP(2) On select I want to use CURRENT_TIMESTAMP(2) when END_TM is null However, the following sql   select COALESCE(END_TM,cur...
3924 Jun 2012 @ 02:54 PDTConnectivityTopic.NET Data Provider, Provider Factory, cannot create DataSource Enumerator I have added reference to Teradata.Client.Provider (.NET Data Provider for Teradata 14.0.0.0, Runtime v2.0.50727) to my Visual Studio C# 2010 project Now, i want to get list of all ODBC names ...
3814 Jun 2012 @ 03:54 PDTDatabaseReplyUpdate Interval column on Interval substraction It worked after i added CAST to addition or substration of interval columns. Even if the columns are not nullable and i don't use COALESCE, the sum of two intervals fail to load into an ...
3713 Jun 2012 @ 12:09 PDTDatabaseTopicUpdate Interval column on Interval substraction Hi, i have these 2 columns defined: WAIT_INTVL INTERVAL HOUR(3) TO SECOND(2) HOLD_INTVL INTERVAL HOUR(3) TO SECOND(2) and both are null values a) select COALESCE(WAIT_INTVL, INT...
3612 Jun 2012 @ 05:52 PDTDatabaseReplyUpdate on partition by statement Thanks Venkat, it worked !!!
3506 Jun 2012 @ 11:45 PDTDatabaseTopicUpdate on partition by statement Hi, i have data: select JOB,NAME,CODE,START_TM from table TableT JOB,NAME,CODE,START_TM ------------------- JOBA,M,S,2010-06-04 JOBB,M,K,2010-06-05 JOBC,N,A,2010-06-0...
3401 Jun 2012 @ 06:00 PDTToolsTopicAutomatic logging ON/OFF for tpump Hi, we have TD12.0 and use a generic load id that does tpump, multi load, fast load, fast export, ..... We have logging OFF for this id by default because logging on tpump is a big overh...
3325 May 2012 @ 08:07 PDTDatabaseTopiccast interval Hi, i have two timestamp columns of 2 fractional seconds precision, i want to take the difference of these 2 timestamps and then have interval upto 0 fractional seconds only   For...
3229 Feb 2012 @ 01:07 PSTDatabaseTopicCompare strings in bteq statement, not in sql Hi, i have a bteq statement and depending on the unix environment variable ${JOB_ENV} i want to skip to a lable bteq < EOF ${LOGON}; .label A ---------- ... .if er...
3121 Feb 2012 @ 07:41 PSTDatabaseReplyWhy Timestamp(6) precision only upto 2 fractional seconds? Thanks Ulrich, that answers the mystery !!!
3021 Feb 2012 @ 05:57 PSTDatabaseTopicWhy Timestamp(6) precision only upto 2 fractional seconds? Hi, We have Teradata 12 on Linux SLES10 - SP1 When i run the command (several times, for comparision and i removed the timezone info from results): select current_timestamp(6); 2...
2919 Feb 2012 @ 01:56 PSTDatabaseTopicSelect number not in a column Hi, i have a table A with column 'ID' that holds positive integer values Now i want to find the minimum value not in this column and less than 10 (say) A.ID 1 2 4 ...
2816 Feb 2012 @ 05:11 PSTDatabaseTopicSet unix variable inside bteq Hi, i have a script where i want to set unix variable inside bteq script and then use this variable further in the bteq script too. script1.sh VAR_FLAG="" bteq <...
2709 Dec 2008 @ 03:10 PSTToolsReplybteq runfile quit problemThanks Fred.How can i avoid the 'Warning: EOF on INPUT stream.' message without terminating the bteq?Is there a way to tell that this is the end of the runfile but not the end of the bteq?-srinivas
2609 Dec 2008 @ 01:54 PSTToolsTopicbteq runfile quit problemHi,I have this bteq, omitted the logon and sql info at the start,and the RUN_FILE does have some statements that will cause failures:a) .export reset .run file=${RUN_FILE} .if errorleve...
2517 Nov 2008 @ 02:26 PSTToolsReplyHow to Bteq RUN FILE from windowsThanks Adeel,that link is exactly what i was looking for.-srinivas
2416 Nov 2008 @ 08:20 PSTToolsTopicHow to Bteq RUN FILE from windowsHi,in one of my windows applications, i am calling several teradata sql statements one at a time.In Visual Studio 2008, i am using System.Data.Odbcand callingOdbcConnection and OdbcCommandInstead o...
2313 Nov 2008 @ 05:03 PSTDatabaseTopicMultiple outer joinsHi,i have to convert an oracle sql into teradata that has multiple left outer joinsIn oracleselect .... from a,b,cwherea.id=b.id(+) anda.id=c.id(+)With teradata i am able to do one left outer join ...
2212 Nov 2008 @ 11:13 PSTTrainingReplyVersion 12 certificationTeradata 13.0 is around the corner and will be released in the Q2 of 2009. The next certification track after V2R5 is for TD13 and will be available in Q4 2009.http://www.teradata.com/t/page/178254...
2108 Nov 2008 @ 04:24 PSTDatabaseReplyReset identity column counterThanks Jim and dnoeth.I simplified my case here to just one table. Infact, the database has several tables and each has an identity columnand some tables are children of others and hence the Soft R...
2007 Nov 2008 @ 11:42 PSTDatabaseReplyDifference in DBQL Tables V2R6 and V2R12(Demo).Hi,just want to correct 'v2r12' in the topic.Version 1 has 5 major releases and Version 2 has 6 major releases, total 11.The next release is called TD12, 'v2r12' is not a valid release name.From Te...

Pages