Not able to create CA 2E SQL file

Products

• CA 2E

Issue/Introduction

Trying to create SQL file and not able to create. Attempting to create an SQL instead of a DDS type file in 2E.This is the first attempt to generate an SQL file. 

Created a new file in the 2E relations and changed the settings to S-SQL instead of the default D-DDS.  Submitted it for generation (option J in front of the Physical, Retrieval and Update index) the source generation finishes normally however the status remain as *JOBQ.  No error logs are created in the spool file and no file is created in the GEN library.

Are there are additional settings that need to change?  

Environment

CA 2E 8.7 and higher

Resolution

Make sure there is a valid SQL library by checking

DSPDTAARA DTAARA(YSQLLIBRFA)

This should be a valid library created by YCRTSQLLIB. If it shows *NONE,  you won't be able to use SQL file. This SQL library should then be in the model's library list, and the batch JOBD library list as well. 

Additional Information

YCRTSQLLIB (Create SQL Library) Command