Sunday, 16 September 2018

CTE - Database File system full

CTE makes the code more readable but it uses the file system to store the temporary results and thus may cause "SQL0968C file system is full. SQLSTATE=57011" error.
Instead, create a temporary table/s to store interim results.