By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,778 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,778 IT Pros & Developers. It's quick & easy.

Create Table sql0204 error

P: 2
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';
Aug 31 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.