DSPFD – Asking for some explainin about a field in DSPFD output

165 pts.
AS/400 Records
Would you kind to explain me what reflects the field "Rejected records by key selection" ?, What could be the reason for rejecting a record in a I/O operation. Thanks.

Answer Wiki

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

Please explain your question.


People, thanks for so quickly response. I’m trying to get some information about the i/o charge on the system during online an during batch time. Executing DSPFD on the files of several libraries I remarked that one file contains statictis of billions of records rejected by key selection. (I beg yor pardon if the field’s name does not match exactly I’m translating from Espanish). The file contains only 2.5 million of registers of 26 bytes length.

That’s the reason I want to know what kind of action makes that field by filled. Sorry for my bad English.

Here’s a site

It’s not at all clear to me why keyed input requests should look at records and reject them — dynamic select? Selects/Omits, or just the way the system uses it’s indexs. I think this is a new statistic 6.1??? and I’m surprised that I don’t find an explanation on line. I would think that lowering this number would be good — but how? And why did they collect this info if it wouldn’t help us tune the database?

Could it be from SQL Joins?

Heck, I’ve found explanations on-line for everything else, alien spaceships, Elvis.


I checked the link and read that explanation. Then I remaked it would happens because the programs are made by Genexus which generates RPG source y compiles that. In Genexus the programmers use the keyword WHEN and join the fields of several files not considering the size of them, so, the reading for compare the conditions in the WHEN, occurs in a parallel way (taking a lot of time) instead of generating a vector with the little file, or separating the reading in several when. Thanks a lot.

Discuss This Question: 1  Reply

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.
  • Gilly400
    Hi, Possibly a SELECT/OMIT on a logical file? Just a guess... Regards, Martin Gilbert.
    23,730 pointsBadges:

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.

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


Share this item with your network: