Home > Archive > Cobol > April 2007 > AcuODBC Question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| paparush 2007-04-18, 6:55 pm |
| Using AcuCorp 5.20
Can someone suggest an AcuODBC function (or functions) to use in place
of the MS SQL ISNUMERIC() function?
I need to make sure there are no non-numerics in a field before
performing some math.
Thanks!
| |
| sgbojo@gmail.com 2007-04-25, 3:55 am |
| On Apr 18, 7:07 am, paparush <rushaus...@gmail.com> wrote:
> Using AcuCorp 5.20
>
> Can someone suggest an AcuODBC function (or functions) to use in place
> of the MS SQL ISNUMERIC() function?
>
> I need to make sure there are no non-numerics in a field before
> performing some math.
>
> Thanks!
Check out the Numeric directive when setting up your FD. Chapter 6.3.8
NUMERIC Directive in AcuODBC manual
The NUMERIC directive allows you to treat a data item as an unsigned
integer when it is declared as alphanumeric. You might use this when
the data stored in the item is always numeric.
| |
| sgbojo@gmail.com 2007-04-25, 9:55 pm |
| On Apr 18, 7:07 am, paparush <rushaus...@gmail.com> wrote:
> Using AcuCorp 5.20
>
> Can someone suggest an AcuODBC function (or functions) to use in place
> of the MS SQL ISNUMERIC() function?
>
> I need to make sure there are no non-numerics in a field before
> performing some math.
>
> Thanks!
Try the Numeric directive - Help manual 6.3.8 NUMERIC Directive
The NUMERIC directive allows you to treat a data item as an unsigned
integer when it is declared as alphanumeric. You might use this when
the data stored in the item is always numeric.
|
|
|
|
|