#DateForumTypeThreadPost
1012 Mar 2015 @ 08:23 PDTDatabaseReplyDefining two derived tables using WITH clause ??Thanks Dieter.
909 Mar 2015 @ 02:11 PDTDatabaseReplyDefining two derived tables using WITH clause ??Thanks Dieter.  Could you please tell me how I can use this with Update statement? Regards, Ashish
805 Mar 2015 @ 01:57 PSTDatabaseReplyDefining two derived tables using WITH clause ??Hi All, I am getting below syntax erro while using with clause. Missing/Invalid SQL statement'E(3707):Syntax error, expected something like an 'END' keyword between ';' and ...
706 Feb 2015 @ 01:56 PSTToolsReplyTPT DataConnector Error : Delimited Data Parsing error: Input record exceeds allocated storageYes. Loaded the data successfully. May be I missunderstood the concept of deferred by name earlier. But creating such files from SQL Server is still concern though. Thanks Steven for your prompt r...
605 Feb 2015 @ 09:24 PSTToolsReplyError: "specified DSN contains architecture mismatch"It is because 32bit ODBC drivers dealing with 64bit TD tools and utilities. Most of the times while installing TTU it sets the 64-bit TTU directory path along with 32-bit TTU in "PATH" en...
504 Feb 2015 @ 11:15 PSTToolsTopicTPT DataConnector Error : Delimited Data Parsing error: Input record exceeds allocated storage TPT DataConnector producer error : "Delimited Data Parsing error: Input record exceeds allocated storage" Hello, I am using TPT Data connector producer and sql inserter operator to ...
402 Feb 2015 @ 12:35 PSTToolsReplyunable to varchar(max) / nvarchar(max) data from sql server to Teradata using TPTHi Steven, Thanks for the response. Is there any other way I can load column from sql server to teradata that exceeds 64000 bytes?
328 Jan 2015 @ 01:09 PSTToolsTopicunable to varchar(max) / nvarchar(max) data from sql server to Teradata using TPTHi All,   I am loading varchar(max) / nvarchar(max) data from sql server to Teradata using TPT and data direct drivers. The trimmed length of varchar(max) column is 5356651. I am unable to l...
228 Jan 2014 @ 05:04 PSTToolsTopic TPT12106: Cannot restart !!! Please resubmit the job.Hi, I am trying to populate my load table form Oracle (source) using TPT. My TPT job is failing due to "TPT12106: Cannot restart !!! Please resubmit the job" and getting completed after ...
109 May 2013 @ 03:15 PDTDatabaseTopicTHow to terminate teradata stored procedure..?Hi, I want to use this in Teradata Store procedure... If flag = 1 then goto LABEL_EXIT Else goto LABEL_OKAY END if flag is variable declared. I want to terminate my procedure if flag = 1... T...