#DateForumTypeThreadPost
418 Aug 2015 @ 04:01 PDTDatabaseTopicPRIMARY INDEX ON VOLATILE Tables cause SPOOL SPACE ERRORSI have found that when I create a volatile table with say 200million rows where the primary index is explicitely stated and matches the first column in the table, I use much more spool space t...
315 Aug 2013 @ 09:16 PDTToolsReplyBTEQ - want to Generate a record number based on order of rows inserted that is sequentialHey did it as a column in the table and it worked great! Thanks.  Some sources populate the file record number field and some don't...so I use the identity column and then after the load c...
215 Aug 2013 @ 08:28 PDTToolsReplyBTEQ - want to Generate a record number based on order of rows inserted that is sequentialDo you have an example of how to code that....are you saying define a column as identity in the defines section of the script for the insert or put an IDENTITY column on the table?
114 Aug 2013 @ 03:07 PDTToolsTopicBTEQ - want to Generate a record number based on order of rows inserted that is sequentialI am trying to load a very wide file into a Teradata table using BTEQ and unfortunately the records do not have a unique identifier other than record number which is implied by their location in th...