title: Can not call a user defined function with CHAR parameter on DB2 for i
body: <p>I create a function in DB2 (Version 6.01) this way:</p>
  
  <pre><code>CREATE FUNCTION myschema.test_c_c(param CHAR(1)) RETURNS CHAR(1) RETURN param;
  </code></pre>
  
  <p>and get a succses message and "System i Navigator" show me that function under myschema. But when I try to call this function this way:</p>
  
  <pre><code>SELECT myschema.test_c_c('X') FROM SYSIBM.SYSDUMMY1;
  </code></pre>
  
  <p>I get following message:</p>
  
  <pre><code>[SQL0204] TEST_C_C der Art *N in myschema nicht gefunden. 
  [SQL State=42704, DB Errorcode=-204] 
  </code></pre>
  
  <p>"nicht gefunden" equals to "not found".</p>
  
  <p><strong>Explanation of error code -204</strong> (part of it, <a href="http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z9.doc.codes/src/tpc/n204.htm" rel="nofollow">full error code Description here</a>)</p>
  
  <p>"The object identified by name is not defined in the DB2® subsystem."</p>
  
  <p>And at last, with INT parameter all works fine:</p>
  
  <pre><code>CREATE FUNCTION myschema.test_i_ri(param INT) RETURNS INT RETURN param;
  SELECT myschema.test_i_ri(4711) FROM SYSIBM.SYSDUMMY1;
  CREATE FUNCTION myschema.test_ii_ri(param1 INT, param2 INT) RETURNS INT RETURN param1 +param2;
  SELECT myschema.test_ii_ri(800, 15) FROM SYSIBM.SYSDUMMY1;
  </code></pre>
  
  <p>Where I miss the point?</p>
  
  <p>I execute all statmentens with <a href="http://www.sql-workbench.net/" rel="nofollow">SQL Workbench/J</a> (which I find very usefull)</p>