#DateForumTypeThreadPost
1122 Oct 2014 @ 12:11 PDTDatabaseTopicOut of spool space on diskI have a situation on a productions system where our production jobs are failing with the 'Out of spool space on disk' error since yesterday. This process has been running for over a year a...
1005 Nov 2012 @ 04:51 PSTExtensibilityReplyUnable to import Geo Data with TDGeoImportWe're facing this exact same situation - it's TD13.1, I'm able to create tables with geospatial data types and run SQLs with geospatial functions, but the import fails with the same rea...
917 Jun 2012 @ 03:12 PDTDatabaseReplyTeradata IN List allowable limit While handling a fairly different problem, we had used our reporting tool to read the users inputs and call a Teradata macro, the macro read the full input list and placed it into a volatile tab...
817 Jun 2012 @ 03:08 PDTGeneralReplyDaisy Chain Logic -Tuning Too late to respond I guess, but the solution to this will involve a recursive query - that way you can execute only 1 sql but it will loop through X number of times and repeat the same function...
716 Jun 2012 @ 04:26 PDTDatabaseReplyNeed help in tuning a query It is evident from the plan that the query is unable to use the PI of the table and is pulling out the entire table into spool which is global, meaning the data will first be pulled out into a s...
629 Sep 2010 @ 01:02 PDTDatabaseTopicInputs needed to determine primary indexHi All, I am a beginner on Teradata and am involved in an exploration to figure out what it would take to migrate an existing system based on Informatica PC+Oracle to Informatica PC+Teradata. I ...
523 Feb 2010 @ 11:35 PSTDatabaseReplyStored Procedures in Teradata!!Stored procedures cannot be called within a query, it is more like a parameterized script that you call and is executed independently. These procedures can include DDL as well as DML statements and...
419 Feb 2010 @ 07:55 PSTToolsReplyMload failureSteve,Thanks for your inputs, turns out the DBA had not deleted some of the error tables which led to this failure. Sorry for the incorrect reference to Mload, our systems were recently migrated fr...
318 Feb 2010 @ 02:59 PSTToolsTopicMload failureAll,I'm facing an issue with mloading of a table via Informatica - I get a "Broken Pipe" error which I believe is a very common error. I tried the usual steps of releasing the mload lock and deleti...
218 Feb 2010 @ 02:06 PSTDatabaseReplyInteger to Bigint datatype conversionThanks for the confirmation Jim.
118 Feb 2010 @ 12:12 PSTDatabaseTopicInteger to Bigint datatype conversionIs there any alter table (or any other sql) command that can be used to alter the datatype of a integer column to bigint? I have a bunch of tables in a shared environment all of which have data and...