Create UDT resulted SQL0107N exception

[eviewcs]

Hi , I am new to DB2. I would be glad if you can help me on this
following problem :
When i create a structured type , the following exception is thrown :
SQL0107N The name "ADMINISTRATOR" is too long. The maximum length is
"8".

But this exeption was not thrown when I create tables or UDF.
Do I have to create another user with name lesser than 9 letters in
order to create UDT?

[Serge Rielau]

ev*****@gmail.com wrote:

Hi , I am new to DB2. I would be glad if you can help me on this
following problem :
When i create a structured type , the following exception is thrown :
SQL0107N The name "ADMINISTRATOR" is too long. The maximum length is
"8".

But this exeption was not thrown when I create tables or UDF.
Do I have to create another user with name lesser than 9 letters in
order to create UDT?

That's true for older versions of DB2. Reason was in a limitation in
SQLDA's with structured types. Now what I do not know is whether that is
lifted in DB2 9.
It is in vnext which is what I just tested.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Tonkuma]

On Jan 29, 12:50 pm, [e-mail] wrote:

Hi , I am new to DB2. I would be glad if you can help me on this
following problem :
When i create a structured type , the following exception is thrown :
SQL0107N The name "ADMINISTRATOR" is too long. The maximum length is
"8".

But this exeption was not thrown when I create tables or UDF.
Do I have to create another user with name lesser than 9 letters in
order to create UDT?

That is xchema name. You can explicitly specify it. It is not
necessary to CREATE SCHEMA beforehand.
Ex:
CREATE TYPE MyType.MyStructure AS ...

[Knut Stolze]

Serge Rielau wrote:

ev*****@gmail.com wrote:

>Hi , I am new to DB2. I would be glad if you can help me on this
following problem :
When i create a structured type , the following exception is thrown :
SQL0107N The name "ADMINISTRATOR" is too long. The maximum length is
"8".

But this exeption was not thrown when I create tables or UDF.
Do I have to create another user with name lesser than 9 letters in
order to create UDT?

That's true for older versions of DB2. Reason was in a limitation in
SQLDA's with structured types. Now what I do not know is whether that is
lifted in DB2 9.
It is in vnext which is what I just tested.

Still the same in V8 and V9 (see Note in c or 2, respectively):
http://publib.boulder.ibm.com/infoce...n/r0001029.htm
http://publib.boulder.ibm.com/infoce...c/r0001029.htm

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

[eviewcs]

I am using db2 v9.1.
I am able to create UDT with a shorter length schema name.
Thanks for your information!