[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference azur::mcc

Title:DECmcc user notes file. Does not replace IPMT.
Notice:Use IPMT for problems. Newsletter location in note 6187
Moderator:TAEC::BEROUD
Created:Mon Aug 21 1989
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:6497
Total number of notes:27359

1711.0. "MCC and SQL Time" by MICROW::LANG () Thu Oct 24 1991 16:27

    	
    	We are going to use mcc 1.2 to write an AM which accesses an
    	SQL database.  We want to store creation time in the database,
    	and pass it back as absbintim, to the PM.  We would like to
    	use the Posix time() service to do this. Will this be possible,
    	and if not, is there a conversion routine available which
    	we can use?  
    
    	We ideally would like the database routine to timestamp the
    	record with the creation time.  If this is not possible, then
    	the calling program could fill in the time, and the database
    	could just store it.  The thing is both the AM and the process
    	it communicates with access the database, so the target process
    	does not have access to the mcc time routines.  Does mcc use
    	DTS (Distributed Time Services?) If we could use the same mechanism
    	that MCC uses, then MCC will be able to interprete the time when
    	it is passed as a status, in the out_p.
    
    		thanks,
    				Bonnie
T.RTitleUserPersonal
Name		DateLines
1711.1DECmcc uses bare DECdts API routinesTOOK::T_HUPPERThe rest, as they say, is history.Fri Oct 25 1991 12:3625
    RE .0:
    
    DECmcc uses the DECdts API routines (installation of DECdts is not
    required for DECmcc) for its time operations.  The MCC_T_BinAbsTim
    structure is the utc structure defined by DECdts.  It is opaque to
    DECmcc.  If you use the DECdts services yourself, you will be fully
    compatible with DECmcc.
    
    Note that in the DECmcc time routines, the utc structure is pointed to
    by the mcc_a_pointer field of the MCC descriptor.  The
    mcc_time_create() routine will create an MCC descriptor pointing to a
    buffer of the correct size if the type is set to MCC_K_DT_BIN_ABS_TIM.
    If the last 2 parameters (pointers to length and value) are set up,
    your favorite utc time value will be copied into the provided buffer. 
    Thus you can bring a bare DECdts utc structure into the DECmcc
    environment.
    
    If you do use the DECdts routines, will you require the installation of
    DECdts for your target process?  DECmcc has an agreement with DECdts to
    use the DECdts API routines without requiring installation of DECdts. 
    This liberates DECmcc from the DECnet Phase V waves and permits our
    operation in non-DECnet environments without hassle, as we are required
    to do.
    
    Ted
1711.2Don't want to require DECdtsMICROW::LANGMon Jan 06 1992 13:1617
     >  If you do use the DECdts routines, will you require the installation of
     >  DECdts for your target process?  DECmcc has an agreement with DECdts to
     >  use the DECdts API routines without requiring installation of DECdts.
     >  This liberates DECmcc from the DECnet Phase V waves and permits our
     >  operation in non-DECnet environments without hassle, as we are required
     >  to do.
    
    	We don't now require the installation of DECdts, and don't want to
    	require it.  I was thinking, since DECmcc repackages this, we could
    	either link with the DECmcc library, or better yet for our
        servers which don't now need to link with DECmcc, just pull the
        DECdts object out of your library and use it.  (I don't know if
    	its this easy.)
    
    	It looks as if /usr/mcc/mmtoolkit/libutc.a is the same as
        /usr/lib/libutc.a, so we could use that.
1711.3Almost correct.MACROW::SEVIGNYWed Jul 15 1992 17:4211
    
    
    Using DECdts to create/get a time, MCC is displaying this time 4 hours
    ahead of the intended time.  (My guess is that "it" thinks GMT, even
    thought I'm in EST).  Am I missing an environment variable indicating
    my time zone?
    
    I'm running Ultrix 4.2
    
    Marc
1711.4What option did you pick?TOOK::MINTZErik Mintz, dtn 226-5033Wed Jul 15 1992 18:235
During your installation, how  did you answer the questions about time modes?
You can look in /usr/mcc/mcc_system/mcc_login.csh to see how the
resulting environmental variables were set.

-- Erik
1711.5Is this what I'm supposed to be looking at?MACROW::SEVIGNYThu Jul 16 1992 10:205
    
    setenv MCC_TIME_IN_MODE 2
    setenv MCC_TIME_OUT_MODE 2