Not able to create CA 2E SQL file
search cancel

Not able to create CA 2E SQL file

book

Article ID: 130497

calendar_today

Updated On: 07-01-2025

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