Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

what is the equivalent of select max(column) in IDMS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 237

PostPosted: Thu May 24, 2007 9:14 am    Post subject: what is the equivalent of select max(column) in IDMS
Reply with quote

what is the equivalent of select max(column) in IDMS
Back to top
View user's profile Send private message

tosaurabh20

New User


Joined: 08 Jun 2007
Posts: 26
Location: Noida

PostPosted: Thu Jun 21, 2007 3:34 pm    Post subject: Re: what is the equivalent of select max(column) in IDMS
Reply with quote

pkmurali wrote:
what is the equivalent of select max(column) in IDMS



Hi,

The functionality of IDMS is totally different from DB2. DB2 is a relational database and IDMS is networked. IDMS record structure is like a linked list one occurence of record is attached to other. You can say one record occurence is equivalent to a single row in db2 table. however there is no such command which could let you know about your desired results in IDMS.

You need to go through each record occurence (say area sweep) and find out the maximum value by incorporating the logic in your program.

Let me know in case of any issues.

Thanks
Saurabh
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts IDMS DC027007 T58 TASK:ADS2 PROG:ADSO... gpowell382 IDMS/ADSO 2 Fri Jun 30, 2017 11:52 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 6 Sun Nov 06, 2016 8:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us