Environment Variables - Index (building, lookups, Browse)

 

PFBIXBLANK=OFF|ON

Controls how filePro treats a null lookup key.

ON=4.1 way, where null=all blanks

OFF=4.5 way, where null key=lowest possible value.

Default is "ON"

Version Ref: 4.8

 

PFBIXBUILD=2

 

Tells dxmaint to use 4.1 style sorting during build whenever possible. Use this on HUGE files to improve performance - on

smaller files it will actually harm performance. (dxmaint)

Version Ref: 4.8

 

PFBIXNODESIZE=nnn

Will have dxmaint build indexes with a nodesize of nK bytes (1 <= n <= 63) rather than the default value calculated by filePro. (dxmaint)

Version Ref: 4.8

PFBRWM=ON

Strip trailing blanks from browse lookup. (*clerk)

Version Ref: 4.5

PFDDEFXMAINT

 

Set PFDDEFXMAINT to OFF to revert to the old 4.1 index routine in ddefine

 

Version Ref: 5.8.03

 

PFF6PROMPT=OLD

(4.8.5K2) PFF6PROMPT=OLD will put back the old behavior of ignoring @WBL processing in determining which F6 prompt to display. (*clerk)

Version Ref: 4.8

PFIXGT=ON

This will allow *clerk to do a next-greater-than if no exact match is found when selecting through Index Selection. (*clerk)

Version Ref: 4.8

PFIXS=ON | OFF

Turns on or off "Index Scan" feature. (*clerk, *report)

Version Ref: 3.0

PFKEEPIXVAL=OFF

PFKEEPIXVAL=OFF causes dclerk to clear the index key prompt. Default of ON keeps the previous value entered. (*clerk)

Version Ref: 4.5.8

PFLKNL=NEW

Lookup "-nl" finds the last matching record instead of the first. (*clerk, *report)

Version Ref: 4.5

PFMAXALLOC=nnn

Maximum # of sort buffers allocated when re-building demand indexes (automatic indexes pre 4.5). Default is "16". (dxmaint)

Version Ref: 4.5

Version Ref: 5.8.01 the default was raised to 128

PFMAXASIZE=nnn

Sort buffer size when building demand indexes, (automatic indexes pre 4.5) (dxmaint)

Version Ref: 4.5

Version Ref: 5.8.01 the default was raised to 128,000

PFMAXTEMP=nnnn

Maximum virtual memory size when sorting. Demand indexes (auto pre 4.5) Default "1000". (dxmaint)

Version Ref: 4.5

PFMAXTFIL=nnn

Maximum virtual memory files used for sorting. Demand indexes (automatic pre 4.5) (dxmaint)

Version Ref: 4.5

PFNOIXHIDE=ON

Disables Index Hiding (All indexes are shown including hidden indexes).

Version Ref: 5.0

PFNUMIXBUF=nnn

Sets the number of index blocks to buffer in memory for 4.5-style indexes. (Index blocks are usually 1K each.) Default is 10.

Version Ref: 4.5

PFNUMIXBUILD=nnn

Same as PFNUMIXBUF, but for dxmaint only. Default is200. Maximum is 32767.

Version Ref: 4.5

PFOLDIX=ON

Builds old style (4.1) indexes. (*clerk, *report, dxmaint)

Version Ref: 4.5