[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| 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 |
293.0. "Cross key Help" by PULPO::REPDIS () Thu Dec 21 1989 14:34
I have to set up 5 different file description, some will have
use cross file and keys. Also I have to set up two field as
one key. And then take a field and use it for reference on two
field key. Can anyone take a look at the design below and tell
if what I done is correct?
UserRep Userinfo Repinfo Retinfo Procinfo
Username Username Report name Record # Procedure
Report name Dept Description Record Desc Step
Qty CC Cost Date Frequency
Dest Record #
Procedure/Step
USERREP
===============
+ USERNAME + combine ( as one key )
+ REPORT NAME + keys
+ QTY +
================
|
|
|
----------------------------------------------------
| |
| |
USERINFO REPINFO
============== ===============
+ USERNAME + key + REPORT NAME + key
+ DEPT + + PROCED_STEP +
+ CC + + DESCRIPTION +
+ DEST + + COST +
============== + REC CONTROL# +
================
|
|
-------------------------------------------------
| |
| |
RETINFO PROCINFO
================ ===============
+ REC CONTROL# + key + PROCEDURE + combine
+ RECORD TYPE + + STEP + keys
+ RETENT PER + + FREQ +
================ ===============
FILENAME=USERRPT,SUFFIX=FOC
SEGNAME=RPTQTY,SEGTYPE=S1
GROUP=USER_RPT,ALIAS=KEY,FORMAT=A30 ,$
FIELDNAME=USERNAME,KEY1,FORMAT=A30,FIELDTYPE=I ,$
FIELDNAME=REPORT_NAME,KEY2,FORMAT=A30,FIELDTYPE=I ,$
FIELDNAME=QTY,ALIAS=QTY,FORMAT=I3 ,$
SEGNAME=USERINFO,SEGTYPE=KU,PARENT=RPTQTY,CRFILE=USERINF,CRKEY=USERNAME,$
SEGNAME=REPINFO,SEGTYPE=KU,PARENT=RPTQTY,CRFILE=REPINF,CRKEY=REPORT_NAME,$
FILENAME=USERINF,SUFFIX=FOC
SEGNAME=USERINFO,SEGTYPE=S1
FIELDNAME=USERNAME,ALIAS=USER,FORMAT=A30,FIELDTYPE=I,$
FIELDNAME=DEPARTMENT,ALIAS=DEPT,FORMAT=A5,$
FIELDNAME=DESTINATION,ALIAS=DEST,FORMAT=A6,$
FILENAME=REPINF,SUFFIX=FOC
SEGNAME=REPINFO,SEGTYPE=S1
FIELDNAME=REPORT_NAME,ALIAS=REPNAM,FORMAT=A30,FIELDTYPE=I,$
FIELDNAME=DESCRIPTION,ALIAS=DESC,FORMAT=A50,$
FIELDNAME=COST,ALIAS=COST,FORMAT=I5C,$
FIELDNAME=REC_CTRL_NO,ALIAS=CTRL_NO,FORMAT=A8,$
FIELDNAME=PROCED_STEP,ALIAS=COM_STEP,FORMAT=A30,FIELDTYPE=I,$
SEGNAME=RETINFO,SEGTYPE=KU,PARENT=REPINFO,CRFILE=RETINF,CRKEY=REC_CTRL_NO,$
SEGNAME=PROCINFO,SEGTYPE=KU,PARENT=REPINFO,CRFILE=PROCINF,CRKEY=PROCED_STEP,$
FILENAME=RETINF,SUFFIX=FOC
SEGNAME=RETINFO,SEGTYPE=S1
FIELDNAME=REC_CTRL_NO,ALIAS=CTRL_NO,FORMAT=A8,FIELDTYPE=I,$
FIELDNAME=RECORD_DESC,ALIAS=REC_DESC,FORMAT=A50,$
FIELDNAME=RETENT_PER,ALIAS=RET_PER,FORMAT=A6,$
FILENAME=PROCINF,SUFFIX=FOC
SEGNAME=PROCINFO,SEGTYPE=S1
GROUP=PROCED_STEP,ALIAS=KEY,FORMAT=A30,FIELDTYPE=I,$
FIELDNAME=PROCEDURE,KEY1,FORMAT=A25,FIELDTYPE=I,$
FIELDNAME=STEP,KEY2,FORMAT=A3,FIELDTYPE=I,$
FIELDNAME=FREQUENCY,ALIAS=FREQ,FORMAT=A1,$
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 293.1 | Group key | MILPND::SHELTRY | Rrruffles have rrranch? | Thu Dec 21 1989 15:40 | 19 |
| > FILENAME=USERRPT,SUFFIX=FOC
> SEGNAME=RPTQTY,SEGTYPE=S1
> GROUP=USER_RPT,ALIAS=KEY,FORMAT=A30 ,$
> FIELDNAME=USERNAME,KEY1,FORMAT=A30,FIELDTYPE=I ,$
> FIELDNAME=REPORT_NAME,KEY2,FORMAT=A30,FIELDTYPE=I ,$
> FIELDNAME=QTY,ALIAS=QTY,FORMAT=I3 ,$
> SEGNAME=USERINFO,SEGTYPE=KU,PARENT=RPTQTY,CRFILE=USERINF,CRKEY=USERNAME,$
> SEGNAME=REPINFO,SEGTYPE=KU,PARENT=RPTQTY,CRFILE=REPINF,CRKEY=REPORT_NAME,$
The only obvious thing I see (a *very* quick first glance) is that
your group key is not quite right. If you want USERNAME and
REPORT_NAME to be the group key, the FORMAT should be A60, not A30.
Anyone else agree or disagree??
Everything else looked okay, but again, I didn't have much time to
look it over 100%.
Hope this helps a bit,
Wayne
|