#DateForumTypeThreadPost
2508 Jul 2016 @ 10:07 PDTDatabaseReplySQL error using Teradata JDBCNOTE that this SQL works on SQL and Teradata Express but not through the JDBC driver and JNDI.
2413 Jun 2016 @ 09:39 PDTDatabaseReplySQL 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...
2313 Jun 2016 @ 09:38 PDTDatabaseTopicSQL 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...
2209 May 2016 @ 08:18 PDTConnectivityReplyTD JDBC Driver Upgrade questionThanks Tom.
2102 May 2016 @ 09:40 PDTConnectivityReplyTD JDBC Driver Upgrade questionTom, Thanks for the response. My question was a little different. Sorry if I was not clear. Can the JDBC driver 15.00.00.20 still work with TD 15.10 if we are not using any new features of 15.10 i...
2002 May 2016 @ 08:58 PDTConnectivityTopicTD JDBC Driver Upgrade questionWe are currently on TD 14.10 and use the JDBC driver 15.00.00.20. We  are upgrading to TD 15.10 but are not using any features from 15.10. Is it safe to keep using the 15.00.00.20 driver with ...
1905 Jan 2016 @ 12:08 PSTDatabaseTopicDatabase column size using JDBC getMetdata Hi,   Our application lets admins access Teradata tables through frontend views. Certains columns are editable. We are trying to limits users to enter only a certain length of value given wha...
1802 Sep 2015 @ 10:40 PDTDatabaseTopicDBSControl Setting ObjectUseCountCollectRate Folks, We have the following DBSControl setting but still dont see the Access Count on the objects being populated. What else needs to be done?   ObjectUseCountCollectRate     &nb...
1713 Jun 2015 @ 06:11 PDTDatabaseTopicTO_DATE with LIKE causing issues in Prepared statements using JDBCFacts: We are using the JDBC 15.00.00.20 driver Teradata Version: 14.10.03.03   Problem: Looks like the combination of TO_DATE and LIKE is causing issues when using a JDBC driver and prep...
1611 Jun 2015 @ 08:54 PDTDatabaseReplyTO_DATE in "IN" clauseThanks Dieter. Technically is allows the calculation for one value but not for multiple. Hopefully they will fix it soon
1510 Jun 2015 @ 08:45 PDTDatabaseTopicTO_DATE in "IN" clauseAll, We are trying to use TO_DATE in a IN clause and the syntax checker does not seem to like it. Here are some examples: This works: SELECT * FROM (MEDC_C1prof "CD") WHERE ...
1417 Apr 2015 @ 12:22 PDTDatabaseReplyJDBC Error 1178 Thanks. I did a TAYS ticket this morning
1314 Apr 2015 @ 12:12 PDTDatabaseTopicJDBC Error 1178 All, We are getting this JDBC error and cannot figure out why this is happening. Why I run the SQL through TD Studio (which uses JDBC) I get the results back just fine. Any ideas???   SQL s...
1201 Apr 2015 @ 01:30 PDTDatabaseReplyMULTISET table from dbc.tables?Thanks Tom
1101 Apr 2015 @ 05:42 PDTDatabaseTopicMULTISET table from dbc.tables?Hello, Is there a column I can tap into to figure out if a table is a multiset. RequestText in DBC.Tables is not a good column as it has the latest requesttext, so if the table was altered it has ...
1019 Mar 2015 @ 10:01 PDTDatabaseTopicSET Vs MULTISETI understand that a SET table has an overheard compared to a MULTISET table. The question I have is if we have a SET table with a Unique Index on it, does it help to make it a MULTISET or it does n...
918 Mar 2015 @ 06:55 PDTDatabaseTopicNumOfActiveAMPs - What does a Value of 0 mean?Hello, What does a value of 0 mean in NumofActiveAmps field in dbc.qrylog?   Thanks
804 Mar 2015 @ 07:01 PSTDatabaseReplyBITAND Function not workingFigured it out. It is being overloaded so I basically did SELECT TD_SYSFNLIB.BITAND(9,8) and it worked. Thanks for making me think that it might be getting overloaded!
704 Mar 2015 @ 03:36 PSTDatabaseReplyBITAND Function not workingHere is the ouput of the query. The version is 14.10.03.03    TD_SYSFNLIB BITAND I8BF SYSLIB BITAND BVD  TD_SYSFNLIB BITAND I I  TD_SYSFNLIB BITAND I2BF T...
604 Mar 2015 @ 01:23 PSTDatabaseTopicBITAND Function not workingAll for some reason the BITAND function is not working. The query I am trying to run through SQL Assistant is SELECT BITAND(9,8); The error I am getting is: SELECT Failed. 9881: Function BITAND c...
509 Feb 2015 @ 01:29 PSTViewpointReplyViewpoint has run out of spaceWe tried the cleaning up of the logs directory mentioned above but that did not do it as that folder did have space. It looks like the \data one is filling up and that is where Postgres is writing ...
407 Feb 2015 @ 04:33 PSTViewpointReplyViewpoint has run out of spaceThanks Steve. I will give that a try. Any other ideas anybody?
305 Feb 2015 @ 01:11 PSTViewpointReplyViewpoint has run out of spaceGary, It is an Express ViewPoint. Using the Virtual Machine download and the viewpoint in there. I had played with a lot of setting and did not purge the data and hence got filled. Any ideas?
203 Feb 2015 @ 11:27 PSTViewpointTopicViewpoint has run out of spaceMy Teradata Viewpoint has run out of space. We saw that the all the space on the VM has been filled up by Viewpoint and so it will not even come up any more. Is there anyway of "deleting"...
121 Jan 2013 @ 12:39 PSTGeneralTopicConsolidate List of what datatypes of a column can be altered - from and toI am trying to get a list/mapping of the data types I can change using an alter command and to what.    For example, I am trying to alter an integer column to a bigint and is it not let...