#DateForumTypeThreadPost
59407 Sep 2016 @ 09:51 PDTGeneralReplyConverting Unix/EPOCH time to PSTYou 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. ...
59331 Aug 2016 @ 06:57 PDTConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityTo 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...
59229 Aug 2016 @ 01:21 PDTDatabaseReplymoving first 4 characters to last 4 charactersThe 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...
59124 Aug 2016 @ 06:54 PDTConnectivityReplyUsing 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.
59024 Aug 2016 @ 06:47 PDTConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityThe 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.  ...
58923 Aug 2016 @ 06:49 PDTDatabaseReplyCan 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.
58823 Aug 2016 @ 06:46 PDTDatabaseReplyResource Monitoring While Running Sql querriesViewpoint is a web application. You do not need console access to the Teradata Database system in order to use Viewpoint.
58723 Aug 2016 @ 06:43 PDTConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityisNullable 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...
58622 Aug 2016 @ 11:03 PDTConnectivityReplyQuerying 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...
58522 Aug 2016 @ 10:27 PDTConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityCorrection: 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...
58422 Aug 2016 @ 10:22 PDTConnectivityReplyTeradata 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...
58319 Aug 2016 @ 01:50 PDTDatabaseReplySet 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...
58219 Aug 2016 @ 09:41 PDTDatabaseReplySet 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...
58119 Aug 2016 @ 08:27 PDTConnectivityReplyTeradata 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 ...
58018 Aug 2016 @ 11:44 PDTDatabaseReplyUse 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 ...
57918 Aug 2016 @ 11:42 PDTDatabaseReplyUse 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 "...
57818 Aug 2016 @ 06:55 PDTConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullabilityWhich 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...
57709 Aug 2016 @ 10:19 PDTDatabaseReplyretrieve row count from Teradata MacroYou 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...
57609 Aug 2016 @ 09:42 PDTToolsReplyReg: SQL Assistant download for Mac OSSQL 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...
57509 Aug 2016 @ 09:24 PDTConnectivityReplyError while getting database functions via JDBCWork on that is in progress. We plan to provide support for the DatabaseMetaData.getFunctions method in an upcoming release of the Teradata JDBC Driver.
57409 Aug 2016 @ 09:16 PDTConnectivityReplyTeradata JDBC Connection FailureTeradata 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...
57303 Aug 2016 @ 11:31 PDTToolsReplyTPT 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...
57211 Jul 2016 @ 08:11 PDTDatabaseReplySQL error using Teradata JDBCYou 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...
57105 Jul 2016 @ 06:50 PDTConnectivityReplyJDBC Fastload Error TablesGenerally 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...
57027 Jun 2016 @ 07:07 PDTDatabaseReplyDatabase 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"...

Pages