Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Talking Unanswered: Regular Expression Functions (UDF) can easily install

    Hi, I'm komikoni(Keisuke Konishi).

    I created the regular expression function (UDF) which does not exist in db2.
    The UDF using the SQL/XML(Xquery).
    You can easily install.

    List of regular expressions provide UDF
    1. REG_MATCHES
      provides Coincidence existence ( Scalar )
    2. REG_REPLACE
      string substitution ( Scalar )
    3. REG_COUNT
      number of matches retrieved ( Scalar )
    4. REG_POSITION
      match position acquisition ( Scalar )
    5. REG_SUBSTR
      gets a string matching ( Scalar )
    6. REG_SUBSTR_TABLE
      list of matching string information ( Table )
    7. REG_TOKENIZE_TABLE
      list of mismatched string information (divided by a separator string) ( Table )
    8. REG_ALLTOKEN_TABLE
      list of mismatch string and matching string information ( Table )


    Scripts can be downloaded from here.
    (Sorry in Japanese)

    https://www.ibm.com/developerworks/jp/data/library/db2/j_d-regularexpression/

    (English : Machine translation Script Download)

    I look forward to your feedback and comments.
    Last edited by komikoni; 11-27-11 at 01:23.

Tags for this Thread

Posting Permissions

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