how to use LENGTH function on a UDT/DISTINCT type

GANAPATH · New User Joined: 06 Mar 2006 Posts: 35

Hi,

I have a UDT(user defined datatype) column which is of LOB type, and iam unable to use 'LENGTH' function on this Column.

The same thing if i don't declare it as a UDT but as a regular LOB column, i can use LENGTH function on that column, can anyone tell me how i can use 'Lenght' function on a UDT.

select length(lobcol1) from table ;

this shows me results but if i use

select length(udtlobcol1) from table ;<- this gives me

DSNT408I SQLCODE = -440, ERROR: NO FUNCTION BY THE NAME LENGTH HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH

Thanks,
Ganapath

William Thompson · Posted: Tue Feb 06, 2007 2:58 am

Call me confused

DB2, right?
UDT as in User Defined Tatatype?
DSNT408I as in "DSNT408I SQLCODE = -xxx, explanation"?
-440 as in " -440 THE NUMBER OF PARAMETERS IN THE PARAMETER LIST DOES NOT MATCH THE NUMBER OF PARAMETERS EXPECTED FOR STORED PROCEDURE name, AUTHID authid, LUNAME luname. number PARAMETERS WERE EXPECTED."?
Obviously I'm missing something, where is the UDT documented, please?

The closest I could find were user defined table functions.....

GANAPATH · New User Joined: 06 Mar 2006 Posts: 35

Hi,

User defined data types are also referred to as Distinct types

u can read the information in the below link.
publibfp.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnsqj10/5.24?ACTION=MATCHES&REQUEST=user+defined+data+type&TYPE=FUZZY&SHELF=&DT=20040216135741&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

or u can see SQL reference Guide v8 under STATEMENTS,DISTINCT TYPES

Thanks,
Ganapath

William Thompson · Posted: Tue Feb 06, 2007 3:55 am

Thanks for the url, down towards the bottom of that page (I think) was this