How to find the maximum value of a particular field inIMS-DB

Susheel singh · New User Joined: 25 Jul 2013 Posts: 13 Location: INDIA

Hi,

I want to know is there any function in IMS DB which can give a maximum value of particular field in a database.

Thanks in advance!

Nic Clouston · Posted: Mon Mar 24, 2014 2:01 pm

How do you mean "maximum value"? Actual maximum currently on the DB? Or the maximum possible value that the field can hold? Or something else?

Susheel singh · New User Joined: 25 Jul 2013 Posts: 13 Location: INDIA

suppose i have a date field in one segment , i want to get the highest date among all the records.

enrico-sorichetti · Posted: Mon Mar 24, 2014 2:46 pm

do You realize that IMS knows nothing about the segments content/data ?
IMS has to be told only about the KEY related fields

Susheel singh · New User Joined: 25 Jul 2013 Posts: 13 Location: INDIA

i have a requirement that for some particular date field i need to get the maximum date among all the records in the database.

Anyone please suggest how can i achieve this...

enrico-sorichetti · Posted: Mon Mar 24, 2014 6:21 pm

Anuj Dhawan · Posted: Mon Mar 24, 2014 6:39 pm

With that definition of your problem you look pretty far from what your destination!

In an effort to read between the lines -

how's your date field defined? Is it in Julian or Gregorian format?
"Maximum" is a relative term, with what the "value" should be maximum?
With the information in hand I can think of two ways:

Use File-Aid for IMS and select the only field and look at the values.
As Enrico suggested write a program. Read the segment with date-filed. In output write the key for segment and the date-filed. And work with this output to get what you need.

Nic Clouston · Posted: Mon Mar 24, 2014 6:51 pm

And what do you do if there is more than one record with that date?

Rohit Umarjikar · Posted: Wed Mar 26, 2014 7:57 am

pic.dhe.ibm.com/infocenter/eiic/v1r1/index.jsp?topic=%2Fcom.ibm.ims10.doc.apg%2Fims_comparehierandreldbs.htm