COBOL data appearing out of order in database
250 pts.
0
Q:
COBOL data appearing out of order in 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
ASKED: Jan 2 2008  3:06 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
250 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Jan 2 2008  3:06 PM GMT by 123456   250 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0