Re: SQL Help

On Mon, Mar 2, 2009 at 9:27 AM, Jim Minisce <jminisce@xxxxxxxxx> wrote:

Hi all,

I am working on an SQL statement to update fields in a file. Here is
what I have so far:

update qtemp/fcmst# as Q
set (FCJAN,FCFEB,FCMAR,FCAPR,FCMAY,FCJUN,FCJUL) =
(Select FCJAN,FCFEB,FCMAR,FCAPR,FCMAY,FCJUN,FCJUL
From LIBNAME/FCMST# as A
Where Q.ITNBR = A.ITNBR and Q.CTYPE = A.CTYPE and
A.FISYY = 2008)
Where FISYY = 2028

Apply the coalesce function on each column that may be null:

update qtemp/fcmst# as Q
set (FCJAN,FCFEB,FCMAR,FCAPR,FCMAY,FCJUN,FCJUL) =
(Select coalesce( FCJAN , 0 )
, coalesce( FCFEB , 0 )
, coalesce( FCMAR , 0 )
, coalesce( FCAPR , 0 )
, coalesce( FCMAY , 0 )
, coalesce( FCJUN , 0 )
, coalesce( FCJUL , 0 ) )
From LIBNAME/FCMST# as A
Where Q.ITNBR = A.ITNBR and Q.CTYPE = A.CTYPE and
A.FISYY = 2008)
Where FISYY = 2028