#DateForumTypeThreadPost
1326 Mar 2014 @ 07:33 PDTDatabaseReplyInformatica ODBC ErrorHi, We received this error too recently. Did you ever figure out what was wrong? Thanks, Todd
1227 Feb 2014 @ 09:54 PSTToolsReplytdload having issues loading data where the delimiter is part of a fieldDoes TPT14.10 support handling embedded CR\LF in a text file? Example a street address like this where a record spans two lines in a file: “Cartersville-Bartow Co. HFH PO Box 3392”
1117 Feb 2014 @ 12:06 PSTToolsTopicTPT - Handling Delimited File with Embedded CR\LF in fieldHi, I have a file which is comma delimited with fields in double quotes and some comment fields have embedded CR/LF within the fields. How do I preserve the CR\LF and load the file using TPT Load ...
1016 Jan 2014 @ 06:23 PSTToolsReplyTeradata Wallet and OLE DB LoadThanks, Sudhansu. That worked perfect for me.
915 Jan 2014 @ 09:37 PSTToolsTopicTeradata Wallet and OLE DB LoadHello, Is there a way to use the Teradata Wallet with the Teradata OLE DB Load utility? I see SSO as an option, but I would like to use the Wallet functionality.
824 Sep 2013 @ 08:53 PDTConnectivityTopicTeradata .NET Provider vs ODBCHello,   Is the Teradata .NET Provider more efficient (faster) than connecting to the database via ODBC? This may be a silly question, but can Informatica use the Teradata .NET provider? Th...
710 Jun 2013 @ 08:10 PDTDatabaseReplyVariable Object Name in Dynamic CursorI think I figured it out the second I hit the submit button. Change from: SET SqlStr = 'SELECT count(*) FROM '|| '?' || '.AuditLogs '; To SET SqlStr = 'SELECT count(...
610 Jun 2013 @ 08:04 PDTDatabaseTopicVariable Object Name in Dynamic CursorHello, I am trying to parameterize on object referenced in my dynamic cursor. Let's say I have a table in three different databases called AuditLogs that I want to dynamically query the d...
504 Mar 2013 @ 10:02 PSTDatabaseTopicSurrogate Key QuestionIs there a way to generate a surrogate key dynamically using set processing rather than record level processing? We have a large amount of records in the source which we need to generate a unique i...
425 Oct 2012 @ 07:43 PDTDatabaseTopicBacking up the database objects without the dataI found a similiar thread to my question, but I am unclear about the answer even after reading the Teradata Archive/Restore manual. Do the following commands backup all the database objects without...
308 Oct 2012 @ 02:01 PDTDatabaseReplyViewpoint data collector - Lock Info errorI am now getting this message: Unable to get lock information from dumplocklog utility! *** Error - Logger was not activated. Q No rows have been inserted to table 'VIEWPOINT'.'LOCKLOG...
208 Oct 2012 @ 11:56 PDTDatabaseTopicViewpoint data collector - Lock Info errorI am trying to setup Viewpoint to capture locks. However, I get the following error as a ! within a red triangle. Unable to get lock information from dumplocklog utility! [Teradata Database] [Tera...
113 Sep 2012 @ 12:46 PDTDatabaseTopicInvalid TimeStamp Literal when defaulting a timestamp column This fails with a syntax error of CREATE TABLE Failed. 3706:  Syntax error: Invalid TimeStamp Literal. :   CREATE SET TABLE TEST,      NO...