Show pageOld revisionsBacklinksExport to PDFFold/unfold allBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== pears.rejectstate ====== <WRAP center round info> Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. </WRAP> ===== Original SQL ===== <code sql> create function "pears"."rejectstate"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ in "sstatuscode" char(1) ) returns char(1) begin declare "rejcode" char(1); select "rejectstatus" into "rejcode" from "status" where "status" = "sstatuscode" and "type" = 'R'; if "isnull"("rejcode",'') = '' then set "rejcode" = 'Y' end if; return("rejcode") end </code> database/functions/pears_rejectstate.txt Last modified: 2026/08/07 19:24by 127.0.0.1
127.0.0.1