DB2 Questions

richu · New User Joined: 03 Feb 2006 Posts: 8

hi all,
Plz help me with these questions.

1) What does DIGITS function does in DB2 ?
Plz give an eg.

2)Can we use ORDER BY clause without using where clause ?
or is this query valid:-> (Select S# from s order by city)

Thanks in advance.......

ofer71 · Posted: Thu Feb 16, 2006 11:05 pm

Hi

1) The DIGITS scalar function returns a character representation of an argument. You can read more about it in the fine manual, along with example.

2) Sure you can. Look at this example from the fine manual.

O.