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--