| 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 |
I'm just starting with FOCUS and I'm trying to read an existing RDB db. The system I'm using has FOCUS 5.0 VX1.31A installed and I have a mis-match of documentation. Some 5.1 some 5.2 (I know, I know, but it is all I have). I've tried following the RDB interface manual describing multi-table master file description (sec 4-2). Perhaps that is my problem, I don't know. When I enter FOCUS and try a CHECK FILE filename, I get the following errors: FOC306 Desc. error master file attribute not recognized: FIELD (same error for) SEGNAME and ALIAS I receive this error a number of times for FIELD and only twice for SEGNAME and once for ALIAS. I have 7 occurances of SEGNAME and as many ALIAS' as FIELDS. I've checked my syntax and everything looks ok. I also receive: FOC215 First segment specified with a non blank parent: parent name and this is true, but I did it just like the book....HUH? Any ideas or suggestions would be greatly appreciated. I do have V5.2 of FOCUS on my desk and could have it installed if you think it would help. Sorry for being so awkward about all this, but that is basically how I'm feeling right now. help, Rose
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 124.1 | Doc set is poor; sharing working mas/acx | NRMLZE::ESTES | Fri Sep 02 1988 14:36 | 58 | |
Don't feel akward about - the Focus RDB documentation has many errors and is
generally some of the worst I have seen. I have had to manually correct
several illustrations and examples to keep myself sane (sort of)...
Stu
Attached is a working master/acx file of a rdb database that joins several relations:
Note use of Unique segtype - Book doesn't mention it...
The master file:
FILE=STOCK, SUFFIX=RDB
SEGNAME=STOCK, SEGTYPE=S0, $
FIELD=PART ,ALIAS= ,USAGE=A015 ,A15 ,
TITLE='PART NUMBER ',$
FIELD=SR ,ALIAS= ,USAGE=A008 ,A8 ,
TITLE='S_R ',$
FIELD=SR_OH_QTY ,ALIAS= ,USAGE=I008 ,I4 ,
TITLE='S_R,ON HAND,QUANTITY ',$
SEGNAME=PART , SEGTYPE=U, PARENT=STOCK,$
FIELD=PART1 ,ALIAS= ,USAGE=A015 ,A15 ,
TITLE='PRESENT,FOR,JOIN ',$
FIELD=DESC ,ALIAS= ,USAGE=A035 ,A35 ,
TITLE='PART DESCRIPTION ',$
FIELD=STD_UNIT_CST,ALIAS= ,USAGE=F011.4 ,F4 ,
TITLE='STD UNIT,COST ',$
SEGNAME=LOC , SEGTYPE=S0, PARENT=STOCK,$
FIELD=PART2 ,ALIAS= ,USAGE=A015 ,A15 ,
TITLE='PRESENT,FOR,JOIN ',$
FIELD=SR2 ,ALIAS= ,USAGE=A008 ,A8 ,
TITLE='PRESENT,FOR,JOIN ',$
FIELD=SR_LOC ,ALIAS= ,USAGE=A015 ,A15 ,
TITLE='LOCATION ',$
FIELD=LOC_OH_QTY ,ALIAS= ,USAGE=I008 ,I4 ,
TITLE='LOCATION,ON HAND,QUANTITY ',$
The corresponding acx file...
SEGNAME=STOCK,TABLENAME="MDSTRNDB.STOCKSTATUS_INFO",KEYS=,WRITE=NO,$
FIELD=PART , ALIAS=PART_NO ,$
FIELD=SR , ALIAS=STKRM_ID ,$
FIELD=SR_OH_QTY , ALIAS=STKRM_PART_ON_HAND_QTY ,$
SEGNAME=PART ,TABLENAME="MDSTRNDB.PART_INFO",KEYS=,WRITE=NO,
KEYFLD=PART,
IXFLD=PART1,$
FIELD=PART1 , ALIAS=PART_NO ,$
FIELD=DESC , ALIAS=PART_DSCRPN ,$
FIELD=STD_UNIT_CST, ALIAS=PART_STD_UNIT_COST ,$
SEGNAME=LOC ,TABLENAME="MDSTRNDB.STOCK_LOCATION_INFO",KEYS=,WRITE=NO,
KEYFLD=PART/SR,
IXFLD=PART2/SR2, $
FIELD=PART2 , ALIAS=PART_NO ,$
FIELD=SR2 , ALIAS=STKRM_ID ,$
FIELD=SR_LOC , ALIAS=PART_STKRM_STRG_ADDR_CD ,$
FIELD=LOC_OH_QTY , ALIAS=STKRM_LOCTN_PART_ON_HAND_QTY ,$
| |||||
| 124.2 | Unique?? | ESGVAX::BOLAND | Fri Sep 09 1988 18:52 | 13 | |
What does SEGTYPE = U do?
I have another question; in my RDB database I have a few relations
which do not have PARENTs and have not included any reference to
PARENTs. When I try to access these relations view FOCUS I receive
an error message that the KEYFLD and IXFLD aren't there, obviously
they aren't 'cuz I didn't put any there. Does this SEGTYPE = U
handle this type of situation?
Thanks for your examples Stu. They really helped!
Rose
| |||||