Re: Causes of Tablespace Overflow

In article <439odn$fg0@cssun.mathcs.emory.edu> ckipp@vth1.vth.colostate.edu "Cathy Kipp" writes: > Folks, > > I have an IBM RS6000 model 59H running OnLine 7.10.UC2 with applications > written in compiled 4gl 6.01.UD2 > > Recently, I have had occasion to create a new report which is simply a set > of account statements. All of the account statements are created correctly, > except one (admittedly a rather large one... but I have much more complex > and long reports which work), which always bombs with the message: > > Program stopped at "otrasumlar.4gl", line number 115. > SQL statement error number -567. > Cannot write sorted rows. > SYSTEM error number -141. > ISAM error: TBLspace table overflow <snip> My guess is that this particular SQL statement is attempting to create lots of temporary tables & it's hit the limits. Has Cathy checked out the SQL statement with 'set explain on' to see if temporary tables are being used? -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================