By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Create UDT resulted SQL0107N exception

P: n/a
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?

Jan 29 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Jan 29 '07 #2

P: n/a


On Jan 29, 12:50 pm, evie...@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 is xchema name. You can explicitly specify it. It is not
necessary to CREATE SCHEMA beforehand.
Ex:
CREATE TYPE MyType.MyStructure AS ...

Jan 29 '07 #3

P: n/a
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
Jan 29 '07 #4

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

Jan 30 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.