I am not familiar with journals so I not sure what CR means, but one thing that comes to mind is to make sure your library list and overides are correct, and if possible qualify your table name in your SQL statement.
Also, it’s not clear but is the SQL statement clearing the Qtemp File as well? If not maybe your SQL is referencing the wrong library and clearing the wrong file. I ahve some issues using SQL with library lists and overides, so I now I always remove overides and Qualify my SQL whenever possible.
From the V5R4 Info Center: DELETE Performance: An SQL DELETE statement that does not contain a WHERE clause will delete all rows of a table. In this case, the rows may be deleted using either a clear operation (if not running under commitment control) or a change file operation (if running under commitment control).
IIRC, the behavior to use a clear operation was introduced in V5R3.
A CLRPFM may be substituted in place of a series of DELETEs.
As for what’s happening in your case, more info is needed.