#DateForumTypeThreadPost
701 Aug 2006 @ 10:47 PDTDatabaseTopicSpool Space IssuesI am getting Spool space error when this query run in PROD. Any optimization tips welcome. I have put the records in Millions and Indexes on comments.INSERT INTO extrt_ent_drcty_data_3_gt(28 Cols)S...
614 Jul 2006 @ 02:32 PDTToolsTopicMload on global temporary tablesHow can we do an mload on gloabal temporary tables? Will the data last only through the mload session or the parent session?
513 Jun 2006 @ 09:08 PDTDatabaseTopicConditional Duplicatesdeleted
423 Jan 2006 @ 11:31 PSTUDAReplySQL to update a column using another columnthis is my original insert statement it updates LP_Qty with the RF_Qty everyday now.DELETE FROM RTL_DEV_DATA.RPLNSHMNT_FORECAST ALL;INSERT INTO RTL_DEV_DATA.RPLNSHMNT_FORECASTSEL it.Item_ID, ...
321 Jan 2006 @ 03:41 PSTToolsTopicFastload QuestionI need to export flat files out of Oracle and Fastload it into Teradata.,Let's take an example A table has say 5 fields and these are integers & datesI am sending them in this format6305,1451,2400,...
221 Jan 2006 @ 01:11 PSTUDAReplySQL to update a column using another columnThanks Jason for your reply. My ETL process deletes all data from the target table everyday and reloads it with fresh data. It's a DSS. I need to do the update with previous day's value if the cond...
120 Jan 2006 @ 02:24 PSTUDATopicSQL to update a column using another columnI need the logic/ansi sql to update a column, LP_Qty in my table using another col in the same table this is RF_Qty. RF_Qty gets updated everyday as the table refreshes everyday. But LP_Qty should ...