59292 | 19 Aug 2016 @ 01:50 PDT | tomnolan | Database | Reply | Set QueryBand as JDBC Connection Parameter | If 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... |
59291 | 19 Aug 2016 @ 01:43 PDT | feinholz | Tools | Reply | Unicode Export through TPT | In 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... |
59290 | 19 Aug 2016 @ 01:37 PDT | ZackHowe | Teradata Database on VMWare | Topic | Setting up Teradata Python Module on VMware image | I 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... |
59289 | 19 Aug 2016 @ 01:21 PDT | srivigneshkn | Tools | Topic | Unicode 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... |
59288 | 19 Aug 2016 @ 12:29 PDT | srivigneshkn | Tools | Reply | TPT export into AWS S3 buckets. | Thanks Steve.
|
59287 | 19 Aug 2016 @ 12:00 PDT | Fred | Database | Reply | SQL command for setting connection option to return generated keys | There 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?
|
59286 | 19 Aug 2016 @ 11:42 PDT | ashbachj | Connectivity | Topic | Segfault fetching results via ruby-odbc on Mac | Hello, 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... |
59285 | 19 Aug 2016 @ 11:31 PDT | sagar_ | General | Reply | interview help | Hi,
Please forward the questions to sagarcastic@gmail.com
|
59284 | 19 Aug 2016 @ 10:00 PDT | dfranks44 | Database | Reply | Set QueryBand as JDBC Connection Parameter | Thanks 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... |
59283 | 19 Aug 2016 @ 09:41 PDT | tomnolan | Database | Reply | Set QueryBand as JDBC Connection Parameter | The Teradata JDBC Driver does not offer a "QueryBand" connection parameter.
All the Teradata JDBC Driver's connection parameters are documented here:
http://developer.terada... |
59282 | 19 Aug 2016 @ 08:27 PDT | tomnolan | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | That 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 ... |
59281 | 19 Aug 2016 @ 07:09 PDT | VandeBergB | Database | Reply | Create NUPI and USI having the same Column | Well 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... |
59280 | 19 Aug 2016 @ 07:02 PDT | VandeBergB | Database | Reply | Resource Monitoring While Running Sql querries | Teradata Viewpoint is your monitoring portal and a window to all things operational.
|
59279 | 19 Aug 2016 @ 06:54 PDT | urskumar | Database | Topic | How 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 ... |
59278 | 19 Aug 2016 @ 06:31 PDT | ashokn1989 | Database | Topic | Updating second row value to new column first row | Hi
I have a table
Id rn col1 col2 new_col
aa &nbs... |
59277 | 19 Aug 2016 @ 06:21 PDT | bhushan.koli | Database | Topic | Resource Monitoring While Running Sql querries | How to mointor CPU,Memory,and KB/sec while running querries in teradata
|
59276 | 19 Aug 2016 @ 06:21 PDT | bhushan.koli | Database | Topic | Resource Monitoring While Running Sql querries | How to mointor CPU,Memory,and KB/sec while running querries in teradata
|
59275 | 19 Aug 2016 @ 05:15 PDT | Smac | Database | Reply | Create NUPI and USI having the same Column | Hi..
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... |
59274 | 19 Aug 2016 @ 03:55 PDT | dnoeth | Database | Reply | How to make substring with the second or third occurrence of a charater | Maybe this issue was fixed in a version after 14.00.03.02, time to get the latest patch level (or upgrade)
|
59273 | 19 Aug 2016 @ 03:53 PDT | dnoeth | Tools | Reply | Month 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... |
59272 | 19 Aug 2016 @ 03:45 PDT | dnoeth | Teradata Debugger | Reply | Fetching 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... |
59271 | 19 Aug 2016 @ 03:35 PDT | dnoeth | UDA | Reply | CONVERT and DATEDIFF in Teradata | See the TimeStamp_to_UnixTime UDF found in http://forums.teradata.com/forum/general/convert-13-digit-epoch-time-to-date
|
59270 | 19 Aug 2016 @ 03:25 PDT | dnoeth | Database | Reply | Padding and timestamp | You 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... |
59269 | 19 Aug 2016 @ 03:12 PDT | CarlosAL | Database | Reply | Padding and timestamp | Hi.
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.
|
59268 | 19 Aug 2016 @ 02:25 PDT | Swati@td | Tools | Reply | SQL Assistant Change Password | Hi,
To change the password in SQL Assistant you must log in to the system
|