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

Scott Gates SGates@olbh.com
Mon, 8 Jul 2002 14:36:03 -0400


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01C226AE.50285260
Content-Type: text/plain;
	charset="iso-8859-1"

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? 



------_=_NextPart_000_01C226AE.50285260
Content-Type: application/octet-stream;
	name="Scott Gates.vcf"
Content-Disposition: attachment;
	filename="Scott Gates.vcf"

BEGIN:VCARD
VERSION:2.1
N:Gates;Scott
FN:Scott Gates
ORG:Our Lady of Bellefonte Hospital
TITLE:Programmer/Analyst
NOTE;ENCODING=QUOTED-PRINTABLE:-----BEGIN PGP PUBLIC KEY BLOCK-----=0D=0AVersion: PGPfreeware 6.5.8 for non=
-commercial use <http://www.pgp.com>=0D=0A=0D=0AmQENAztdpLEAAAEIAKKpLePQk+YS=
EimhxxLC7uxOm/XTk+zgloI0uEQ3BGCo9Fcb=0D=0AUkuSnhXKASamaglM9rZZ7GODB4lYGXMlJR=
uv/rWjE81Q41qmSC2Aq2ABkV7Lif8B=0D=0AKrtjdQPCqMEjIBHZ7QohKqfAS073+JFbnCoJ79+j=
aOe0Hd648AxEbArZuyrvh72i=0D=0AN8Jxp9enHHd3axO+r7JCmG3od6TfkaiC7bLVERhLuvkACF=
b/SVoXdMZJILAzzYsy=0D=0AQbEyYiHuXuk97O35qhZtcxOgKBFZFgvlb5MiFnAGaAUS5wUcJE8M=
h0D6jSk5EsR4=0D=0AGwUOeKpcuBSwUgvKn3F+rpAGC3XvaoXiFRrkFSkABRG0HVNjb3R0IEdhdG=
VzIDxz=0D=0AZ2F0ZXNAb2xiaC5jb20+iQEVAwUQO12ksWqF4hUa5BUpAQEDXggAm2TvjXdimevX=
=0D=0AiqEKUl7hUnCFfiT/pUbdatpPGAxEYc9Dnvu11Ptyt4eKyuYI1gSacIX3DqaJUl+Y=0D=
=0AgM8mvQEvMKeEGazIYRGtLv4r1OUki4s7xg1lCFlwp3QWKzx3hSVqw4Bb5eIjl57o=0D=0AJ3I=
oZKeoXHtpKjrgyboHBc0HZae/v+zdUq8p7gWoDzndtYoFRzI2H/6lqqQ9P1pg=0D=0Avbst+OWVj=
GbRWomZeRpQNGoA+OgDXwkKziwJ+ZFTmq48ikYoRsrjk5ewhxAxqz0F=0D=0AcnjEz5GnJzKouCM=
B5+SjHh6pVJ0qKwNbIOmC9xu39yCi1gkggo2ExjeXtAm4rm3a=0D=0AXILQ6DmwaQ=3D=3D=0D=
=0A=3DRNlT=0D=0A-----END PGP PUBLIC KEY BLOCK-----=0D=0A
TEL;WORK;VOICE:(606) 833-3773
TEL;WORK;FAX:(606) 833-3342
ADR;WORK:;;P.O. Box 789;Ashland;Kentucky;41105-0789;United States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:P.O. Box 789=0D=0AAshland, Kentucky 41105-0789=0D=0AUnited States of America
EMAIL;PREF;INTERNET:SGates@olbh.com
REV:20020125T183744Z
END:VCARD

------_=_NextPart_000_01C226AE.50285260--