Re: Excel upload to iSeries bombs

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
DSPMSGD RANGE(SQL0901) MSGF(QSQLMSG)
Alludes to the fact that another message in the joblog may be responsible.
Since this is a Client Server job you may have to do
WRKOBJLCK OBJ(ROB) OBJTYPE(*USRPRF)
to find the job which ran this since a simple
WRKUSRJOB USER(ROB)
will not find these C/S jobs.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Reeve Fritchman" <reeve@ltl400.com>
Sent by: midrange-l-admin@midrange.com
08/27/2002 09:34 PM
Please respond to midrange-l


        To:     "Midrange-tech-L@Midrange. Com" <midrange-l@midrange.com>
        cc:
        Fax to:
        Subject:        Excel upload to iSeries bombs


This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
When I try to upload an Excel 2000 spreadsheet using the Excel upload
facility, the process bombs with SQL0901, internal error 3005.  I can save
the spreadsheet as a CSV file and it uploads fine using Client Access
Express.

When I try to download an iSeries table with null values (dates), the
process bombs.

When I download an iSeries table without any null fields, everything works
file.  When I try to upload it, the process bombs.

Sigh...I submitted a PTF seatch on "internal error type 3005" and have
PTF's
coming, but I don't know if that will solve my problem.

I'd be very grateful for any hints...I'm converting client/server system
and
have a lot of spreadsheets to upload.

Thanks,
reeve
--

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.