| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
We've encountered a problem using FOCUS against RDB, and are looking
for insights. Specifically, FOCUS doesn't seem to be able to find all the data
which has been stored in the RDB relation. Following is the FOCUS and RDB
output and metadata.
In FOCUS:
- count of records in the APVCHR relation:
VCH_TY
COUNT
------
34296
- count of records in the APVCHR relation, with check date >= 891201
VCH_TY
COUNT
------
556
- count of records in the APVCHR relation, with check date >= 891201,
grouped by check date
AP
CHECK VCH_TY
DATE COUNT
----- ------
891207 283
891214 273
- APVCHR.MAS
FILENAME=APVCHR, SUFFIX=FOC,$
SEGNAME=AP_VEND, SEGTYPE=S1, $
FIELDNAME=PMT_VNDR_NO , ALIAS=VCH_PMT_VNDR, FORMAT=A11,
TITLE=' PAY TO,VENDOR NO',
DESC=AAPS1 VENDOR NUMBER, $
FIELDNAME=VNDR_NM , ALIAS=VCH_VNDR_NM , FORMAT=A15,
TITLE='PAY TO,VENDOR NAME',
DESC=AAPS26 PAY VENDOR NAME, $
SEGNAME=AP_VCHR, SEGTYPE=S1, PARENT=AP_VEND, $
FIELDNAME=VCH_ID , ALIAS=VCH_VCH_ID , FORMAT=A6, FIELDTYPE=I,
TITLE='VOUCHR, ID',
DESC=AAPS2 VOUCHER NUMBER, $
SEGNAME=VCHR_DTL, SEGTYPE=U, PARENT=AP_VCHR,$
FIELDNAME=VCH_TY , ALIAS=VCH_VCH_TY , FORMAT=A1,
TITLE='VCH,TYP',
DESC=AAPS3 VOUCHER TYPE, $
FIELDNAME=VCH_DT , ALIAS=VCH_VCH_DT , FORMAT=I6,
TITLE=' AP,VOUCHR, DATE',
DESC=AAPS4 VOUCHER DATE, $
FIELDNAME=VCH_GRS_AMT , ALIAS=VCH_VCH_GRSA, FORMAT=P10.2,
TITLE='VOUCHER,GROSS AMOUNT',
DESC=AAPS5 INVOICE GROSS AMOUNT, $
FIELDNAME=VCH_APLD_DT , ALIAS=VCH_VCH_APDT, FORMAT=I6,
TITLE='VOUCHR,APPLY,DATE',
DESC=AAPS8 DUE DATE, $
FIELDNAME=PMT_HOLD_IN , ALIAS=VCH_PMT_HOLD, FORMAT=A1,
TITLE='PMT,HLD,IND',
DESC=AAPS9 HOLD FLAG, $
FIELDNAME=DSC_DT , ALIAS=VCH_DES_DT , FORMAT=I6,
TITLE='INVOICE,DISCNT,DATE',
DESC=AAPS10 DISCOUNT DATE, $
FIELDNAME=VCH_BATCH , ALIAS=VCH_VCH_BATC, FORMAT=A4,
TITLE='AP,VCHR,BTCH',
DESC=AAPS12 BATCH NUMBER, $
FIELDNAME=VNDR_INVC_ID, ALIAS=VCH_VND_INID, FORMAT=A8,
TITLE='VENDOR,INVOICE, ID',
DESC=AAPS16 INVOICE NUMBER, $
FIELDNAME=VNDR_INVC_DT, ALIAS=VCH_VND_INDT, FORMAT=I6,
TITLE='VENDOR,INVOICE,DATE',
DESC=AAPS17 INVOICE DATE, $
FIELDNAME=VNDR_NO , ALIAS=VCH_VNDR_ID , FORMAT=A11,FIELDTYPE=I,
TITLE='VENDOR NO',
DESC=AAPS18 P O VENDOR NUMBER, $
FIELDNAME=CHCK_NO , ALIAS=VCH_CHCK_NO , FORMAT=A5,
TITLE='AP,CHECK,NO',
DESC=AAPS21 CHECK NUMBER, $
FIELDNAME=REFERENCE , ALIAS=VCH_REFERENC, FORMAT=A15,
TITLE='REFERENCE',
DESC=AAPS6 REFERENCE, $
FIELDNAME=TERMS_CD , ALIAS=VCH_TERMS_CD, FORMAT=I2,
TITLE='PO,TRM,CD',
DESC=AAPS7 TERMS CODE, $
FIELDNAME=AVL_DSC_AMT , ALIAS=VCH_AVL_DAMT, FORMAT=P8.2,
TITLE='VENDOR S,DISCOUNT,AMOUNT',
DESC=AAPS11 DISCOUNT AMOUNT, $
FIELDNAME=VCH_SLS_TAX , ALIAS=VCH_VCH_STAX, FORMAT=P9.2,
TITLE='VOUCHER,SALES TX,AMOUNT',
DESC=AAPS13 SALES TAX AMOUNT, $
FIELDNAME=VCH_FRT_AMT , ALIAS=VCH_VCH_FRTA, FORMAT=P9.2,
TITLE='VOUCHER,FREIGHT,AMOUNT',
DESC=AAPS14 FREIGHT AMOUNT, $
FIELDNAME=SIC , ALIAS=VCH_SIC , FORMAT=A8,
TITLE='SIC',
DESC=AAPS19 SIC CODE, $
FIELDNAME=AP_BANK_ID , ALIAS=VCH_AP_BANK , FORMAT=A1,
TITLE='AP,BANK,ID',
DESC=AAPS20 BANK NUMBER, $
FIELDNAME=CHCK_DT , ALIAS=VCH_CHCK_DT , FORMAT=I6,
TITLE='AP,CHECK,DATE',
DESC=AAPS22 CHECK DATE, $
FIELDNAME=RCCLTN_DT , ALIAS=VCH_RCCLTNDT, FORMAT=I6,
TITLE='BANK,RECON,DATE',
DESC=AAPS23 DATE RECONCILED, $
FIELDNAME=INVC_PMT_CNT, ALIAS=VCH_INVC_PCT, FORMAT=I2,
TITLE='INV,PMT,CNT',
DESC=AAPS24 NO CONTRACT PAYTS, $
FIELDNAME=AP_PRNT_IN , ALIAS=AP_PRNT_IN, FORMAT=A1,
TITLE='AP,PRT,IND',
DESC=AAPS25 PRINT FLAG, $
FIELDNAME=AAP_LSTCHGDT, ALIAS=AV_AAP_LCDT , FORMAT=I6,
TITLE=' AAPS, LAST,CHNG DT',
DESC=AAPS27 LAST CHANGE DATE, $
FIELDNAME=AAP_ADD_DT , ALIAS=AV_AAP_ADDT , FORMAT=I6,
TITLE='AAPS,ADD,DATE',
DESC= AAPS28 ADD DATE, $
- APVCHR.ACX
SEGNAME=APVCHR ,TABLENAME="APVCHR" ,
KEYS= 0,WRITE=NO,$
FIELD=VCH_DT , ALIAS=VCH_VCH_DT,TYPE=ADT,$
FIELD=VCH_APLD_DT , ALIAS=VCH_VCH_APDT,TYPE=ADT,$
FIELD=DSC_DT , ALIAS=VCH_DES_DT,TYPE=ADT,$
FIELD=VNDR_INVC_DT, ALIAS=VCH_VND_INDT,TYPE=ADT,$
FIELD=CHCK_DT , ALIAS=VCH_CHCK_DT,TYPE=ADT,$
FIELD=RCCLTN_DT , ALIAS=VCH_RCCLTNDT,TYPE=ADT,$
FIELD=AAP_LSTCHGDT, ALIAS=AV_AAP_LCDT,TYPE=ADT,$
FIELD=AAP_ADD_DT , ALIAS=AV_AAP_ADDT,TYPE=ADT,$
In RDO:
- count of records in the APVCHR relation:
print count of a in apvchr
35123
- count of records in the APVCHR relation, with check date >= 891201
print count of a in apvchr with a.vch_chck_dt ge '01-dec-1989'
1542
- count of records in the APVCHR relation, with check date >= 891201,
grouped by check date
print count of a in apvchr with a.vch_chck_dt eq '07-dec-1989'
283
print count of a in apvchr with a.vch_chck_dt eq '14-dec-1989'
273
print count of a in apvchr with a.vch_chck_dt eq '21-dec-1989'
340
print count of a in apvchr with a.vch_chck_dt eq '28-dec-1989'
459
definition of the PAVCHR relation:
sho fie for apvchr
Fields for relation APVCHR
VCH_PMT_VNDR text size is 11
based on global field VENDOR_NO
VCH_VNDR_NM text size is 15
VCH_VCH_ID text size is 8
based on global field ID8_FIELD
VCH_VCH_TY text size is 1
based on global field TYPE1_FIELD
VCH_VCH_DT Date
based on global field STD_DATE
VCH_VCH_GRSA signed quadword scale -2
based on global field QUAD_COST
VCH_VCH_APDT Date
based on global field STD_DATE
VCH_PMT_HOLD text size is 1
based on global field IND_FIELD
VCH_DES_DT Date
based on global field STD_DATE
VCH_VCH_BATC text size is 4
based on global field BATCH_NO
VCH_VND_INID text size is 8
based on global field ID8_FIELD
VCH_VND_INDT Date
based on global field STD_DATE
VCH_VNDR_ID text size is 11
based on global field VENDOR_NO
VCH_CHCK_NO text size is 6
based on global field CHECK_NO
VCH_REFERENC text size is 15
based on global field REF15_FIELD
VCH_TERMS_CD text size is 2
based on global field CODE2_FIELD
VCH_AVL_DAMT signed longword scale -2
based on global field COST
VCH_VCH_STAX signed longword scale -2
based on global field COST
VCH_VCH_FRTA signed longword scale -2
based on global field COST
VCH_SIC text size is 8
based on global field CODE8_FIELD
VCH_AP_BANK text size is 1
based on global field CODE1_FIELD
VCH_CHCK_DT Date
based on global field STD_DATE
VCH_RCCLTNDT Date
based on global field STD_DATE
VCH_INVC_PCT signed word scale 0
based on global field PERCENT
AP_PRNT_IN text size is 1
based on global field IND_FIELD
AV_AAP_LCDT Date
based on global field STD_DATE
AV_AAP_ADDT Date
based on global field STD_DATE
sho ind for apvchr
Indexes for relation APVCHR
APVCHR_IDX_1 with field VCH_PMT_VNDR
and field VCH_VCH_ID
No duplicates allowed
APVCHR_IDX_2 with field VCH_VCH_ID
Duplicates are allowed
finish
The December dates reflect the processing of AP checks here. Of the
data that FOCUS misses, the majority is of the last 2 weeks of checks, which
were the latest updates applied to the RDB db. As you can see, these are
entirely missing. I don't yet have details on the other missing data.
Any ideas ?
Rick
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 294.1 | Which type of database? | ILO::BROCKLEBANK | Thu Jan 04 1990 05:29 | 7 | |
You mention RDB as your type of database, but the master file has
the suffix for a Focus database. Hopefully it is the RdB part which
is correct.
Regards,
Dave
| |||||
| 294.2 | Missing dates? | MILPND::MADDEN | Fri Feb 16 1990 10:00 | 5 | |
This sounds like a missing data problem. If a date was missing RDB
assigns some ancient date to it. Check the FOCUS/RDB manual on the
usage of the MISSING=ON MISSING =OFF feature.
| |||||