DB2 graphic QMF Version 8

Importing data

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.

  1. Select File--> Import Data.

    The Import Data dialog box opens.

  2. Select the file you want to import.
  3. Click OK.

    The imported data opens in a new query window.

IXF messages

The IXF Messages dialog box displays when you export or import data successfully into an IXF format file.

Table 51. IXF Import/Export Confirmation
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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004