data conversion error

[Chris Sharman]

Viet Nguyen wrote:

> Hi everyone - I sent this to Mark who's been helping)
> 
>    Element:            CHECK_PAYEE
>     Type:               Numeric
>     Size:               10
>     Decimal Positions:  0
>     Item Defaults:      ZONED-U Size 10
> 
>     Element:            VENDOR
>     Type:               Numeric
>     Size:               6
>     Decimal Positions:  0
>     Item Defaults:      ZONED-U Size 6
> 
(added this line)

>  link check_payee of tbbankcdistr &
>        viaindex vendor to vendor optional 
> 
>  2 errors

You've proved that your errors (presumably data conversion errors) come 
either from the vendor file, or from the link to it.

Not sure whether a check_payee value larger than 999999 would do it - I 
suspect so.
Depending what else you're doing, remember that defines get executed 
before selects, so you can get data conversion errors on unwanted record 
complexes, and (on optional records as here) on missing data.

So:
define xvendor zoned*6 = vendor

would probably give data conversion errors whenever the vendor record 
was missing.

define xvendor zoned*6 = 0 if not record vendor exists else vendor

would give clean results.

Chris


-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.