what is SEQONLY(*YES) property

20 pts.
Tags:
AS/400 programming
RPGLE
[strong]Hi,                                                                                                                                       i have a problem with my program which was running successfully on the previous days. Every time I try to run the program the job fails. [/strong]

[strong]The error in spool files is as shown below Message . . . . : Open of member DTICARRX was changed to SEQONLY(*NO). [/strong]

[strong]Cause . . . . . : Member DTICARRX file DTICARRX in library MISAM 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: [/strong]

[strong]1 - The program opened member DTICARRX 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. what is the significance of SEQONLY(*NO).?[/strong]

[strong] if anybody has met with the situation before , please help me. this is very critical.                                                                                                   [/strong]

[strong]Thanks ,[/strong]

[strong]Sreeraj[/strong]



Software/Hardware used:
As400,RPGLE
ASKED: September 24, 2009  11:32 AM
UPDATED: September 24, 2009  1:51 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

SEQONLY(*YES) is usually used when reading a large file and using ablocing factor. The machine will read a large block of records and transfer them to you PAG instead of a record at a time.
The system will automatically change the specication from *YES to *NO if it believes it will be more efficient in it’s processing.. This does not cause a program to crash.
My guess is that you have problems with your data.
Are you trying to write to a file?
Does it have a unique key?

———– CharlieBrown is right, as always.
This shuld be a informational or warning message 00 or 10 level.
and shouldn’t normally stop the processing.

To eliminate this usually harmless message
I suspect that you have an ‘F’ spec for this file

FMyFile O E DISK

I don’t think you can add the key like this
FMyFile O E K DISK

But you could definitely code it like this
FMyFile IF A E K DISK

——————-
Of course you need to determine what’s really causing the crash.
Phil

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following