You can import data that has been saved in an IXF file. Once data is imported into a query window, it can be saved to a database server, exported to a new file, or used for reports. PC/IXF and character mode System/370IXF files are supported.
The Import Data dialog box opens.
The imported data opens in a new query window.
The IXF Messages dialog box displays when you export or import data successfully into an IXF format file.
Field | Description |
---|---|
Messages |
The messages section of the IXF Messages dialog box displays detailed data and process information when importing or exporting from an IXF file. For example, it could provide information about the number of rows that were imported or exported, which rows were rejected, and which data was truncated. The edit box is read-only; however, you can select and copy these messages. |
OK | Click OK to close the dialog box. |
Sample messages | Sample messages are presented below:
The H record in the PC/IXF file has product "DB202.00, date "20011025 time "160300", single CCSID "0" and double CCSID "0". The C record in the PC/IXF file has column name "ID", data type "INTEGER", single CCSID "0", and double CCSID "0" ... The T record in the PC/IXF file has a name "STAFF", qualifier "Q", and source "TEST". ... The application is beginning to export data to file c:\temp.IXF. ... The row 5 is rejected. The data in (1,3) is truncated. The data in (4,3) is truncated ... Number of rows rejected = 1. Number of data truncated = 2. Number of rows exported = 10. ... The application has completed processing. "26" rows were exported from the file c:\temp.IXF. |