pears.FormatPersonAddress
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."FormatPersonAddress" IS {CREATE FUNCTION FormatPersonAddress /* Application Maintained Function / Procedure - DO NOT EDIT*/ (IN ReqPersonID CHAR(20),IN Capitalise SMALLINT,IN STYLE CHAR(1)) RETURNS long VARCHAR BEGIN DECLARE FormattedAddress CHAR(300); SET FormattedAddress=FormatPersonAddress1_0(ReqPersonID,Capitalise,STYLE); RETURN FormattedAddress END }