|26953||31 Aug 2012 @ 04:43 PDT||TD_DEV245||Database||Topic||float data type in teradata||
I have to do the following transformation
The datatype of column is float..
Round() function is available in oracle.
--How to implement this requi... |
|26952||31 Aug 2012 @ 04:36 PDT||deva_048||Analytics||Topic||Need to calculate days||
Processing date will have 8/30/2012
Query: (Its failed for invalid date)
select processdate + (INTERVAL '1'... |
|26951||31 Aug 2012 @ 04:14 PDT||klee||Database||Topic||how 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... |
|26950||31 Aug 2012 @ 02:53 PDT||rameshp4567||Connectivity||Reply||Trying to set up ODBC connection||
please tell me how uninstall teradata 13
|26949||30 Aug 2012 @ 08:34 PDT||Alison||General||Reply||How to see the unused indexes for a query||You 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.
, Table... |
|26948||30 Aug 2012 @ 06:01 PDT||bysanivk||General||Reply||Datastage - Bteq Connectivity issue||
The best way to solve this issue call the library just before invoking the bteq
it should work!
|26947||30 Aug 2012 @ 02:10 PDT||Chuckbert||Tools||Reply||Error 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... |
|26946||30 Aug 2012 @ 12:49 PDT||kepler||Database||Topic||DBQLOBJTBL - unknown values||
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
|26945||30 Aug 2012 @ 11:58 PDT||Private Forum |
|26944||30 Aug 2012 @ 11:40 PDT||m1b||Tools||Topic||ArcMain IOMODULE error "DataConnector will not be able to determine the RECORD length."||
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... |
|26943||30 Aug 2012 @ 11:27 PDT||Jigar||General||Reply||Update 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... |
|26942||30 Aug 2012 @ 11:01 PDT||Theena||Teradata Applications||Topic||IF Column1 = Column2 => Merge data of Column3 in one cell||
I have this table:
|26941||30 Aug 2012 @ 10:16 PDT||tomnolan||Connectivity||Reply||Problems 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... |
|26940||30 Aug 2012 @ 07:17 PDT||hungtingforspoils||Connectivity||Topic||Insert Data into Teradata table from excel.||
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... |
|26939||30 Aug 2012 @ 06:59 PDT||ulrich||Database||Reply||Between 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... |
|26938||30 Aug 2012 @ 06:55 PDT||WAQ||Database||Reply||Between 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 ... |
|26937||30 Aug 2012 @ 06:42 PDT||mattie4||Database||Reply||Between Times not working ||
I got it to work as this. Thanks for your help.
cast(ASKME_CREAT_TM as time) ,
case when ASKME_CREAT... |
|26936||30 Aug 2012 @ 06:30 PDT||mattie4||Database||Reply||Between 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... |
|26935||30 Aug 2012 @ 03:15 PDT||devallu_y||Tools||Reply||TPT script: error while executing TPT script||
Please find the data connector part below:
define operator <name>
type dataconnector producer
varchar file... |
|26934||30 Aug 2012 @ 03:11 PDT||ulrich||Database||Reply||Parent 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... |
|26933||29 Aug 2012 @ 11:45 PDT||drao||Tools||Reply||fastexport 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.
|26932||29 Aug 2012 @ 10:35 PDT||sid.de||Connectivity||Reply||Problems in connecting to Teradata from Java on AIX ||
Hi Tom ,
Thanks for your reply .
The JDK version on the AIX box is :-
$ $JDK_H... |
|26931||29 Aug 2012 @ 02:37 PDT||forresr2||Tools||Topic||Error during Teradata Plug-in for Eclipse Installation||
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... |
|26930||29 Aug 2012 @ 10:09 PDT||jwh_ws||Tools||Reply||Text 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., ... |
|26929||29 Aug 2012 @ 09:56 PDT||feinholz||Tools||Reply||Teradata 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)?