Run sql statement make file system full ?

From: Ken Man <ken_at_ifshk.com>
Date: Fri, 23 Aug 2002 16:18:37 +0800
Message-ID: <ak4r3e$pe$1@news.hk.linkage.net>

I have a SQL statement like follows:

        Select field1, field2......field50 from table1, table2 where XXXXXX

        UNION         Select field1, field2......field50 from table1, table2 where YYYYYYY Then, I got an error message: SQL0968C The file system is full. SQLSTATE=57011 I have make some test: 1. When I just one the 1st select statement without 'Union', it is quite fast and get 66 records.

                                   2.  When I just one the 2nd select

statement without 'Union', it is quite fast and get 3 records.

                                   3. After I replace the 'Union' by 'Union

All', It is fast to get total 69 records without error.

Do anyone can tell me what happen? Thank you very much!

Best Regards,

Ken Received on Fri Aug 23 2002 - 03:18:37 CDT