Interactive 'WITH' Statement

Sample code not working and I don't see why.  Any suggestions?
Token ( was not valid. Valid tokens: FOR WITH FETCH ORDER UNION EXCE 
 WITH MYTABLE AS (SELECT DDCREW, DDDRV#,                              
   DATE(DDYEAR || DDMOTH || DDDAY) As strdate, ddmd from cdsddm)      
 select * from MYTABLE                                                
   where dddrv#=2523                                                  
    and strdate = 20090316

Open in new window

lynn_harrisAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Dave FordConnect With a Mentor Software Developer / Database AdministratorCommented:

Since my date-format is *ISO, the following works for me:

WITH MYTABLE AS (
  SELECT 2523 as DDDRV#,
         DATE('2009' || '-' || '03' || '-' || '16') As strdate
  from   sysibm/sysdummy1)
select *
from   MYTABLE
where  dddrv#=2523
  and  strdate = '2009-03-16'
 
HTH,
DaveSlash

Open in new window

0
 
lynn_harrisAuthor Commented:
Thank You.  I will toy with my some more.  
0
All Courses

From novice to tech pro — start learning today.