Re: %lookup on a Data Structure Array

[CRPence <CRPbottle@xxxxxxxxx>]

On 10-Nov-2011 10:50 , Raul A. Jager W. wrote:
> In the CHGPF command there is a parameter "KEPPINMEM" I have not
> yet tried it, but it sounds like it can solve your problem with
> very little effort.

  The effect of the parameter KEEPINMEM [apparently available since IBM 
i 7.1 though no change bars in the doc] appears specific to SQL query 
engine (SQE); even including a "Note:" for how the pool is identified 
separate from that feature.  SETOBJACC for database file member data and 
access path(s), or the set access state MI instruction for user domain 
objects, are what provide the ability to move object.data in memory.

_Change Physical File (CHGPF)_
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/cl/chgpf.htm
"Keep in memory (KEEPINMEM)

Specifies whether the data for a file member should be brought into a 
main storage pool by the SQL Query Engine (SQE) when the data is used in 
the query to improve the performance."

  The doc for the parameter values is poor and possibly misleading; 
false even, for *NO.  Though I do trust the effect of the parameter is 
specific to SQE, such that native I\O from RPG would see no effect.  I 
expect that whatever reason(s) SETOBJACC is not a preferred solution, 
presumably code path-length for database I\O versus other methods, would 
similarly discount the file attribute even if it were available.

Regards, Chuck