UDB, 8.2, Solaris.

From class, I know that you sometimes need to put single quotes around select statements on the command line. I am trying to do a simple select with a where clause (that has to have single quotes) and it's not working.

I've tried:
db2 select a,b,c from syscat.dbauth where grantee = 'public'
db2 'select a,b,c from syscat.dbauth where grantee = 'public''
db2 "select a,b,c from syscat.dbauth where grantee = 'public'"

no luck.
Julie

Your last format is correct, however it does not give the required result because -
1) SYSCAT.DBAUTH does not have columns a, b or c
2) DB2 converts all users/groups to upper case, so you should compare to 'PUBLIC'

Here's a sample query -

db2 "select * from syscat.dbauth where grantee = 'PUBLIC' "

thanks. that worked. I had tried the PUBLIC but maybe not with that syntax. Thought I did. Sorry for your trouble, but thanks!

Julie