MVSFORUMS.com

jamel1999 · Beginner Joined: 06 Dec 2007 Posts: 1 Topics: 1

Does anyone know what could be the cause of data appearing in the database out of order? Here is an example of the database in datavantage. 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

rk_pulikonda · Posted: Fri Mar 14, 2008 7:13 pm Post subject:

Could you provide more details.

How did you get this data ?
How can you say the data is in out of order ?
_________________
Thanks
-Ram