1. HelpSystems Community
  2. Knowledge Base
  3. Document Management (RJS)
  4. DataExport
  5. Convert a Database File in QTEMP to XLS Format

Convert a Database File in QTEMP to XLS Format

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 Microsoft Excel format:
Java errors 00003 occurred while exporting to Excel format. Check the joblog.
 The same error occurs when using the SMTPDB264 command to call DBEXPXLS to convert a file to Excel *XLS format. 

Solution

Because DBEXPXLS uses Java for its data conversion, the put temporary files in a temp library instead of QTEMP. The Java runtime QTEMP library is different than the actual AS/400 job library.  
 
For example, Create a library called RJSTEMP to contain temporary work files and move them into RJSTEMP instead of QTEMP before conversion.
 
This error can also occur if the database doesn't exist in the library specified.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: July 02, 2020
+1 800-328-1000
[email protected]
Cybersecurity
Compliance & Audit Reporting
IT Operations Management
IT Infrastructure Monitoring
Business Intelligence
Document & Forms Management

Copyright © 2020 HelpSystems