File DBFFDTMP in library *LIBL not found or inline data file missing
From Support
| If you have a question or seek clarification, please call Technical Support. |
[edit]
Problem:
Customer is getting the following error when running the DataExport commands DBTODELIM or DBSQLIFS:
1 records added to member DBFFDTMP in file DBFFDTMP in QTEMP. File DBFFDTMP in library *LIBL not found or inline data file missing.
[edit]
Solution:
It appears that the AS/400 user didn't have the QTEMP library in their library search path. The QTEMP library can be added to the user search path using one of the following methods:
1.) Run the following command from the AS/400 command line to temporarily add QTEMP to the library list: ADDLIBLE QTEMP
2.) Use the CHGJOBD command to change the default library list for the job description attributes for your AS/400 job. Then QTEMP will be added automatically each time you sign on to the AS/400.
- Note: Use the WRKUSRPRF command and display your user profile information to determine your AS/400 job description name.
