OVRDBF Problem

[laxminarasimha]

Iam having a file with record length > 32767. I have given an override for that file with SHARE option *yes. But when i try to select a particular range of records with OPNQRYF iam getting the following error.

Message . . . . : Open of member MYFILE was changed to SEQONLY(*NO).

Cause . . . . . : Member MYFILE file MYFILE in library MYLIB 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 4 shown below:


4 - The record length plus the feedback information for the member is
greater than 32,767 bytes.

How to overcome this?

Laxminarasimha

[DeadManWalks]

Re: OVRDBF Problem

If you do not need all the fields in the file you could create a Logical file or an SQL index OR just use SQL instead of the old shcool onpqryf.