594 | 07 Sep 2016 @ 09:51 PDT | General | Reply | Converting Unix/EPOCH time to PST | You said that you wanted to get the "PST date", but time zones are not associated with DATE values. In other words, the Teradata Database does not offer a DATE WITH TIME ZONE data type.
... |
593 | 31 Aug 2016 @ 06:57 PDT | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | To cover this feature request, I created JDBC RFC 183490 "Connection parameter MAYBENULL for ResultSetMetaData.isNullable variant behavior".
If you're a customer, you can use... |
592 | 29 Aug 2016 @ 01:21 PDT | Database | Reply | moving first 4 characters to last 4 characters | The DATE FORMAT approach is probably better, but since you mentioned substring, for comparison, the substring+concatenation approach would look like the following:
select substring(cast(ti... |
591 | 24 Aug 2016 @ 06:54 PDT | Connectivity | Reply | Using RJDBC and connected successfully, I get errors when trying to write using "as.td.data.frame" or "dbWriteTable"... | @jknife What problem are you encountering? Please post details of your code and what error you are seeing.
|
590 | 24 Aug 2016 @ 06:47 PDT | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | The Teradata JDBC Driver's ResultSetMetaData.isNullable method has worked the way it does for several years, and we need to preserve its current behavior for applications that expect it.
 ... |
589 | 23 Aug 2016 @ 06:49 PDT | Database | Reply | Can we pass object as parameter in a macro ? | No, you cannot pass an object name as a macro parameter. Macro parameters cannot be used as database object names.
|
588 | 23 Aug 2016 @ 06:46 PDT | Database | Reply | Resource Monitoring While Running Sql querries | Viewpoint is a web application. You do not need console access to the Teradata Database system in order to use Viewpoint.
|
587 | 23 Aug 2016 @ 06:43 PDT | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | isNullable refers to the storage, while mayBeNull refers to the result set column.
As I recall, OLEDB is the only database interface that exposes the concept of mayBeNull. The concept... |
586 | 22 Aug 2016 @ 11:03 PDT | Connectivity | Reply | Querying Teradata from JavaScript/jQuery? | Teradata REST Services is available from AWS: https://aws.amazon.com/marketplace/pp/B01DJUOW10
Also, if you're a customer, Teradata REST Services is available from "Teradata at Yo... |
585 | 22 Aug 2016 @ 10:27 PDT | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | Correction: In my post above, where I said that the nullability for column c2 is inaccurate -- it's actually the nullability for column c1 that is inaccurate.
Column c1 doesn't hav... |
584 | 22 Aug 2016 @ 10:22 PDT | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | >>> Maybe it's related to sub-queries messing up the nullability? Is this a known limitation?
In short, Yes.
Your subquery is used as a derived table. Here is a... |
583 | 19 Aug 2016 @ 01:50 PDT | 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... |
582 | 19 Aug 2016 @ 09:41 PDT | 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... |
581 | 19 Aug 2016 @ 08:27 PDT | 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 ... |
580 | 18 Aug 2016 @ 11:44 PDT | Database | Reply | Use teradata with jmeter | The Apache JMeter documentation says that the JDBC Driver's jar files must be present on JMeter's classpath, and also says that it is "easiest to copy .jar file into JMeter's ... |
579 | 18 Aug 2016 @ 11:42 PDT | Database | Reply | Use teradata with jmeter | Documentation for how to configure a JDBC connection for JMeter is available here:
http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Connection_Configuration
For the "... |
578 | 18 Aug 2016 @ 06:55 PDT | Connectivity | Reply | Teradata JDBC Driver returns the wrong schema / column nullability | Which JDBC API method does your application call in order to obtain the column nullability information?
If your application is calling the ResultSetMetaData.isNullable method, for that met... |
577 | 09 Aug 2016 @ 10:19 PDT | Database | Reply | retrieve row count from Teradata Macro | You must use the EXECUTE MacroName command to execute a macro, and No, it is not possible to use an execute command as a sub-select or derived table.
Hypothetical SQL syntax that is NOT su... |
576 | 09 Aug 2016 @ 09:42 PDT | Tools | Reply | Reg: SQL Assistant download for Mac OS | SQL Assistant is a Windows-only product, and is not available on Mac OS.
As an alternative, we recommend Teradata Studio or Teradata Studio Express for use on Mac OS. They are availab... |
575 | 09 Aug 2016 @ 09:24 PDT | Connectivity | Reply | Error while getting database functions via JDBC | Work on that is in progress. We plan to provide support for the DatabaseMetaData.getFunctions method in an upcoming release of the Teradata JDBC Driver.
|
574 | 09 Aug 2016 @ 09:16 PDT | Connectivity | Reply | Teradata JDBC Connection Failure | Teradata Studio Express does not include the Teradata Database.
There are several free versions of the Teradata Database available for download. You must download them separately from Tera... |
573 | 03 Aug 2016 @ 11:31 PDT | Tools | Reply | TPT with JDBC to Kafka | >>> Is it possible to use JDBC with TPT?
No.
>>> Or do I just use JDBC with FastExport?
The Teradata JDBC Driver offers a JDBC FastExport feature; howev... |
572 | 11 Jul 2016 @ 08:11 PDT | Database | Reply | SQL error using Teradata JDBC | You said that you are trying to find the reason for the behavior difference.
As I mentioned already, the behavior difference is likely due to you using different transaction modes in the s... |
571 | 05 Jul 2016 @ 06:50 PDT | Connectivity | Reply | JDBC Fastload Error Tables | Generally speaking, there is no need for the JDBC FastLoad error tables to persist. The FastLoad error information is provided to your application as an exception chain.
Please remember th... |
570 | 27 Jun 2016 @ 07:07 PDT | Database | Reply | Database per object type -- Best practice or over engineered? | >>> Is there a way to create a generically named link or alias to a database?
No, the Teradata Database does not offer that feature.
>>> I see "DB Link"... |