is there a fuction or way to do this?
Asked whether Informix has a built-in function returning 0 for negative numbers and the value otherwise (for accounting reports). Several people suggested a CASE expression in the SELECT, but the developer/Cognos report writer didn't want to use CASE (licensing limits and a desire for something built-in). Alternatives offered: write a small SPL or C UDR (Paul Watson/Art Kagel, with sample C code), wrap the CASE in a view (Mike Aubury), or the arithmetic trick (value + ABS(value))/2 (Fernando Nunes). No final choice is recorded, though a UDR seemed the likely route.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
HPUX B.11.31 U ia64 Itanium (BL870c) IDS 11.50.FC6 Cognos 8.4 The developer for account/hr and our report writer both asked me this question today for different projects. Does Informix have a function that will return a zero if the numeric value is negative and just return the value if positive? It is for a number of accounting type reports. They need to show zeros if the value is zero or less and the actual value if positive. What they are looking for: -12.58 -> 0.00 0.00 -> 0.00 159.67 -> 159.67 I did a quick look at the list of functions and didn't see anything that jumps out at me. Anyone have any ideas how to do this in Informix sql? I'm sure I'm missing something simple. John Adamski Network Specialist Graceland University
If using SQL for select - shouldn't a case statement work? select CASE When value > 0 then Value Else 0 END From table_name...... -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Adamski Sent: Friday, October 22, 2010 11:40 AM To: ids@iiug.org Subject: is there a fuction or way to do this? [21786] HPUX B.11.31 U ia64 Itanium (BL870c) IDS 11.50.FC6 Cognos 8.4 The developer for account/hr and our report writer both asked me this question today for different projects. Does Informix have a function that will return a zero if the numeric value is negative and just return the value if positive? It is for a number of accounting type reports. They need to show zeros if the value is zero or less and the actual value if positive. What they are looking for: -12.58 -> 0.00 0.00 -> 0.00 159.67 -> 159.67 I did a quick look at the list of functions and didn't see anything that jumps out at me. Anyone have any ideas how to do this in Informix sql? I'm sure I'm missing something simple. John Adamski Network Specialist Graceland University ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ----------------------------------------- This message and any attachments may contain confidential information or trade secrets of SMI. SMI will take legal action against any person who improperly uses or discloses SMI's confidential information or trade secrets. If you have received this message in error, please notify the sender immediately and delete and destroy this message and its attachments.
On Fri, 2010-10-22 at 11:40 -0400, John Adamski wrote: > The developer for account/hr and our report writer both asked me this question > today for different projects. > Does Informix have a function that will return a zero if the numeric value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero or less > and the actual value if positive. > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 What about just using a CASE? SELECT CASE WHEN myfield < 0 THEN 0 ELSE myfield END AS myfield FROM mytable WHERE othefield = 'xyz' > I did a quick look at the list of functions and didn't see anything that jumps > out at me. > Anyone have any ideas how to do this in Informix sql? I'm sure I'm missing > something simple. -- Adam Tauno Williams <awilliam@whitemice.org> LPIC-1, Novell CLA <http://www.whitemiceconsulting.com>; OpenGroupware, Cyrus IMAPd, Postfix, OpenLDAP, Samba
Just use a CASE statement. Art On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this question > today for different projects. > > Does Informix have a function that will return a zero if the numeric value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero or less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything that jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636164497de68360493374464
All, I suggested that and they came up with a number of reasons they don't want to use the case. Thanks I just wanted to make sure I wasn't missing something. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, October 22, 2010 11:38 AM To: ids@iiug.org Subject: Re: is there a fuction or way to do this? [21789] Just use a CASE statement. Art On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this question > today for different projects. > > Does Informix have a function that will return a zero if the numeric > value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero > or less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything > that jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm > missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636164497de68360493374464 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Just write a single SPL or UDR -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Adamski Sent: Friday, October 22, 2010 2:47 PM To: ids@iiug.org Subject: RE: is there a fuction or way to do this? [21790] All, I suggested that and they came up with a number of reasons they don't want to use the case. Thanks I just wanted to make sure I wasn't missing something. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, October 22, 2010 11:38 AM To: ids@iiug.org Subject: Re: is there a fuction or way to do this? [21789] Just use a CASE statement. Art On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this question > today for different projects. > > Does Informix have a function that will return a zero if the numeric > value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero > or less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything > that jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm > missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636164497de68360493374464 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. _____ avast! Antivirus <http://www.avast.com>; : Outbound message clean. Virus Database (VPS): 101022-1, 10/22/2010 Tested on: 10/22/2010 2:56:27 PM avast! - copyright (c) 1988-2010 ALWIL Software.
Something like mi_int zeroit(mi_integer num) { return (num <= 0 ) ? num : 0 ; } Not tested but.... -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Adamski Sent: Friday, October 22, 2010 2:47 PM To: ids@iiug.org Subject: RE: is there a fuction or way to do this? [21790] All, I suggested that and they came up with a number of reasons they don't want to use the case. Thanks I just wanted to make sure I wasn't missing something. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, October 22, 2010 11:38 AM To: ids@iiug.org Subject: Re: is there a fuction or way to do this? [21789] Just use a CASE statement. Art On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this question > today for different projects. > > Does Informix have a function that will return a zero if the numeric > value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero > or less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything > that jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm > missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636164497de68360493374464 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. _____ avast! Antivirus <http://www.avast.com>; : Outbound message clean. Virus Database (VPS): 101022-1, 10/22/2010 Tested on: 10/22/2010 3:08:41 PM avast! - copyright (c) 1988-2010 ALWIL Software.
Paul, I think that is what the developer is looking at doing. Well at least was when he left my office. Who know what mischief has crossed his mind since then. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul Watson Sent: Friday, October 22, 2010 3:09 PM To: ids@iiug.org Subject: RE: is there a fuction or way to do this? [21792] Something like mi_int zeroit(mi_integer num) { return (num <= 0 ) ? num : 0 ; } Not tested but.... -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Adamski Sent: Friday, October 22, 2010 2:47 PM To: ids@iiug.org Subject: RE: is there a fuction or way to do this? [21790] All, I suggested that and they came up with a number of reasons they don't want to use the case. Thanks I just wanted to make sure I wasn't missing something. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, October 22, 2010 11:38 AM To: ids@iiug.org Subject: Re: is there a fuction or way to do this? [21789] Just use a CASE statement. Art On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this question > today for different projects. > > Does Informix have a function that will return a zero if the numeric > value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero > or less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything > that jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm > missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636164497de68360493374464 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. _____ avast! Antivirus <http://www.avast.com>; : Outbound message clean. Virus Database (VPS): 101022-1, 10/22/2010 Tested on: 10/22/2010 3:08:41 PM avast! - copyright (c) 1988-2010 ALWIL Software. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Things like this are so simple to write - I really don't understand why more people don't use UDRs for bits of dumb logic, and most of the time they are significantly faster than the SPL equivalent -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Adamski Sent: Friday, October 22, 2010 3:17 PM To: ids@iiug.org Subject: RE: is there a fuction or way to do this? [21793] Paul, I think that is what the developer is looking at doing. Well at least was when he left my office. Who know what mischief has crossed his mind since then. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul Watson Sent: Friday, October 22, 2010 3:09 PM To: ids@iiug.org Subject: RE: is there a fuction or way to do this? [21792] Something like mi_int zeroit(mi_integer num) { return (num <= 0 ) ? num : 0 ; } Not tested but.... -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Adamski Sent: Friday, October 22, 2010 2:47 PM To: ids@iiug.org Subject: RE: is there a fuction or way to do this? [21790] All, I suggested that and they came up with a number of reasons they don't want to use the case. Thanks I just wanted to make sure I wasn't missing something. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, October 22, 2010 11:38 AM To: ids@iiug.org Subject: Re: is there a fuction or way to do this? [21789] Just use a CASE statement. Art On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this question > today for different projects. > > Does Informix have a function that will return a zero if the numeric > value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero > or less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything > that jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm > missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636164497de68360493374464 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. _____ avast! Antivirus <http://www.avast.com>; : Outbound message clean. Virus Database (VPS): 101022-1, 10/22/2010 Tested on: 10/22/2010 3:08:41 PM avast! - copyright (c) 1988-2010 ALWIL Software. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. _____ avast! Antivirus <http://www.avast.com>; : Outbound message clean. Virus Database (VPS): 101022-1, 10/22/2010 Tested on: 10/22/2010 3:22:12 PM avast! - copyright (c) 1988-2010 ALWIL Software.
I'd really like to know the reasons they don't want to use the case clause. From: "John Adamski" <adamski@graceland.edu> To: ids@iiug.org Date: 10/22/2010 01:46 PM Subject: RE: is there a fuction or way to do this? [21790] Sent by: ids-bounces@iiug.org All, I suggested that and they came up with a number of reasons they don't want to use the case. Thanks I just wanted to make sure I wasn't missing something. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, October 22, 2010 11:38 AM To: ids@iiug.org Subject: Re: is there a fuction or way to do this? [21789] Just use a CASE statement. Art On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this question > today for different projects. > > Does Informix have a function that will return a zero if the numeric > value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero > or less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything > that jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm > missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636164497de68360493374464 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Madison, From what I got when both were talking at me at the same time. :-) For the cognos report writer it has to do with some of the users licenses don't allow adding things like 'case' in the select and that he would have to do something multiple times so all the different users could have I guess what would be a function. I'm NOT a cognos person so not exactly what is involved or what he was talking about. For all I know this could be a lot of work. The developer seemed not to want to copy/paste the code or create a proc to do this. I'm not sure he really had a problem but more just that what he needed wasn't 'built in'. I think it was just the normal programmer why isn't it built in lament. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Madison Pruet Sent: Friday, October 22, 2010 3:23 PM To: ids@iiug.org Subject: RE: is there a fuction or way to do this? [21795] I'd really like to know the reasons they don't want to use the case clause. From: "John Adamski" <adamski@graceland.edu> To: ids@iiug.org Date: 10/22/2010 01:46 PM Subject: RE: is there a fuction or way to do this? [21790] Sent by: ids-bounces@iiug.org All, I suggested that and they came up with a number of reasons they don't want to use the case. Thanks I just wanted to make sure I wasn't missing something. John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, October 22, 2010 11:38 AM To: ids@iiug.org Subject: Re: is there a fuction or way to do this? [21789] Just use a CASE statement. Art On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this question > today for different projects. > > Does Informix have a function that will return a zero if the numeric > value is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero > or less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything > that jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm > missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636164497de68360493374464 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
You could write a UDR in C to perform the transformation rather cheaply. It'll be about 10 lines of code or less. You could do it in SPL or a Java UDR as well, but for something so low level, I'd opt for C. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Oct 22, 2010 at 3:46 PM, John Adamski <adamski@graceland.edu> wrote: > All, > > I suggested that and they came up with a number of reasons they don't want > to > use the case. > > Thanks I just wanted to make sure I wasn't missing something. > > John > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art > Kagel > Sent: Friday, October 22, 2010 11:38 AM > To: ids@iiug.org > Subject: Re: is there a fuction or way to do this? [21789] > > Just use a CASE statement. > > Art > On Oct 22, 2010 11:40 AM, "John Adamski" <adamski@graceland.edu> wrote: > > HPUX B.11.31 U ia64 Itanium (BL870c) > > IDS 11.50.FC6 > > Cognos 8.4 > > > > The developer for account/hr and our report writer both asked me this > question > > today for different projects. > > > > Does Informix have a function that will return a zero if the numeric > > value > is > > negative and just return the value if positive? It is for a number of > > accounting type reports. They need to show zeros if the value is zero > > or > less > > and the actual value if positive. > > > > What they are looking for: > > -12.58 -> 0.00 > > 0.00 -> 0.00 > > 159.67 -> 159.67 > > > > I did a quick look at the list of functions and didn't see anything > > that > jumps > > out at me. > > > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm > > missing > > > something simple. > > > > John Adamski > > Network Specialist > > Graceland University > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --001636164497de68360493374464 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd156465cecf704933aaf46
Just for fun, it's not better than the solutions already provided: SELECT (value_column + ABS(value_column)) / 2 If I still know some math it will work. Is it a function? No. Does it use a function? Yes! Does it matter? I don't know... after the CASE justification I just don't know... On Fri, Oct 22, 2010 at 4:40 PM, John Adamski <adamski@graceland.edu> wrote: > HPUX B.11.31 U ia64 Itanium (BL870c) > IDS 11.50.FC6 > Cognos 8.4 > > The developer for account/hr and our report writer both asked me this > question > today for different projects. > > Does Informix have a function that will return a zero if the numeric value > is > negative and just return the value if positive? It is for a number of > accounting type reports. They need to show zeros if the value is zero or > less > and the actual value if positive. > > What they are looking for: > -12.58 -> 0.00 > 0.00 -> 0.00 > 159.67 -> 159.67 > > I did a quick look at the list of functions and didn't see anything that > jumps > out at me. > > Anyone have any ideas how to do this in Informix sql? I'm sure I'm missing > something simple. > > John Adamski > Network Specialist > Graceland University > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001636b431dc480fea04933b6e4c
Cant you create a view on the select with the CASE ? Or is it something more generic you're after ? On Friday 22 October 2010 21:42:07 John Adamski wrote: > Madison, > > >From what I got when both were talking at me at the same time. :-) For the > > cognos report writer it has to do with some of the users licenses don't > allow adding things like 'case' in the select and that he would have to do > something multiple times so all the different users could have I guess > what would be a function. I'm NOT a cognos person so not exactly what is > involved or what he was talking about. For all I know this could be a lot > of work. > > The developer seemed not to want to copy/paste the code or create a proc to > do this. I'm not sure he really had a problem but more just that what he > needed wasn't 'built in'. I think it was just the normal programmer why > isn't it built in lament. > > John > -- Mike Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ