Dear list,

I am trying to create view from a table for the following conditions.

1. I need to extract only month from a date field (close_date)
2. I need to extract only year from a date filed(close_date).
3. I have a column in the table called code which has values : blanks,
alphanumeric chars(valid), '/////', '/ *', '//////////*' in my view I
should be adding a new column and add value "Y" to all the rows with
alphanumeric chars(valid) and "N" to all others

what would be the create view syntax for the above say if the name of the
table called SUM_CUST?

Thanks for your help
Bala

DB2 & UDB email list listserv db2-l LazyDBA home page