| 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 have existing .RDB files and I'd like to try TABLETALK against
them. I'm hoping that there's an easier way to make FOCUS use
the RDB data than using the editor to create the .MAS and .ACX
files. After poking around a bit, I foudn something called
AUTORDB.FEX, but there's no documentation. Any suggestions -
so that I don't have to type in all my field names, etc ?
Thanks,
Anne
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 50.1 | AutoRDB - still have to type | ILO::MCKNIGHT | Mike Mcknight 890-2516 IRM ESDC. | Tue Mar 22 1988 05:48 | 10 |
ALL AUTORDB.FEX will do is create a .MAS and .ACX for one relation
on the RDB at a time. Therefore what you will end up doing is merging
the descriptions together into one .MAS and .ACX. Also be careful
that you link the relations on the files correctly which the AOTORDB
won't help you do. Hopefully in time IBI will intoduce an AUTORDB
that will map against a multi-relational RDB.
Regards
Mike.
| |||||
| 50.2 | also works with views | MIDCIM::LINDQUIST | Tue Mar 22 1988 06:50 | 3 | |
Added note:
AUTORDB.FEX also will create a .MAS and .ACX on an RDB VIEW;
just give AUTORDB the view name instead of the relation name.
| |||||
| 50.3 | thanks | MSBIS2::FORMALARIE | Tue Mar 22 1988 08:16 | 3 | |
thanks for the assists.
Anne
| |||||
| 50.4 | What about Indexes ? | WILKIE::PETROPH | Tue Mar 22 1988 08:37 | 9 | |
When using AUTORDB, does it know about the indexes in
a relation ? I had a conversation with an IBI person
who said you had to describe the indexes in the ACX file.
This was not explained very well. Does anyone know how
this is done ?
Rich...
| |||||
| 50.5 | need help | TUNER::CARNEY | Tue Mar 22 1988 09:41 | 55 | |
I have been trying to define some indeces in an .acx file
but have been getting the error message:
(FOC1452) SEGMENT NAME IN ACCESS FILE IS NOT PRESENT IN MASTER :
TEST/
I get this message when I try to do any table file queries on the
relational database and am using v1.3 of focus.
Following is the .mas and .acx files that are generating the
error. If someone can identify the problem I think It will answer
the previous reply.
mike
TEST.MAS
FILENAME=TEST,SUFFIX=RDB,$
SEGNAME=CPUTBL,SEGTYPE=S0,$
FIELD=CPU_FAM ,ALIAS=PRM_CPU_FAM,A10,A10,MISSING=OFF,$
FIELD=CPU_FAM_DESC,ALIAS=CPU_FAM_DESC,A50,A50,MISSING=OFF,$
FILENAME=REV,SUFFIX=RDB,$
SEGNAME=REVHDR87,SEGTYPE=S0,PARENT=CPUTBL,$
FIELD=DEC_ORDER_NO,ALIAS=DEC_ORDER_NO ,A9 ,A9 ,MISSING=OFF,$
FIELD=GOVT_MRKT_CD,ALIAS=GOVT_MRKT_CD ,A4 ,A4 ,MISSING=OFF,$
FIELD=MJR_ACCT_CD ,ALIAS=MJR_ACCT_CD ,A3 ,A3 ,MISSING=OFF,$
FIELD=DSCNT_AGRMT ,ALIAS=DSCNT_AGRMT ,A13,A13,MISSING=OFF,$
FIELD=MJR_SLS_CHNL,ALIAS=MJR_SLS_CHNL ,A2 ,A2 ,MISSING=OFF,$
FIELD=APLCN_CD ,ALIAS=APLCN_CD ,A4 ,A4 ,MISSING=OFF,$
FIELD=USER_DPT_CD ,ALIAS=USER_DPT_CD ,A2 ,A2 ,MISSING=OFF,$
FIELD=BILLTO_CUSTM,ALIAS=BILLTO_CUSTM ,A7 ,A7 ,MISSING=OFF,$
FIELD=SOLDTO_CUSTM,ALIAS=SOLDTO_CUSTM ,A7 ,A7 ,MISSING=OFF,$
FIELD=SHIPTO_CUSTM,ALIAS=SHIPTO_CUSTM ,A7 ,A7 ,MISSING=OFF,$
FIELD=PRM_CPU_FAM ,ALIAS=PRM_CPU_FAM ,A10,A10,MISSING=OFF,$
FIELD=HDR_SEGMT_CD,ALIAS=HDR_SEGMT_CD ,A3 ,A3 ,MISSING=OFF,$
FIELD=GOVT_CONTRCT,ALIAS=GOVT_CONTRCT ,A26,A26,MISSING=OFF,$
FIELD=ORD_CERT_DT ,ALIAS=ORD_CERT_DT ,I4 ,I4 ,MISSING=OFF,$
FIELD=CMP_SHPMT_DT,ALIAS=CMP_SHPMT_DT ,I4 ,I4 ,MISSING=OFF,$
FIELD=GOV_PRRTY_CD,ALIAS=GOV_PRRTY_CD ,A4 ,A4 ,MISSING=OFF,$
FIELD=BKNG_CTR_ID ,ALIAS=BKNG_CTR_ID ,A4 ,A4 ,MISSING=OFF,$
FIELD=DSTRCT_ID ,ALIAS=DSTRCT_ID ,A4 ,A4 ,MISSING=OFF,$
FIELD=LST_INVCE_DT,ALIAS=LST_INVCE_DT ,I4 ,I4 ,MISSING=OFF,$
FIELD=PROCRMT_TYPE,ALIAS=PROCRMT_TYPE ,A2 ,A2 ,MISSING=OFF,$
FIELD=ORD_CANCL_DT,ALIAS=ORD_CANCL_DT ,I4 ,I4 ,MISSING=OFF,$
FIELD=PO_NO ,ALIAS=PO_NO ,A26,A26,MISSING=OFF,$
TEST.ACX
SEGNAME=CPUTBL,TABLENAME=CPU_TBL,$
SEGNAME=REVHDR87,TABLENAME=REVHDR_FY87,$
KEYFLD = CPU_FAM , IXFLD=PRM_CPU_FAM,$
| |||||
| 50.6 | CSMDBA::ZABLONSKI | Tue Mar 22 1988 12:00 | 12 | ||
Test.acx should look like this
SEGNAME=CPUTBL,TABLENAME=CPU_TBL,$
SEGNAME=REVHDR87,TABLENAME=REVHDR_FY87,
KEYFLD = CPU_FAM , IXFLD=PRM_CPU_FAM,$
Note the only difference is removing the $ at the end of line
SEGNAME=REVHDR87
| |||||
| 50.7 | TUNER::CARNEY | Wed Mar 23 1988 13:43 | 15 | ||
THANKS .6
For the record:
I have noticed a blatant discrepancy with the examples showing
an embedded join in the "RDB INTERFACE USERS MANUAL".
Page 4-17 and appendix C-4 both show the SEGNAME=COURSE line
with a $ at the end of it. However, the correct way is on page
4-13, where it shows SEGNAME=COURSE without the $.
Mike
| |||||
| 50.8 | FOCUS-Rdb errors (FOC1431) (FOC1454) | FDCV01::TXSYS | Thu Sep 29 1988 11:16 | 41 | |
I am a new FOCUS user trying to access an existing Rdb database and
getting FOCUS errors:
(FOC1431) NO KEYWORD FOR ACCESS FILE VALUE : TABLENAME
(FOC1454) ERROR IN ACCESS FILE AT OR NEAR LINE : 01/NEWTABLE
(FOC1425) INVALID KEYWORD IN ACCESS FILE : FIELDNAME/CC_COST_CTR
(FOC1454) ERROR IN ACCESS FILE AT OR NEAR LINE : 04/NEWTABLE
etc... (get the 1425 and 1454 pair for every field in the relation)
The Rdb database has multiple relations in it. Rdb filename is NEWTABLE.RDB,
the relation I'm trying to access is COSTCENTER. I have read access only
to the Rdb database. We're using FOCUS 5.2 (a beta version).
Any help or ideas would be appreciated.
The .MAS and .ACX follow.
thanks Steve
FILENAME=NEWTABLE,SUFFIX=RDB,$
SEGNAME=COSTCTR,SEGTYPE=S0,$
FIELDNAME=CC_COST_CTR, ALIAS=, USAGE=A3,ACTUAL=A3,MISSING=OFF,$
FIELDNAME=CC_ACT_INACT, ALIAS=, USAGE=A1,ACTUAL=A1,MISSING=OFF,$
FIELDNAME=CC_BOOK_CODE, ALIAS=, USAGE=A1,ACTUAL=A1,MISSING=OFF,$
etc....
SEGNAME=COSTCTR,TABLENAME=COSTCENTER
KEYS=0, WRITE=NO,$
FIELDNAME=CC_COST_CTR, ALIAS=COST_CENTER_CODE,$
FIELDNAME=CC_ACT_INACT, ALIAS=COST_CENTER_ACT_INACT_CODE,$
FIELDNAME=CC_BOOK_CODE, ALIAS=COST_CENTER_BOOKING_CODE,$
FIELDNAME=CC_CERC, ALIAS=COST_CENTER_CERC_CODE,$
FIELDNAME=CC_CRSS_CHG1, ALIAS=COST_CENTER_CROSS_CHG1,$
| |||||
| 50.9 | CSMDBA::ZABLONSKI | Thu Sep 29 1988 14:33 | 31 | ||
>>FILENAME=NEWTABLE,SUFFIX=RDB,$
>>SEGNAME=COSTCTR,SEGTYPE=S0,$
>>FIELDNAME=CC_COST_CTR, ALIAS=, USAGE=A3,ACTUAL=A3,MISSING=OFF,$
>>FIELDNAME=CC_ACT_INACT, ALIAS=, USAGE=A1,ACTUAL=A1,MISSING=OFF,$
>>FIELDNAME=CC_BOOK_CODE, ALIAS=, USAGE=A1,ACTUAL=A1,MISSING=OFF,$
>> etc....
>>SEGNAME=COSTCTR,TABLENAME=COSTCENTER
>> KEYS=0, WRITE=NO,$
>>FIELDNAME=CC_COST_CTR, ALIAS=COST_CENTER_CODE,$
>>FIELDNAME=CC_ACT_INACT, ALIAS=COST_CENTER_ACT_INACT_CODE,$
>>FIELDNAME=CC_BOOK_CODE, ALIAS=COST_CENTER_BOOKING_CODE,$
>>FIELDNAME=CC_CERC, ALIAS=COST_CENTER_CERC_CODE,$
>>FIELDNAME=CC_CRSS_CHG1, ALIAS=COST_CENTER_CROSS_CHG1,$
What your missing is the required "," after the TABLENAME=COSTCENTER
Try the .ACX as
SEGNAME=COSTCTR,TABLENAME=COSTCENTER,
KEYS=0, WRITE=NO,$
FIELDNAME=CC_COST_CTR, ALIAS=COST_CENTER_CODE,$
FIELDNAME=CC_ACT_INACT, ALIAS=COST_CENTER_ACT_INACT_CODE,$
FIELDNAME=CC_BOOK_CODE, ALIAS=COST_CENTER_BOOKING_CODE,$
FIELDNAME=CC_CERC, ALIAS=COST_CENTER_CERC_CODE,$
FIELDNAME=CC_CRSS_CHG1, ALIAS=COST_CENTER_CROSS_CHG1,$
| |||||
| 50.10 | almost there... | FDCV01::TXSYS | Thu Sep 29 1988 17:33 | 5 | |
Re -1. Thanks. That took care of the first pair of errors but I'm
still getting the (FOC1425) and (FOC1454) errors for every field.
The syntax looks correct... Any other ideas??
Thanks, Steve
| |||||
| 50.11 | Suppress the undocumented line | GVAADG::PERINO | Y a pas de quoi, service | Fri Sep 30 1988 05:30 | 20 |
R .8 I have more questions than answers : - In which documentation did you find : KEYS=0, WRITE=NO,$ - Is there some doc. about read-only transactions using FOCUS/Rdb? Does somebody have experience in this area ? Looking at my documentation "Rdb Interface Users Manual" (with no version # and no date) I would just try suppressing the above line in the ACX : SEGNAME=COSTCTR,TABLENAME=COSTCENTER,$ FIELDNAME=CC_COST_CTR, ALIAS=COST_CENTER_CODE,$ ... I read a note sometimes ago about Rdb transaction using FOCUS but I cannot find it anymore. Anyway it raised more questions then it gave answers. It seems to be the rule in this area... I hope to hear from you - Jo�l | |||||