hi guys,

can u plz explain how does the below statement works.and also i want to know

what is that get_attri value. and how does it function inthe given statement.

select a,rtrim(ps.get_attri_value (32, s.no, 4964)) as md from ps.sales;

i want to run such a statement on db2V8.2 on solaris.


Thanks

there is a book/document called SQL reference, which you should have it handy:

The RTRIM function removes blanks or hexadecimal zeros from the end of a string expression. The RTRIM function returns the same results as the STRIP function with TRAILING specified: STRIP(string-expression,TRAILING)

GET_ATTRI_VALUE is a user-defined function that someone created in your database. It is not one of DB2's built-in functions.

p.s: STRIP is available in DB2 LUW V9 onwards and not in V8.