× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



All:

We are having an issue with our SQL files. If I use Implementor, or the
STRSQL green screen entry, I get the same issue.

I get a run time dump of SQLCA, and diagnostic area,

On my compile listing, I get an error message SQL0901 - Record 1,
Position 1 SQL system error.

In the joblog it lists:

CPD32B0 Diagnostic - 20 - Constraint is not valid. Constraint *N cannot
be added for file xxxxx in library xxxx for TYPE value *PRIKEY.
The reason code is 7 - System Cross Reference files are damaged.

If I take the keys out of the file, it compiles just fine. I have been
deleting the existing file before recreating the new one if it existed.

Does anyone know what file might be damaged? Has anyone else hit this
before?

The file compiled fine yesterday, but this morning we are getting these
issues. There have been no system updates since yesterday.

We're working with IBM, but it seems like this is taking them WAY too
long to get any answers.

Here's the source:
----------------------
Create Table TXQTRRPT
(RPT_FROMDATE for column FROMDATE DATE not null,
RPT_TODATE for column TODATE DATE not null,
RPT_CNFRDATE for column CNFRDATE DATE not null,
RPT_CNTODATE for column CNTODATE DATE not null,
RPT_VOLCNT for column VOLCNT DEC(09, 3) not null,
RPT_VOLAMT for column VOLAMT DEC(11, 2) not null,
RPT_PDCNT for column PDCNT DEC(09, 3) not null,
RPT_PDAMT for column PDAMT DEC(11, 2) not null,
RPT_PRCFLAG for column PRCFLAG CHAR(01) not null,
RPT_SBMDATE for column SBMDATE DATE not null,
RPT_SBMUSER for column SBMUSER CHAR(10) not null,
RPT_SBMTIME for column SBMTIME TIME not null,
RPT_SBMJOB for column SBMJOB CHAR(10) not null,
RPT_SBMJOBNO for column SBMJOBNO CHAR(06) not null,

Primary Key (FROMDATE, TODATE));

Label on TXQTRRPT (FROMDATE Text is 'FROM DATE');
Label on TXQTRRPT (TODATE Text is 'TO DATE');
Label on TXQTRRPT (CNFRDATE Text is 'CANCEL FROM DATE');
Label on TXQTRRPT (CNTODATE Text is 'CANCEL TO DATE');
Label on TXQTRRPT (VOLCNT Text is 'VOLUNTARY COUNT');
Label on TXQTRRPT (VOLAMT Text is 'VOLUNTARY AMOUNT');
Label on TXQTRRPT (PDCNT Text is 'PD COUNT');
Label on TXQTRRPT (PDAMT Text is 'PD AMOUNT');
Label on TXQTRRPT (PRCFLAG Text is 'IN PROCESS FLAG');
Label on TXQTRRPT (SBMDATE Text is 'SUBMIT DATE');
Label on TXQTRRPT (SBMUSER Text is 'SUBMIT USER');
Label on TXQTRRPT (SBMTIME Text is 'SUBMIT TIME');
Label on TXQTRRPT (SBMJOB Text is 'SUBMIT JOB');
Label on TXQTRRPT (SBMJOBNO Text is 'SUBMIT JOB NUMBER');

Label on Table TXQTRRPT is 'TEXAS QUARTERLY REPORT FILE';

Thank you all for any assistance you can give!
-Brent Dunn



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.