Re: query and absolute value

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Not that I know of. The DIGITS function will ignore the sign, but it
creates a character string. No way to convert back.

SQL has had ABS since at least v3r2. Can you use a QMQRY instead? If you
have Query Manager, you can use that - has Query/400-like interface. If
not, you can create a QMQRY from source. Just create a source file with
record length = 91 (don't ask). Then merely enter your SQL statement into
it. Then CRTQMQRY. Run it with STRQMQRY.

At 02:56 PM 3/22/02 -0600, you wrote:
>Greetings,
>
>I am attempting to write a query that will take a particular field (positive
>or negative numeric data) and perform a calculation using the absolute value
>of that number.  Is there a way to make Query/400 ignore the sign of numeric
>data like this?
>
>Thanks,
>
>-doug
>
>
>************************************************
>DOUGLAS JOHNSON
>System Administrator
>The University Book Store
>711 State Street
>Madison, WI 53703
>
>djohnson@univbkstr.com
>608-257-3784
>608-257-9479(fax)
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.