Conference ilbbak::ibi_focus

173.0. "4 Questions of FOCUS" by PARITY::SISLE () Mon Jan 23 1989 17:28

    Hi,
    
    I have a few questions.
    
    I am working with hold files and the book says that you if you state
    the APPEND parameter, FOCUS will append the report to an existing
    file. The default is replace. 
    
    For some reason, the default on our system is APPEND. I can not
    get FOCUS to replace the HOLD file. (I use the command HOLD AS CC_388
    FORMAT DOC.) Does anybody no the paremeter for REPLACE (I tried
    REPLACE,NOAPPEND) or how to make the default REPLACE?
    
    I am working with a database created from RDB. I can only use the
    command ON TABLE HOLD AS CC_388 FORMAT DOC in the FEX file if I
    am working with a MASTER FILE that only references one segment.
    When I try this with a multisegmented MASTER FILE, I get an error
    that says THE OPTION IN THE 'ON' PHRASE IS INVALID. (FOC018). The
    report file is exactly the same, except for the MASTER FILE it
    references. Does this have something to do with the implicit joins
    the RDB FOCUS book talks about. Do I need to do a MATCH even if
    the segment is of type U (It is)?
    
    It does work if I issue the command HOLD AS CC_388 FORMAT DOC after
    the report comes to the screen.
    
    I have also tried to send my output to a file. This works. I issue
    the command OFFLINE CLOSE and then FILEDEF OFFLINE DISK [filename].
    Now to get my output back to the terminal, I issue the command OFFLINE
    CLOSE and then FILEDEF OFFLINE TERM. This works, but I get the line
    OFFLINE.... after every report on my terminal. How do I get rid
    of this?
    
    Finally, a security question. If you forbid a user to see a record
    unless the field NAME = SISLE the user can only get to that particular
    record. I tried this and it worked fine. I then tried to add the
    constraint that besides only viewing records with NAME = SISLE,
    they were not allowed to view the field NAME. THey could see AGE,BADGE
    and DECPHONE, but not NAME. 
    
    This created an error that said something like USER DOES NOT HAVE
    ACCESS TO FIELD NAME and then FIELD NAME NOT IN DICTIONARY.
    
    Can anybody help me??
    
    Thanks,
    
    Larry Sisle
    MIS @TWO
    

>        For some reason, the default on our system is APPEND. I can not
>    get FOCUS to replace the HOLD file. (I use the command HOLD AS CC_388
>    FORMAT DOC.) Does anybody no the paremeter for REPLACE (I tried
>    REPLACE,NOAPPEND) or how to make the default REPLACE?

 	I know of no way to change to APPEND default, but renaming or
    deleting the HOLD file will accomplish what you need, or establish
    unique names for each HOLD.
    
    Curtis Coppersmith