#DateForumTypeThreadPost
1924 Jan 2015 @ 06:28 PSTDatabaseReplyNeed help in tuning a Queryyou might need to break this down from a single statement into multiple statements. for the first sql in the union, you might try breaking it down and aggregating by quarters (3 months of data) th...
1802 Dec 2014 @ 10:32 PSTDatabaseReplyIdentify error record in case of VT insert statement failure back in TD 12.0 Teradata introduced SQL Bulk loading error tables.  You can probably look at using that to identify the issue.  They work much like the error tables found with the utiliti...
1702 Oct 2014 @ 08:23 PDTDatabaseReplyHow to concatenate a date in three different columns?'''' || trim(year) || '-' || trim(cast(month as integer format '99')) || '-' || trim(cast(day as integer format '99')) || ''''  ...
1625 Sep 2014 @ 08:03 PDTPrivate Forum
1526 Feb 2014 @ 08:35 PSTViewpointReplyOne User Multiple LogonsJoe,   what exactly are you trying to do?  Are you wanting to setup a generic id and let all your users use it to log into Viewpoint?  If so, then no that won't work.  As ...
1410 Mar 2013 @ 03:12 PDTPrivate Forum
1310 Mar 2013 @ 02:56 PDTPrivate Forum
1210 Mar 2013 @ 02:55 PDTPrivate Forum
1114 Feb 2013 @ 07:31 PSTPrivate Forum
1011 Feb 2013 @ 02:10 PSTPrivate Forum
908 Feb 2013 @ 08:53 PSTPrivate Forum
818 Dec 2012 @ 12:45 PSTExtensibilityReplyXML Services on Express 14.0 -- trouble in installI'm finding installing the XML Services on the 14.0 Express to be extremely painful...much like you the fact that the 13.10 XML Services doesn't appear to be setup to run against anything p...
717 Dec 2012 @ 01:12 PSTToolsReplyExamples of writing prepared statements in CLIv2Thanks Tom, will have the developer look at that sample as well as start exploring the feasbility to switch to ODBC.
607 Dec 2012 @ 10:14 PSTToolsReplyExamples of writing prepared statements in CLIv2Tom, They are using a C++ program which currently uses the Sybase CLI and they want to switch it out for Teradata CLI.  We don't have an the option to use ODBC in this case.  If...
505 Dec 2012 @ 08:59 PSTToolsTopicExamples of writing prepared statements in CLIv2We have a development group wanting to convert a C++ program that uses CLI for sybase to using Teradata's CLIv2.  One of things we are having problems finding information on is how to cons...
405 Nov 2012 @ 11:41 PSTGeneralReplyQuestion about using Queryband in a macro called from a JAVA programafter hacking around with the example code, I was able to figure out the issue.  The set query_band doesn't actually return any thing to resultset.  we were checking for something whe...
303 Nov 2012 @ 05:22 PDTGeneralTopicQuestion about using Queryband in a macro called from a JAVA programWe are in the process of moving most of our applications use Querybanding and one of the ways we are doing this is by implementing the queryband as part of a macro this way we can ensure the query ...
215 Feb 2012 @ 11:55 PSTPrivate Forum
108 Feb 2012 @ 02:47 PSTCloud ComputingTopicTrouble importing TSET from production into TD13.00 Express Has anyone run into the following issue trying to import a TSET from a production TD13.00 system into the TD 13.00 Exporess. This error occurs when trying to import the statistics. ERROR...

Pages