title: DB2 SQL array in attribute-defs of user defined type
body: <p>I have a question concerning user defined types in DB2(v. 9.7.0.441). I want to create a type which has an attribute-array of another user defined type. Let me show you what I mean by a brief (fictional) example:</p>
  
  <p>This is the UDT I want to use in another type</p>
  
  <pre><code>CREATE TYPE sport AS
  (
    Sport VARCHAR(10)
  ) MODE DB2SQL;
  </code></pre>
  
  <p>This is the UDT which should use the one above</p>
  
  <pre><code>CREATE TYPE person AS
  (
    plays sport ARRAY[3] // 'REF(sport)' or 'plays VARCHAR(10) ARRAY[3]' don't work either  
  ) MODE DB2SQL;
  </code></pre>
  
  <p>DB2 just says that the token ARRAY[3] is unexpected.</p>
  
  <p>Any hint what could be wrong here? By now it would be enough to have an CHAR Array in a UDT...</p>
  
  <p>Thanks in advance</p>