× 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.



Unexpectedly getting CPF4028:

Member REVDETL file REVDETL in library ARISDATA was opened with the
SEQONLY(*YES) parameter specified in the program or on the Override
Database File (OVRDBF) command. However, the parameter has been changed to
SEQONLY(*NO) because of condition 1 shown below:

1 - The program opened member REVDETL for output operations only and
SEQONLY(*YES) was specified with the default number of records. SEQONLY(*YES)
was changed to SEQONLY(*NO) to allow the program to handle duplicate key,
conversion mapping, key mapping, and select or omit errors, or both select
and omit errors at the time of the output operation.


There are no unique keys defined on the physical, nor on any logicals.
There is a join-logical file. There are no select/omit specs in the DDS.


There are two views on the physical. Both views are joins. One does
several concatenations of substrings, a few SUM functions, a few CASE
structures(?). I'd paste the CREATE VIEW statement from DSPFD, but it's a
300-line hot mess of a badly formatted statement.


AFAICT, there is no conversion mapping nor key mapping, but I'm not really
sure how to tell.


Ideas?


- Dan

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.