DB2 date column has some null values
Posted: Mon Mar 30, 2009 10:49 pm
hi
i have created a table named account (accountno,date,balance) and inserted some values into it.
date column has some null values.
if i use select statement like
SELECT BALANCE,OPENDATE INTO :WS-BAL,:WS-OPENDATE
FROM ACCOUNT WHERE ACCOUNTNO = :WS-ACCOUNTNO
the above code doesnot work for the null values and the above code works fine for non-null values
what is the solution to retreive null values?
i have created a table named account (accountno,date,balance) and inserted some values into it.
date column has some null values.
if i use select statement like
SELECT BALANCE,OPENDATE INTO :WS-BAL,:WS-OPENDATE
FROM ACCOUNT WHERE ACCOUNTNO = :WS-ACCOUNTNO
the above code doesnot work for the null values and the above code works fine for non-null values
what is the solution to retreive null values?