Skip to main content


persistent class Sample.USZipCode extends %Library.Persistent, %XML.Adaptor

SQL Table Name: Sample.USZipCode

This class represents a U.S. ZIP (Zone Improvement Plan) Code and corresponding State and City name. The sample dataset includes values for the northeastern United States.

Property Inventory


property City as %String (MAXLEN = 50) [ Required ];
A city name.
Property methods: CityDisplayToLogical(), CityGet(), CityGetStored(), CityIsValid(), CityLogicalToDisplay(), CityLogicalToOdbc(), CityNormalize(), CitySet()
property Latitude as %Numeric (SCALE = 6);
Property methods: LatitudeDisplayToLogical(), LatitudeGet(), LatitudeGetStored(), LatitudeIsValid(), LatitudeLogicalToDisplay(), LatitudeNormalize(), LatitudeSet(), LatitudeXSDToLogical()
property Longitude as %Numeric (SCALE = 6);
Property methods: LongitudeDisplayToLogical(), LongitudeGet(), LongitudeGetStored(), LongitudeIsValid(), LongitudeLogicalToDisplay(), LongitudeNormalize(), LongitudeSet(), LongitudeXSDToLogical()
property State as %String (MAXLEN = 2) [ Required ];
A 2 letter state abbreviation.
Property methods: StateDisplayToLogical(), StateGet(), StateGetStored(), StateIsValid(), StateLogicalToDisplay(), StateLogicalToOdbc(), StateNormalize(), StateSet()
property ZipCode as %String (MAXLEN = 5) [ Required ];
The 5-digit ZIP Code value.
Property methods: ZipCodeDisplayToLogical(), ZipCodeGet(), ZipCodeGetStored(), ZipCodeIsValid(), ZipCodeLogicalToDisplay(), ZipCodeLogicalToOdbc(), ZipCodeNormalize(), ZipCodeSet()


index (ZipIDX on ZipCode) [IdKey, Type = key];
This index specifies that objects are identified by the ZipCode property.
Index methods: ZipIDXCheck(), ZipIDXDelete(), ZipIDXExists(), ZipIDXOpen(), ZipIDXSQLCheckUnique(), ZipIDXSQLExists(), ZipIDXSQLFindPKeyByConstraint(), ZipIDXSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods


Storage Model: CacheStorage (Sample.USZipCode)

FeedbackOpens in a new tab