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?
CA 2E 8.7 and higher
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.