RE: SNDF command

Oops, sorry, just missed this.

Michael Schutte
Work 614-492-7419
email  michael_schutte@xxxxxxxxxxxx


                                                                           
             "Bob O."                                                      
             <otis_the_cat@hot                                             
             mail.com>                                                  To 
             Sent by:                  midrange-l@xxxxxxxxxxxx             
             midrange-l-bounce                                          cc 
             s@xxxxxxxxxxxx                                                
                                                                   Subject 
                                       RE: SNDF command                    
             03/21/2006 08:54                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




   Never mind.  I needed the FRCDTA keyword on the display file.

     ----------------------------------------------------------------------

     From:  "Bob O." <otis_the_cat@xxxxxxxxxxx>
     Reply-To:  Midrange Systems Technical Discussion
     <midrange-l@xxxxxxxxxxxx>
     To:  midrange-l@xxxxxxxxxxxx
     Subject:  SNDF command
     Date:  Tue, 21 Mar 2006 07:28:53 -0600
     >    I have a CL program where I want to display a window as soon as
     processing
     >    begins using the SNDF command.  Here's an example of the code I'm
     using:
     >
     >
     >    DCLF MYWNDW
     >
     >    IF  (&MTRL  *NE  ' ')  THEN(DO)
     >
     >    SNDF  RCDFMT(SCR01)
     >
     >    /* CLEAR THE FILE CS361FIL AND LOAD IT */
     >
     >            CALL  PGM(MYLIB/CS361CL)
     >
     >            SQL2XLSR  SQLSTMT('select * from MYLIB/CS361FIL')  +
     >
     >            TOXLS('/Accounting/MFG_OVERHEAD_MATERIAL.xls')  +
     >
     >            FROMXLS('/Templates/CS361Template.xls')  +
     >
     >            COLHDRS(*SQLLABEL)
     >
     >    ENDDO
     >
     >
     >
     >    The window does display, but not until the SQL2XLSR command
     runs.  Why is
     >    this?
     >--
     >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.
     >
--
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.