Hi!
Let's say I have a table TABLE 1:
CREATE TABLE TABLE1
(
TAB1_ID BIGINT,
TAB1_NAME VARCHAR(100)
)
which has 10 columns in and from which I do an EXPORT like:
EXPORT TO TABLE1.IXF OF IXF SELECT * FROM TABLE1
Then I have a table TABLE2:
CREATE TABLE TABLE2
(
TAB2_NAME VARCHAR(100)
)
into which I'd like to import TABLE1.IXF, but only TAB1_NAME:
IMPORT FROM TABLE1.IXF OF IXF METHOD N(TAB1_ID, TAB1_NAME) INSERT INTO
TABLE2(TAB2_NAME)
This commands does import all 10 rows, but the values are NULL and there are
no warnings or errors.
Is this supposed to work like this ?
Best regards,
Kovi
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-