|Date: ||Tue, 19 Jun 2001 09:51:38 -0700|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Jeff Voeller <c-Jeff.Voeller@WCOM.COM>|
|Subject: ||Re: DB2 (MVS) - EBCDIC/ASCII problem ?|
|Content-type: ||text/plain; charset=iso-8859-1|
On Tuesday, June 19, 2001 at 9:30 AM, Graham Dodswroth wrote:
> If I try using the following 'where' clause to achieve this it doesn't
> seem to work - i.e. the syntax seems to be correct but the blank
> character on the DB2 table is not recognised as the same as the blank
> character I type in on my PC.
> Where Stat2 = ' '
My DB2 memory is rusty, but I think you need something along the lines of:
WHERE STAT2 IS NULL