pears.AddressValidation
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
CREATE FUNCTION "pears"."AddressValidation"( IN @RecordType CHAR(1),IN @RecordID CHAR(20),IN @Addr1 CHAR(100),IN @Addr2 CHAR(100),IN @Addr3 CHAR(100),IN @Town CHAR(100),IN @County CHAR(100),IN @Country CHAR(100),IN @Postcode CHAR(100) ) RETURNS long VARCHAR -- Non-Maintained Function -- -- @RecordType P - Person, C - Company, V - Vacancy -- Success is indicated by the return of a null string, any other response indicates a problem. -- If the response starts with a caret (ie ^) the message should be treated as a warning rather than an error -- BEGIN DECLARE @RV long VARCHAR; RETURN(@RV) END