SQL - blanks CALENDAR_ID in CA7_SCHEDULE

Products

• CA 7 Workload Automation

Issue/Introduction

We have 588 entries/records in our CA7_SCHEDULE table.

However, there're only 23 out of 588 records with the value of CC portion of the SCALYYCC calendar.

May I learn why most of records in our CA7_SCHEDUL have blanks CALENDAR_ID?

When will the CC portion of SCALYYCC be saved on the field CALENDAR_ID in CA7_SCHEDULE?

Environment

Release 12.0 and 12.1

Cause

Coding SQL Rules

Resolution

The following rule can be coded.  In the output, the DEFAULT_CALID is taken from the DB.2.1 panel for the Default Calendar.  The overriding CALENDAR_ID is populated with the overriding calendar from the DB.2.1-E panel.

SELECT SUBSTR(OBJECT_NAME,1,8) AS JOB,      
SCAL_ID AS DEFAULT_CALID, SCHID, CALENDAR_ID
FROM CA7_SCHEDULE S, CA7_JOB J              
WHERE S.DB= 'yourlogicaldatabasename'                      
AND   J.DB= S.DB                            
AND   J.JOB = S.OBJECT_NAME ;