All forum activity

#DateUserForumTypeThreadPost
5929419 Aug 2016 @ 01:50 PDTtomnolanDatabaseReplySet QueryBand as JDBC Connection ParameterIf you are using Teradata Database 14.0 or later, have you considered examining the Client Attributes information?   It is documented here: http://developer.teradata.com/doc/connectivity/jd...
5929319 Aug 2016 @ 01:43 PDTfeinholzToolsReplyUnicode Export through TPTIn order to see the chinese/japanese characters, you MUST specify either UTF8 or UTF16 as the character set in the script.   If you specify UTF8, you must triple the size of the character fi...
5929219 Aug 2016 @ 01:37 PDTZackHoweTeradata Database on VMWareTopicSetting up Teradata Python Module on VMware imageI was trying to run the Python module on my VMware instance, and ran into a stack of problems. The python version on the VM instance (TDExpress15.10.0.7_Sles11_40GB_vp) was 2.6.9 which doesn't...
5929119 Aug 2016 @ 01:21 PDTsrivigneshknToolsTopicUnicode Export through TPT Hi,    I need to export few chinese and japanese characters stored in teradata to a file.   I have tried different options to export data through TPT but i am eith...
5929019 Aug 2016 @ 12:29 PDTsrivigneshknToolsReplyTPT export into AWS S3 buckets.Thanks Steve.
5928919 Aug 2016 @ 12:00 PDTFredDatabaseReplySQL command for setting connection option to return generated keysThere is no SQL statement to change this option. And PyTd doesn't allow you to access a Statement object directly.   Have you considered using an external configuration file?
5928819 Aug 2016 @ 11:42 PDTashbachjConnectivityTopicSegfault fetching results via ruby-odbc on MacHello, we are attempting to connect to a Teradata database using ruby-odbc. Our code works properly on our Windows machines but it has a segfault on a Mac. I have reproduced the error message and c...
5928719 Aug 2016 @ 11:31 PDTsagar_GeneralReplyinterview helpHi, Please forward the questions to sagarcastic@gmail.com
5928619 Aug 2016 @ 10:00 PDTdfranks44DatabaseReplySet QueryBand as JDBC Connection ParameterThanks Tom!  I didn't know about the RUNSTARTUP option and that is interesting but I don't think it will help me in this particular scenario. The issue I am trying to solve is tha...
5928519 Aug 2016 @ 09:41 PDTtomnolanDatabaseReplySet QueryBand as JDBC Connection ParameterThe Teradata JDBC Driver does not offer a "QueryBand" connection parameter.   All the Teradata JDBC Driver's connection parameters are documented here: http://developer.terada...
5928419 Aug 2016 @ 08:27 PDTtomnolanConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityThat logic in Apache Spark is incomplete. The ResultSetMetaData.isNullable method can return 3 possible values: columnNoNulls indicates that a column does not allow NULL values. columnNullable ...
5928319 Aug 2016 @ 07:09 PDTVandeBergBDatabaseReplyCreate NUPI and USI having the same ColumnWell for starters, you should be building a multiset table, especially if you're going to use a unique index.  Using a NUPI with a USI is a pretty standard construct, as the NUPI is really...
5928219 Aug 2016 @ 07:02 PDTVandeBergBDatabaseReplyResource Monitoring While Running Sql querriesTeradata Viewpoint is your monitoring portal and a window to all things operational.
5928119 Aug 2016 @ 06:54 PDTurskumarDatabaseTopicHow to convert the varchar to time(6) In Teradata?Hi Experts   I have time value in the source with the datatype varchar(100), Need to conver this to time(6).   values with the varchar 11:30, 12:30: 01.00 like this...Need to convert ...
5928019 Aug 2016 @ 06:31 PDTashokn1989DatabaseTopicUpdating second row value to new column first rowHi   I have a table Id        rn            col1          col2         new_col aa   &nbs...
5927919 Aug 2016 @ 06:21 PDTbhushan.koliDatabaseTopicResource Monitoring While Running Sql querriesHow to mointor CPU,Memory,and KB/sec  while running querries in teradata 
5927819 Aug 2016 @ 06:21 PDTbhushan.koliDatabaseTopicResource Monitoring While Running Sql querriesHow to mointor CPU,Memory,and KB/sec  while running querries in teradata 
5927719 Aug 2016 @ 05:15 PDTSmacDatabaseReplyCreate NUPI and USI having the same ColumnHi.. Myself to have same question.. I have table with order id, date, amount and table going to hold billion of record for each day, where we need to maintain only 3 year of date. table going to...
5927619 Aug 2016 @ 03:55 PDTdnoethDatabaseReplyHow to make substring with the second or third occurrence of a charaterMaybe this issue was fixed in a version after 14.00.03.02, time to get the latest patch level (or upgrade)
5927519 Aug 2016 @ 03:53 PDTdnoethToolsReplyMonth days !!!What DBMS is this? Looks like MS SQL Server, but this CURRENT_DATE.DAY is strange.   Would be easier if you add the current result, but this seems to return the last day of the current...
5927419 Aug 2016 @ 03:45 PDTdnoethTeradata DebuggerReplyFetching the last date of the current Quarter !!! If you consider this correct: SELECT TRUNC(ADD_MONTHS(DATE '2016-10-20',-1),'Q'); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 seco...
5927319 Aug 2016 @ 03:35 PDTdnoethUDAReplyCONVERT and DATEDIFF in TeradataSee the TimeStamp_to_UnixTime UDF found in http://forums.teradata.com/forum/general/convert-13-digit-epoch-time-to-date
5927219 Aug 2016 @ 03:25 PDTdnoethDatabaseReplyPadding and timestampYou can use a Regular Expression to add the missing zeroes:  REGEXP_REPLACE(FDOE_QTR, '\b([0-9])\b', '0\1') see: http://forums.teradata.com/forum/enterprise/convert-varchar-t...
5927119 Aug 2016 @ 03:12 PDTCarlosALDatabaseReplyPadding and timestampHi. You may take a look at this thread: http://forums.teradata.com/forum/database/converting-string-to-date-using-regexp-getting-error-3798 HTH. Cheers. Carlos.
5927019 Aug 2016 @ 02:25 PDTSwati@tdToolsReplySQL Assistant Change Password Hi, To change the password in SQL Assistant you must log in to the system

Pages