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.
Instead, create a temporary table/s to store interim results.
No comments:
Post a Comment