#DateForumTypeThreadPost
1702 Jun 2015 @ 01:31 PDTToolsReplyLoading carriage returns with TPT Load OperatorFor this scenario of loading \n embedded in data fields, is that possible with any other operators in TPT at all ? 
1629 May 2015 @ 12:04 PDTDatabaseReplyRemoving a line break character in a columnTD_SYSFNLIB.OTRANSLATE() is documented to return the character set of the source_string argument.  This is normal , if LATIN is input, Latin should be output and same for unicode.  Howev...
1529 Jan 2014 @ 06:37 PSTViewpointReplyViewpoint SSL Certificate errorSame problem here , but in my case version is Teradata Viewpoint V14.10.00.04-b38 and i know the cert file is valid , because i was able to import it into a 14.00 viewpoint server using a non gui p...
1428 Feb 2013 @ 08:10 PSTToolsReplyTPT export formatted/ timestamp schema mismatchThat must be it. I am running Teradata Parallel Transporter Version 13.10.00.04 . We will upgrade ideally to 14. Thanks feinholz!  
1326 Feb 2013 @ 07:12 PSTToolsReplyTPT export formatted/ timestamp schema mismatchSorry, i was masking data fields in the above TPT and missed the schema name. In the real script they do match. I think the issues is related to TIMESTAMP and UTF8 because once i get the timestamp ...
1225 Feb 2013 @ 09:17 PSTToolsTopicTPT export formatted/ timestamp schema mismatchHello Teradata experts, I am getting EXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement with the following TPT script. Could anyone hint me what i am doing wrong p...
1119 Feb 2013 @ 09:05 PSTDatabaseTopicselect FirstRespTime ,* from DBC.DBQLogTblThis is more of a convenience to frontshow some columns, maybe expressions, but still show all columns in the result set if needed. Is there some special syntax to achieve this? I have been able to...
1025 Jan 2013 @ 06:36 PSTToolsTopicTPT 14.00 DEFINE SCHEMA / DELIMITED optionCan someone please explain the usage and the proper syntax for the the DEFINE SCHEMA 'name' DELIMTED 'tablename';  introduced in TPT 14.00 reference manual diagram on page 62 /...
916 Jan 2013 @ 07:39 PSTToolsReplyTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR?Hm, i am seeing something different in the TPT 14 Reference manual . page 126 / revision June 2012 Format = 'Delimited' ....<text removed here> With this file format, all of the ...
809 Jan 2013 @ 09:21 PSTToolsReplyTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR?14.0 books have the examples removed from the user guide manual and added onto /opt/teradata/client/14.00/tbuild/sample/userguide/ folder. However they still contain at least a non working example...
708 Jan 2013 @ 07:29 PSTDatabaseTopicerror when loading into column partititioned tableHello, I am seeing this error when loading into a column partitioned table ( TD 14.00) . The table create executes fine and i can also insert a subset of columns, however i see this error when...
606 Nov 2012 @ 09:00 PSTDatabaseTopicshow view does not show databasename in viewnameI am trying to export all objects from certain databases . I noticed in some cases the show view output does not contain a databasename, probably using the default database. Is it possible to force...
525 Oct 2012 @ 03:47 PDTViewpointTopicDataGrid widget usabilityHello, I am trying to use the DataGrid widget for the practical purpose of displaying a Teradata table. For that i need to change the column definition among other things. I started with the work...
425 Oct 2012 @ 01:30 PDTViewpointReplyvp:tableWidget with higher height gets Exception in thread "Timer-2" java.lang.OutOfMemoryError: PermGen spaceAlso the vertical scrollbar on the tableWidget does not seem to more the data in the table.
325 Oct 2012 @ 12:52 PDTViewpointTopicvp:tableWidget with higher height gets Exception in thread "Timer-2" java.lang.OutOfMemoryError: PermGen spaceI have modified the widgetopia portlet by increasing the height of the tablewidget. After deploying the protlet, now Tomcat keeps  throwing out of memory exceptions. The reason i modified the...
213 Sep 2012 @ 02:14 PDTViewpointReplyBulk Load for Viewpoint users We would like to use this API com.teradata.viewpoint.security.identity.impl.IdentityManagerImpl to load users from external scripts. Is this API usable from outside the portal JVM ? If so, what ...
113 Sep 2012 @ 01:11 PDTViewpointReplyBulk Load for Viewpoint users Trying to do the same user loading programmatically. How would one use ( if its possible) com.teradata.viewpoint.security.identity.impl.IdentityManagerImpl to add a user to viewpoint outside of ...