Convert a database file in QTEMP to XLS format with the DBEXPXLS or SMTPDB264 command

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

The following error is thrown in the joblog when user specifies QTEMP as the library in the SQL statement when calling DBEXPXLS and converting a file to MS Excel format.

The same failure occurs when they are using the SMTPDB264 command to call DBEXPXLS to convert a file to Excel *XLS format.

The error is: Java errors 00003 occurred while exporting to Excel format. Check the joblog.

Solution:

Because DBEXPXLS uses Java for its data conversion, the user should put temporary files in a temp library instead of QTEMP. The Java runtime QTEMP library is different than the actual AS/400 job library.

Example: Create a library called RJSTEMP to contain temporary work files and move them into RJSTEMP instead of QTEMP before conversion.

This can also be caused if the database doesn't exist in the library specified.