DataExport

In This Section

Change authority necessary for a file created via DBTODELIM or DBSQLIFS

Problem: When a file gets created in the IFS, the default ownership is usually set to the person that created the IFS file. How can file ownership be…
Error 1 when calling DBEXPXLS, DBEXPXLS2, or SMTPDB2 to convert a file to XLS

Problem: When you run the DBEXPXLS and DBEXPXLS2 commands, you get the following in the Java error log:Browse : /rjstemp/JAVASTDOUT-RSISLSWKLC-MFS6MF…
SMTP Error When Using DataExport

Problem SMTP error when using DataExport - Keyword PAIRQOUTES or ADDSINGLE Keyword PARIQOUTES not valid for this command Keyword ADDSINGLE not vali…
Exporting iSeries Files to IFS Files with DataExport/400

The following samples show you the syntax for exporting iSeries files to IFS files with DataExport/400. To export the iSeries file QCUSTCDT in the …
DBEXPXLS command fails when submitted to run in batch mode if job queue is not QBATCH

Problem: When the DBEXPXLS command (in RJSEXPORT version 1.31, OS/400 V5R3) is run interactively or submitted to job queue QBATCH it works fine. If …
Convert a Database File in QTEMP to XLS Format

ProblemThe following error is thrown in the joblog when user specifies QTEMP as the library in the SQL statement when calling DBEXPXLS and converting…
Leading Zeros Truncated in CSV Files

Problem: When you open CSV files in Microsoft, they do not retain the leading zeros from DataExport/400. Solution: This is a limitation in Microsof…
DBSQLIFS error: Length or start position is out of range for the string operation

Problem: Customer is getting the following error in the job log when running the DBSQLIFS command to run a query and summarize data and place into an…
001-0019 Error found searching for command java

Problem: Customer is getting the following error when trying to run java commands on their iSeries: qsh: 001-0019 Error found searching for command…
Allowing Users Authority to an IFS directory

Problem: When you create an IFS directory with the MKDIR command on the iSeries, only you can access IFS files in it. You want to change the IFS dire…

In This Section

Change authority necessary for a file created via DBTODELIM or DBSQLIFS

Error 1 when calling DBEXPXLS, DBEXPXLS2, or SMTPDB2 to convert a file to XLS

SMTP Error When Using DataExport

Exporting iSeries Files to IFS Files with DataExport/400

DBEXPXLS command fails when submitted to run in batch mode if job queue is not QBATCH

Convert a Database File in QTEMP to XLS Format

Leading Zeros Truncated in CSV Files

DBSQLIFS error: Length or start position is out of range for the string operation

001-0019 Error found searching for command java

Allowing Users Authority to an IFS directory

+1 800-328-1000

info@helpsystems.com

Cybersecurity

Compliance & Audit Reporting

IT Operations Management

IT Infrastructure Monitoring

Business Intelligence

Document & Forms Management