====== pears.tempdepttran ======
<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"."tempdepttran"( in "deptu" char(1) ) 
returns char(20)
begin
  declare "rv" char(20);
  case "deptu"
  when 'D' then set "rv" = 'TCT'
  when 'G' then set "rv" = 'TDR'
  when 'I' then set "rv" = 'TNP'
  when 'Z' then set "rv" = 'TLS'
  else
    set "rv" = 'TIZ'
  end case;
  return("rv")
end
</code>