SPOOL SPACE ISUUE WHILE RUNNING A BTEQ

In one my process bteq is failing due to "NO MORE SPOOL SPACE to user”. when i executed it from SQL assitant the select query used in bteq is working fine and returning rows but when the same query is used with insert statement is giving “NO MORE SPOOL SPACE to user”.