Re: Is this the University of Midrange.com? (was Re: Comp in DDS)

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On Thursday, March 18, 2004, at 01:45  PM, Tom Liotta wrote:

> Okay, so you apparently want blanks to be allowed at the same time you 
> want characters greater than or equal to 'A' to be allowed. I'm not 
> yet sure if you only want alphabetic characters, but it seems 
> reasonable. The problem is that you can only specify one COMP keyword 
> for a field. Therefore, you can't have COMP EQ ' ' and COMP GE 'A' at 
> the same time.
>
> One way is not to use COMP at all. Instead, use VALUES().
>
>     A                                VALUES(' ' 'A' 'B' 'C' 'D'...)

Aside from the inanity of the original question ...

      A                                COMP(GE 'A')
      A                                CHECK(AB)

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------