attribute := expression : ONCE ;

The ONCE service allows you to specify that the code is to be executed only once at query load time.

This means a Roxie query will execute it only once even if the query is executed multiple times. For a Thor or hThor query, ONCE behaves the same as INDEPENDENT.

Example:

InlineDCT := DICTIONARY([{0 => 'Black' , 'Greys'},
                         {1 => 'Brown' , 'Earth'},
                         {2 => 'Red'   , 'Reds'},
                         {3 => 'White' , 'Greys'} ], 
                        {UNSIGNED code => STRING10 color ,STRING10 Tone}) : ONCE;

UNSIGNED v := 0 : STORED('v');
OUTPUT(InlineDCT[v].color);

See Also: INDEPENDENT