Hi....Would you know what could be the cause of data appearing in an IMS database out of order? Access type is HIDAM, rules=(,H). The segment that is out of sort order is a child, there are 4 occurrences, and it should be sorted by effective date. Here is an example of the database in data vantage. The key field is pm-acct-eff-date, so the data should be inserted by that date:
CUSTROOT (01,001) CUSTNO(00,12345690)
CUST (02,003) **NOKEY**
PM-ACCT-EFF-DATE 06047+
PM-ACCT-NO-5 21859
PM-SUB-ACCT 999
CUSTROOT (01,001) CUSTNO(00,12345690)
CUST (02,003) **NOKEY**
PM-ACCT-EFF-DATE 05017+
PM-ACCT-NO-5 62092
PM-SUB-ACCT 000
CUSTROOT (01,001) CUSTNO(00,12345690)
CUST (02,003) **NOKEY**
PM-ACCT-EFF-DATE 01017+
PM-ACCT-NO-5 61570
PM-SUB-ACCT 000
CUSTROOT (01,001) CUSTNO(00,12345690)
CUST (02,003) **NOKEY**
PM-ACCT-EFF-DATE 06017+
PM-ACCT-NO-5 21859
PM-SUB-ACCT 000
ASKED:
Jan 2 2008 3:06 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _