COBOL data appearing out of order in database
COBOL, Database
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
