Hello Judith,
try
"... where date1 > current date" (without the { }).
Thomas
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 02, 2001 12:12 PM
Subject: DB2EUG: Help with creating a view
>
>
> Hello all,
>
> I am trying to create a view on a table that has appoximately 4 million
rows.
> This view would need to limit the amount of data returned by selecting
rows
> based on dates in the table and whether they are greater than the current
date.
> Is there a function I can use to return current date in the view creation
select
> clause? For example:
>
> db2 "create view ABC as select field1, field2, date1
> from YYY.ZZZ
> where date1 > {current date}"
>
> Any suggestions would be appreciated!
>
> Judy
>
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
