I have a table INFO with three columns in db2.

Table Name Field Type
Name char
Loc char
Profession char.

Column Name has the following fields
A
B
C
D
E
F
G

When I execute this query I get nothing back.

Select * from INFO where Name > 'B';

Thanks for your help in advance.

What tool do you use to execute query?
If it's command line/shell please add double quotes around SQL (> might be working as stream redirection)

db2 "with info(name) as (values 'A', 'B', 'C', 'D', 'E') Select * from INFO
where Name > 'B'"

NAME
----
C
D
E

I am using QMF. It still wont work.

it's works.
db2 "with info(name) as (values 'A', 'B', 'C', 'D', 'E') Select * from INFO where Name > 'B'"