Error trying to add to DB, What am I doing wrong?

[Ron Hanna]

Since E-PAT-ACCT-NBR is a key, you output statement should be:

ITEM E-PAT-ACCT-NBR    initial E-PAT-ACCT-NBR OF JDAPRET

I think the other item statements can use either the initial or final
clause such as:

ITEM OLB-OS-CODE       final OS-VEN-CD



Ron Hanna
Sr. Systems Analyst
Partnership Healthplan of California
707 863-4408
rhanna@partnershiphp.org 


-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]
On Behalf Of Scott Gates
Sent: Monday, July 08, 2002 11:36 AM
To: 'Powerh-L (E-mail)
Subject: Error trying to add to DB, What am I doing wrong? 


The dataset is defined as:
DATA BASE: DBOLB2                       WED, JUL  3, 2002, 10:13 AM

DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000

SET NAME:
   OS-SUMMARY,MANUAL

      ITEMS:
         E-PAT-ACCT-NBR,       X8            <<KEY ITEM>>
         OLB-OS-CODE,          X4
         OLB-JDA-VEN-CODE,     X4
         OLB-FLAGED-DATE,      I2
         OLB-SENT-DATE,        I2
         OLB-VEN-ACK-DATE,     I2
         OLB-TURN-AMT,         I2

      CAPACITY: 5000            ENTRIES: 0

- show rec os-summary
07/08/02                 Precision 2000 - ALT-11                  Page
1
                         R E C O R D   R E P O R T
                           For DICTIONARY:  PHD
    Record:             OS-SUMMARY
    of File:            DBOLB2
    Organization:       MASTER
    Type:               TURBOIMAGE
    Open:               OS-SUMMARY of DBOLB2
    Record Size:        32 Bytes

-- Record Contents --
    Item                                 Type            Size  Occ
Offset
    E-PAT-ACCT-NBR                       CHARACTER          8
0
    .ENTITY-ID                           CHARACTER          2
0
    .PAT-ACCT-NBR                        PACKED UNSIGNED    6
2
    OLB-OS-CODE                          CHARACTER          4
8
    OLB-JDA-VEN-CODE                     CHARACTER          4
12
    OLB-FLAGED-DATE                      INTEGER SIGNED     4
16
    OLB-SENT-DATE                        INTEGER SIGNED     4
20
    OLB-VEN-ACK-DATE                     INTEGER SIGNED     4
24
    OLB-TURN-AMT                         INTEGER SIGNED     4
28

-- Index Contents --

 ** E-PAT-ACCT-NBR is a 8 byte   UNIQUE PRIMARY  index **

    Segment                              Type            Size  Ord
Offset
    E-PAT-ACCT-NBR                       CHARACTER          8    A
0

> CAN CLEAR

> SET DEFAULT

> ACC *JDAPRET

> DEF E-PAT-ACCT-NO CHAR *8 = E-PAT-ACCT-NBR

>

> DEF OS-VEN-CD CHAR * 4 = "TRSI"

> DEF JDA-VEN-CODE  CHAR * 4 = "606"

>

> DEF BAL-DUE-N NUM * 9 = NCONVERT (BAL-DUE)

> DEF N-TODAY ZONED UNSIGNED SIZE 8 =SYSDATE

>

>  SORT ON E-PAT-ACCT-NBR

> OUTPUT OS-SUMMARY ADD ON ERROR REPORT                  
>

>   ITEM E-PAT-ACCT-NBR    = E-PAT-ACCT-NBR OF JDAPRET

*E* Only initial key/index items are accepted when adding records to
master 
files.

>   ITEM OLB-OS-CODE       = OS-VEN-CD

>   ITEM OLB-JDA-VEN-CODE  = JDA-VEN-CODE

>   ITEM OLB-FLAGED-DATE   = N-TODAY

>   ITEM OLB-SENT-DATE     = N-TODAY

>   ITEM OLB-TURN-AMT      = BAL-DUE-N                            
>                                                          

What am I doing wrong?