I'm creating an SQL table and it compiles fine, but in the spool file I have a level 30 error. Is this an actual problem, or can I procede?
SQL0204 30 36 Position 3 ETBRAN in JKENDZIERS type *FILE not found.
Create Table RENOFRCTL
(BRANCH for column ROCTBRAN char(02) not null,
CARRIER for column ROCTCARR char(02) not null,
PROGRAM for column ROCTPROG char(02) not null,
STATE for column ROCTSTATE char(02) not null,
EFFECTIVE_DATE for column ROCTEFFDT dec(08, 0) not null,
RNWL_OFF_FIRST for column ROCTFIRST dec(03, 0) not null,
AMEND_END_MAIL for column ROCTEND dec(03, 0) not null,
SHT_PYMT_THRSH for column ROCTSHORT dec(05, 2) not null,
Primary Key (ROCTBRAN,
ROCTCARR,
ROCTPROG,
ROCTSTATE,
ROCTEFFDT));
Label on ROCTBRAN (BRANCH Text is 'BRANCH');
Label on ROCTCARR (CARRIER Text is 'CARRIER');
Label on ROCTPROG (PROGRAM Text is 'PROGRAM');
Label on ROCTSTATE (STATE Text is 'STATE');
Label on ROCTEFFDT (EFFECTIVE_DATE Text is 'EFFECTIVE DATE');
Label on ROCTFIRST (RNWL_OFF_FIRST Text is 'RENEWAL OFFER FIRST');
Label on ROCTEND (AMEND_OFF_MAIL Text is 'AMENDED OFFER DAYS');
Label on ROCTSHORT (SHT_PYMT_THRSH Text is 'SHORT PYMT THRESHOLD');
Label on Table RENOFRCTL is 'Renewal Offer Control';