Morning Bob
We just did the same thing with our order entry
This is how we did it
The WORKSTN in you program make user open (USROPN)
Create a new field (stand-alone or whatever) that will contain the id of
the DDS
In our instance
D Wrkstnid        s             20A   inz('DDSNAMEA')
We have 3 Work stations
DDSNAME
DDSNAMEA
DDSNAMEB
In all instances we make changes to DDSNAME.
Then whichever  is the value of  Wrkstnid (in this instance DDSNAMEA) we
copy DDSNAME to the other one (in this instance DDSNAMEB is the opposite of
DDSNAMEA) and we change WRKSTNID to DDSNAMEB
Then within the C-specs we have the following command
C                   eval      Clpstatement = 'OVRDSPF FILE(ORD122)  -
C                              TOFILE(*LIBL/'  +
C                              %trim(Wrkstnid) +
C                               ')'
C                   eval      Errorflag = As400cmd(Clpstatement)
C                   open      ORD122
and obviously a
C                   if        %open(Ord122)
C                   close     Ord122
C                   endif
C                   MOVEL     '1'           *INLR
C                   RETURN
and within the D-specs
    // Execute Command (system) Subprocedure Variables
D As400cmd        PR            10I 0 ExtProc('system')
D  CmdText                        *   Value Options(*String)
D
D ErrorCPF        S              7A   Import('_EXCP_MSGID')
D ErrorFlag       S             10I 0 Inz(0)
This may seem convoluted, and I've tried to explain it to other people
here, but I know it works.
Whenever we need to make a change to the DDS, we promote everything (NOT
DDSNAMEB in this instance) to PRODUCTION, then inform the users that they
need to sign-off and sign back on again at their earliest convenience to
start using the new version.
If you have any further questions
of if you think I've left something out, please feel free to ask
Alan Shore
NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill
                                                                       
             Bob.Voltz@colaik.                                         
             com                                                       
             Sent by:                                                   To
             midrange-l-bounce         Midrange Systems Technical      
             s+alanshore=nbty.         Discussion                    
             com@xxxxxxxxxxxx          <midrange-l@xxxxxxxxxxxx>       
                                                                        cc
                                                                       
             05/08/2007 09:01                                      Subject
             AM                        Putting a display file into     
                                       production.                     
                                                                       
             Please respond to                                         
             Midrange Systems                                          
                 Technical                                             
                Discussion                                             
             <midrange-l@midra                                         
                 nge.com>                                              
                                                                       
                                                                       
Is there a way to put a display file into production when users are using
the program and have a lock on it?
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential, proprietary, and/or
privileged material. Any review, retransmission, dissemination or other use
of, or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: 
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at 
http://archive.midrange.com/midrange-l.
 
As an Amazon Associate we earn from qualifying purchases.