All forum activity

#DateUserForumTypeThreadPost
5939524 Aug 2016 @ 05:39 PDTdnoethToolsReplyfastload cannot start with error "The request exceeds the length limit, The maximum length is 1048500."Can you show the actual FastLoad script?
5939424 Aug 2016 @ 04:47 PDTjingguoToolsTopicfastload cannot start with error "The request exceeds the length limit, The maximum length is 1048500."Hi,   I am writing a fastload script to load a 13M files to a teradata table. I received error       ===================================================================...
5939324 Aug 2016 @ 04:33 PDTHotshotsTeradata StudioReplyTDStudio stopped working after Java updateI have a similar problem. My Java was updated and now the path in TeradataStudio.ini isn't correct anymore. Unfortunately I have no write-access to this file. So, is it possible to specify ...
5939223 Aug 2016 @ 11:17 PDTjknifeConnectivityReplyUsing RJDBC and connected successfully, I get errors when trying to write using "as.td.data.frame" or "dbWriteTable"...4 years later....... Any solution yet?
5939123 Aug 2016 @ 10:04 PDTbhushan.koliDatabaseReplyResource Monitoring While Running Sql querriesThanks !!  
5939023 Aug 2016 @ 06:55 PDTjasonmoore2kConnectivityReplyTeradata JDBC Driver returns the wrong schema / column nullability> The javadoc for the ResultSetMetaData.isNullable method is fairly clear that the method returns information about the underlying storage column ... I'm really not so sure about this ...
5938923 Aug 2016 @ 06:15 PDTToddAWalterDatabaseReplyCan we pass object as parameter in a macro ? Macro parameters are designed for constant substitution only. They can appear only in the places in a statment where a constant value can appear (and not every one of those either - like options in...
5938823 Aug 2016 @ 05:32 PDTagnit.chatterjee1988DatabaseReplyTeradata Implicit CastingThanks Fred. This document contains everything :)
5938723 Aug 2016 @ 02:20 PDTZackHoweTeradata Database on VMWareReplySetting up Teradata Python Module on VMware imageSpoke too soon.  When I tried to install my teradata module in the new python install it yacked because I didn't have SSL support, so the setup couldn't figure out an https address. I...
5938623 Aug 2016 @ 12:19 PDTaaibinderToolsReplyTPT, how to output columns enclosed in quotes?Thanks, worked!
5938523 Aug 2016 @ 12:06 PDTFredDatabaseReplyTeradata Implicit CastingSee the "Implicit Type Conversion of Comparison Operands" topic in SQL Reference: Functions, Operators, Expressions, and Predicates manual. In general, comparing (or joining on) two nume...
5938423 Aug 2016 @ 11:50 PDTFredDatabaseReplyALTER TABLE on UNICODE character type issueAre you specifying additional attributes in the ALTER besides the VARCHAR(40)? I believe this check only looks at which attributes are supplied in the DDL, and fails if you specify any a...
5938323 Aug 2016 @ 10:22 PDTfeinholzToolsReplyTPT, how to output columns enclosed in quotes?Set QuotedData to 'yes'.
5938223 Aug 2016 @ 09:54 PDTgrybackViewpointReplyHow to connect to viewpoint postgres databaseWe don't currently offer API access into Viewpoint although many of the portlets have the "export" capability to pull information out on an ad-hoc basis. APIs are on the roadmap. 
5938123 Aug 2016 @ 09:48 PDTaaibinderToolsTopicTPT, how to output columns enclosed in quotes?So, I'd like a database that's pulling in a file that looks like this:   Right now I have this... blah blah, 123, bleh bleh I want... "blah blah", "123", "...
5938023 Aug 2016 @ 09:20 PDTfeinholzToolsReplyEasyloader Schema Error 15.10 OnlyAs you can see in the column/field definition, you have a FLOAT field. The error is to be expected. In order to process delimited datam the schema must be all VARCHAR. In the job output above fr...
5937923 Aug 2016 @ 08:25 PDTanil_athalyeDatabaseTopicALTER TABLE on UNICODE character type issueHi, I am trying to EXTEND the length of datatype varchar of unicode character set from existing 18 to 40. However, it is giving me an error 3558 Cannot alter the specified attribute(s) ...
5937823 Aug 2016 @ 07:58 PDTaaibinderToolsReplyTPT Script, Only Pull Entries Within Last 6 Months?Thanks!
5937723 Aug 2016 @ 07:34 PDTfeinholzToolsReplyZero records are fetching when using where statement in TPTAs I indicated, you have to write a script for this, not use Easy Loader. We currently have a bug when using Easy Loader and the quotes are being stripped. Thus, if you want to use a SELECT state...
5937623 Aug 2016 @ 06:49 PDTtomnolanDatabaseReplyCan 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.
5937523 Aug 2016 @ 06:46 PDTtomnolanDatabaseReplyResource 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.
5937423 Aug 2016 @ 06:43 PDTtomnolanConnectivityReplyTeradata 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...
5937323 Aug 2016 @ 06:23 PDTvenkata_k01ToolsReplyZero records are fetching when using where statement in TPTHi Steve, PFB the details. Code in the script where select statement is being assigned. $parms{SelectStmt}="SELECT * FROM ${srcdb}.${srctblnm} WHERE STATUS=''A&...
5937223 Aug 2016 @ 06:16 PDTagnit.chatterjee1988DatabaseReplyTeradata Implicit CastingNo. Say 2 tables table_a with column a byteint and other table_b with column b integer When they are joined together :   Select * from table_a join table_b on table_a.a=table_b.b What is ...
5937123 Aug 2016 @ 05:39 PDTbhavesh_09DatabaseReplyCan we pass object as parameter in a macro ? Try execute immediate.

Pages