RE: SNDF command

  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.
    >