Re: SNDF command

[Michael_Schutte@xxxxxxxxxxxx]

Do you want to continue with the code even though the window is displayed?
If so you need to specify a "Y" for the

Put data before buffer is full  . .   FRCDTA

In the DDS.

If you don't want to continue with the window displayed, you need to use
the SNDRCVF



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 
                                       SNDF command                        
             03/21/2006 08:28                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




   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.