Hello,

I'm wondering how I can test whether a field matches a 10-digit
integer within DB2.

--
MfG/Sincerely

Toralf Förster
pgp finger print: 7B1A 07F4 EC82 0F90 D4C2 8936 872A E508 7DB6 9DA3

toralf wrote:

Hello,
>
I'm wondering how I can test whether a field matches a 10-digit
integer within DB2.
>

Just add a check constraint to the column to force the range.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

On Aug 13, 1:51*pm, Serge Rielau <srie...@ca.ibm.comwrote:

toralf wrote:

>

>
Just add a check constraint to the column to force the range.
>

Not sure I understand. Are you thinking in terms of

CHECK ( colx between '00' AND '99' )

? That wont work since (for example) '00' <= '4e' <= '99' or did you
have something else in mind?

/Lennart

Lennart wrote:

On Aug 13, 1:51Â*pm, Serge Rielau <srie...@ca.ibm.comwrote:

>
Not sure I understand. Are you thinking in terms of
>
CHECK ( colx between '00' AND '99' )

These are chars, not integers. With integers, you would check
check (colx between 1000000000 and 9999999999). Then, DB2 enforces
that all values in this column have 10 digits (in decimal notation,
of course).

? That wont work since (for example) '00' <= '4e' <= '99' or did you
have something else in mind?

I do not understand that. You want 10 digits in hex notation? I do not
know if DB2 allows hex notation of digits, if not, just convert do decimal
and put the decimal range.

Boris Stumm wrote:

check (colx between 1000000000 and 9999999999).

Hi,

this is what I was looking for - thx guys.

--
MfG/Sincerely

Toralf Förster
pgp finger print: 7B1A 07F4 EC82 0F90 D4C2 8936 872A E508 7DB6 9DA3

On Aug 14, 11:54*am, Boris Stumm <st...@informatik.uni-kl.dewrote:

Lennart wrote:

>

>

>

>

>
These are chars, not integers.

I'm well aware of that. The question seemed to obvious that I draw the
conclusion that the column was char(10). My bad

[...]

>
I do not understand that. You want 10 digits in hex notation?

Not at all, 4e was an example of a string that is <= '99' and >= '00'
and not a valid integer (char representation of an integer).


/Lennart