M
Member 310024
Guest
The problem is, I am getting an SQLCODE -408,
"new value has wrong data type from column STD_VOL_LENGTH".
I am trying to export a subset of records from a DB2 table (containing VARCHAR fields) in one data-base to the corresponding table in a copy/test database.
I am using QMF.
In DB#1, I use QMF to export data to ...
In DB#2, I use QMF to import data from ...
then, save data as tempxyz
then
INSERT INTO DB#2.tblename
SELECT * FROM tempXYZ
But this fails & it looks like it's because there's a problem with the 2-byte length component of the varchar field.
Has anyone encountered this problem before?
Thanks in advance for any help.
"new value has wrong data type from column STD_VOL_LENGTH".
I am trying to export a subset of records from a DB2 table (containing VARCHAR fields) in one data-base to the corresponding table in a copy/test database.
I am using QMF.
In DB#1, I use QMF to export data to ...
In DB#2, I use QMF to import data from ...
then, save data as tempxyz
then
INSERT INTO DB#2.tblename
SELECT * FROM tempXYZ
But this fails & it looks like it's because there's a problem with the 2-byte length component of the varchar field.
Has anyone encountered this problem before?
Thanks in advance for any help.