Results 1 to 3 of 3

Thread: rtrim function

  1. #1
    Join Date
    Nov 2007
    Posts
    27

    Unanswered: rtrim function

    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

  2. #2
    Join Date
    May 2003
    Posts
    113
    Quote Originally Posted by rajaryan4545
    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)

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •