WebFOCUS Techniques

Retrieve Only Current Address Records from the SPRADDR Table

The SPRADDR table contains a field that controls the currency of the address record: SPRADDR_STATUS_IND. If the SPRADDR_STATUS_IND contains a null value the address is the current one for that address type. The WebFocus test for a null value is the IS MISSING condition. In order to obtain only the current address record from SPRADDR you must include the following WHERE statement:

WHERE SPRADDR_STATUS_IND IS MISSING

MCIS Documentation and Information page at Miami University