IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DISTINCT in FOCUS


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
karthickpearl

New User


Joined: 13 Apr 2010
Posts: 35
Location: Chennai

PostPosted: Tue Sep 28, 2010 10:42 pm
Reply with quote

Hi Guys,

I need the FOCUS code to retrieve DISTINCT values of a field.

In DB2 it is something like below,
Select Distinct field_1
from table_A
where x=y;

I need the equivalent FOCUS query for the above DB2 query.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Sep 28, 2010 11:59 pm
Reply with quote

Hello,

What does the documentation from Information Builders have to say?

If you don't want to read the documentation, you could open an issue with IBI Support.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts COBOL copybook to Focus COBOL Programming 7
No new posts Using SPUFI with DISTINCT and MAX is ... DB2 8
No new posts column with count of rows within dist... DB2 4
No new posts Row-Numbers of distinct rows? DB2 1
No new posts Relatated to FOCUS program All Other Mainframe Topics 1
Search our Forums:

Back to Top