To:      US-LHC users of the uslhcMag database. 
 Subject: US-LHC magnet database instruction
 From:    C.G. Trahern and J. Wei (trahern@bnl.gov, wei1@bnl.gov)
 Date:    April 6, 1998

 Database tables for measurement data of US-LHC magnets, currently
in their preliminary form, are in database uslhcMag.

 If you want to log into the sybase data server at BNL, there is a
standard guest-type login available. If you are using the guest unix
account in the RHIC AP domain, then your environment will probably be
set correctly. But if not, be sure to source the login-rap file in
/usr/public/ENV to get any database related environment variables
defined. We assume that in these notes that whoever is logging in has
some idea of how to navigate inside sybase. If not, these notes may
just be confusing.

 The ones that matter:

 SYBASE /usr/local/share/sybase
 DSQUERY RHICSYB

 add to path: $SYBASE/bin and rehash. 

 The sybase login is "harmless". The password is also "harmless". This
user has only select privilege on any database that it has access, so
it's harmless, in principle.

 Then once you login via isql, 

 isql -U harmless -P harmless 

 This will put you in the pubs2 database by default. You need to get
to uslhcMag by 

 use uslhcMag
 go

 At this point you need to know something more about sybase databases,
but to find the user tables

 select name from sysobjects where type ="U"
 go

 and then sp_help table_name will give you information on the
structure of the tables, or 

 select * from table_name will give you whatever data is there. 

 Over time more sophisticated methods for presenting the structure and
data will become available.