All forum activity

#DateUserForumTypeThreadPost
2695331 Aug 2012 @ 04:43 PDTTD_DEV245DatabaseTopicfloat data type in teradata I have to do the following transformation Round(sum(column),2)   The datatype of column is float.. Round() function is available in oracle. --How to implement this requi...
2695231 Aug 2012 @ 04:36 PDTdeva_048AnalyticsTopicNeed to calculate days Date Table: Table name:control_date cols: Processdate For E.g) Processing date will have 8/30/2012 Query: (Its failed for invalid date) select processdate + (INTERVAL '1'...
2695131 Aug 2012 @ 04:14 PDTkleeDatabaseTopichow to get the sqltext from queries that ran during an time interval without enabling logging? Hello. I want to get the sql text of the queries that ran at the database during a interval time without enabling the logging mechanisms (access or query). Is there any system table/view tha...
2695031 Aug 2012 @ 02:53 PDTrameshp4567ConnectivityReplyTrying to set up ODBC connection please tell me how uninstall teradata 13
2694930 Aug 2012 @ 08:34 PDTAlisonGeneralReplyHow to see the unused indexes for a queryYou can see which indexes were used by looking at the EXPLAIN. To see when an index was last used, you can run the following query. It is not speific to a query. SELECT DatabaseName , Table...
2694830 Aug 2012 @ 06:01 PDTbysanivkGeneralReplyDatastage - Bteq Connectivity issue   Hi The best way to solve this issue call the library just before invoking the bteq export LIBPATH=/usr/lib it should work! Regards, Vijay
2694730 Aug 2012 @ 02:10 PDTChuckbertToolsReplyError during Teradata Plug-in for Eclipse Installation @forresr2 The Teradata Plug-in for Eclipse has some dependencies that aren't in the basic Eclipse package. The Installation Guide (found on the same page as the plug-in's download) expla...
2694630 Aug 2012 @ 12:49 PDTkeplerDatabaseTopicDBQLOBJTBL - unknown values Hi , The field typeofuse of the table dbc.dbqlobjtbl according to the manual (TD14) has the following values: 1 = Found in the resolver • 2 = Accessed during query processing ...
2694530 Aug 2012 @ 11:58 PDTPrivate Forum
2694430 Aug 2012 @ 11:40 PDTm1bToolsTopicArcMain IOMODULE error "DataConnector will not be able to determine the RECORD length." Hi, I have a module written in C, compiled as a shard object, passed to ArcMain via IOMODULE. It runs fine in a 32 bit environment with 32 bit arcmain, but when I run it with the 64 bit arcm...
2694330 Aug 2012 @ 11:27 PDTJigarGeneralReplyUpdate select optimization Check if update can be changed to left outer join of insert script of table A. Updates are usually heavy compared to Inserts. See if table is SET table ,on doing updates it might have to sca...
2694230 Aug 2012 @ 11:01 PDTTheenaTeradata ApplicationsTopicIF Column1 = Column2 => Merge data of Column3 in one cell I have this table:     Book Task Assignee 723983 A5Q Maria 7239...
2694130 Aug 2012 @ 10:16 PDTtomnolanConnectivityReplyProblems in connecting to Teradata from Java on AIX I just successfully tested the Teradata JDBC Driver on an AIX 5.3 machine using the following JVMs. 32-bit JDK 6.0 from 2007: java version "1.6.0" Java(TM) SE Runtime Environ...
2694030 Aug 2012 @ 07:17 PDThungtingforspoilsConnectivityTopicInsert Data into Teradata table from excel. Hi,   Please advise if this is the incorrect forum for my query however i was hoping someone may be of assistance.   I am looking to put together some vba code that wil...
2693930 Aug 2012 @ 06:59 PDTulrichDatabaseReplyBetween Times not working case when cast(ASKME_CREAT_TM as time) between cast('08:00:00' as time) and cast('12:00:00' as time) then 'AM' else 'unkown' end, should work as well, so no ne...
2693830 Aug 2012 @ 06:55 PDTWAQDatabaseReplyBetween Times not working As mentioned by Ulrich you need to cast the time to make it time (type) before comparing it. Similarly, you also need to do the same with your dates in WHERE clause (assuming ASKME_CREAT_DT ...
2693730 Aug 2012 @ 06:42 PDTmattie4DatabaseReplyBetween Times not working Ulrich,    I got it to work as this.  Thanks for your help.     SELECT ASKME_CREAT_TM, cast(ASKME_CREAT_TM as time) , case when ASKME_CREAT...
2693630 Aug 2012 @ 06:30 PDTmattie4DatabaseReplyBetween Times not working ASKME_CREAT_TM is a [TIME(0)] field.   I had posted the syntax wrong and corrected it below.    I can do CASE When AskME_CREAT_TM  09:00:00 for example, and it...
2693530 Aug 2012 @ 03:15 PDTdevallu_yToolsReplyTPT script: error while executing TPT script Hi,   Please find the data connector part below:   define operator <name> type dataconnector producer schema <name> attributes( varchar file...
2693430 Aug 2012 @ 03:11 PDTulrichDatabaseReplyParent Child Relationship Flattening Your DDL seems not to be matching the inserts.   Below SQLs should do CREATE SET TABLE TEST123 ( PARENT VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, CHILD VARCHAR(20) CHAR...
2693329 Aug 2012 @ 11:45 PDTdraoToolsReplyfastexport gives Access module error '34' Its purely result of insufficient disk space. I had the same issue and i corrected it by changing the file output directory location.
2693229 Aug 2012 @ 10:35 PDTsid.deConnectivityReplyProblems in connecting to Teradata from Java on AIX   Hi Tom ,       Thanks for your reply .         The JDK version on the AIX box is :-       $ $JDK_H...
2693129 Aug 2012 @ 02:37 PDTforresr2ToolsTopicError during Teradata Plug-in for Eclipse Installation Hello, I'm having trouble with the following error while attempting to install the TD plugin for Eclipse.   Any Ideas for finding a resolution?   Interacting with...
2693029 Aug 2012 @ 10:09 PDTjwh_wsToolsReplyText Qualifiers in Teradata Utilities Why not upgrade to TPT 14 to get the benefit of this feature?  This is a supported option by GSC and also decomposes the tasks of upgrading to the next version of the database.  I.e., ...
2692929 Aug 2012 @ 09:56 PDTfeinholzToolsReplyTeradata Wallet Have you tried putting the text "$tdwallet(put_item_name_here)" as the value of the UserPassword attribute (or on the command line with the -u option, or in the job variable file)?

Pages