Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Null values in a date.
Go
New
Search
Notify
Tools
Reply
  
Null values in a date.
 Login/Join
 
Platinum Member
posted
I have a reporting object with a three table join. One of the table
SCB5201 has a CLOSDT(A date field with nulls allowed). The report is
showing the close date as NULL(even though some the dates are not NULL). The database is DB2. Given
below is the join.

JOIN AGENT.AGT_NUMBER IN AGENT TO ALL SCB5111.LPAGENTCODE IN SCB5111 AS J0
JOIN
SCB5111.BUSNID AND SCB5111.CUSTID IN AGENT TO ALL SCB5201.BUSNID
AND SCB5201.CUSTID IN SCB5201 AS J1
END

Any ideas?.
 
Posts: 176 | Location: Desplaines | Registered: August 05, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
It's showing the CLOSDT as null for every row of your report?
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Null values in a date.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.