Professional Web Applications Themes

Aggregate Bitwise OR Function - IBM DB2

Hi all, I am new to DB2 having previously worked on Microsoft SQL Server and MySQL. Is there an aggregate function that basically allows me to calculate the bitwise OR of a particular field (over a group of records)? Any help would be greatly appreciated. Regards, Mark...

  1. #1

    Default Aggregate Bitwise OR Function

    Hi all,

    I am new to DB2 having previously worked on Microsoft SQL Server and
    MySQL. Is there an aggregate function that basically allows me to
    calculate the bitwise OR of a particular field (over a group of
    records)?

    Any help would be greatly appreciated.

    Regards,

    Mark
    Mark Guest

  2. #2

    Default Re: Aggregate Bitwise OR Function

    Mark Micallef <com> wrote:
     

    Functions that implement bit operation are part of the Sybase migration tool
    kit that you can find here:
    http://www-3.ibm.com/software/data/db2/migration/mtk/

    And a paper about aggregates is here:
    http://www7b.boulder.ibm.com/dmdd/library/techarticle/0309stolze/0309stolze.html

    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena
    Knut Guest

  3. #3

    Default Re: Aggregate Bitwise OR Function

    Check out developer domain. There is an article on vaious UDF including
    bitwise functions.

    Cheers
    Serge


    Serge Guest

  4. Moderated Post

    Default Re: Aggregate Bitwise OR Function

    Removed by Administrator
    --CELKO-- Guest
    Moderated Post

Similar Threads

  1. access to "COMPUTE" aggregate function?
    By lifeinkorea in forum Coldfusion Database Access
    Replies: 2
    Last Post: January 11th, 09:37 PM
  2. Replies: 3
    Last Post: July 4th, 01:53 PM
  3. note 29864 rejected from function.aggregate by didou
    By didou@php.net in forum PHP Notes
    Replies: 0
    Last Post: July 1st, 12:32 PM
  4. note 30395 rejected from function.aggregate by didou
    By didou@php.net in forum PHP Notes
    Replies: 0
    Last Post: July 1st, 12:32 PM
  5. Replies: 1
    Last Post: June 30th, 09:42 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139