RE: SQL2XLS in batch program

  I haven't had a problem so far.  All it does it take the formatting of
  some text in the first row and apply it to the spreadsheet created.

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

    From:  "John Candidi" <jacandidi@xxxxxxxxxxxxxxxxxxxx>
    Reply-To:  Midrange Systems Technical Discussion
    <midrange-l@xxxxxxxxxxxx>
    To:  "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
    Subject:  RE: SQL2XLS in batch program
    Date:  Fri, 17 Mar 2006 10:17:01 -0500
    >Shouldn't an excel template have a different extension? Not that this
    would
    >solve your problem
    >
    >-----Original Message-----
    >From: midrange-l-bounces@xxxxxxxxxxxx
    >[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of JK
    >Sent: Thursday, March 16, 2006 4:51 PM
    >To: 'Midrange Systems Technical Discussion'
    >Subject: RE: SQL2XLS in batch program
    >
    >Bob,
    >
    >  Submitted jobs should work OK. What does the joblog say?
    >
    >  I recall seeing java issue an 'error opening file' message (or
    something
    >like that) when using the FROMXLS parameter. Assumed it was due to some
    >incompatibility in Excel versions because the operator replied with an
    'I'
    >and the job finished correctly.
    >
    >JK
    >
    > > -----Original Message-----
    > > From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
    > > bounces@xxxxxxxxxxxx] On Behalf Of Bob O.
    > > Sent: Thursday, March 16, 2006 1:51 PM
    > > To: midrange-l@xxxxxxxxxxxx
    > > Subject: SQL2XLS in batch program
    > >
    > >    I can't seem to get the SQL2XLS (create a spreadsheet from a
    physical
    > >    file) program to work when running it in batch.  Is there
    something
    > > about
    > >    this program that makes it need to be run interactively?  My CL
    program
    > >    runs all the steps but never creates the spreadsheet.
    > >
    > >
    > >    **NOTE: The following code is inside of a CL program submitted to
    > > QBATCH.
    > >
    > >    /* CALL THE PROGRAM TO LOAD THE FILE ON THE AS400 */
    > >
    > >    CALL  PGM(MYLIB/CS361)
    > >
    > >    SQL2XLSR  SQLSTMT('select * from MYLIB/CS361FIL')  +
    > >
    > >    TOXLS('/Accounting/ExcelFiles/MFG_OVERHEAD_MATERIAL.xls')  +
    > >
    > >    FROMXLS('/Templates/CS361Template.xls')  +
    > >
    > >    COLHDRS(*SQLLABEL)
    >
    >--
    >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.
    >