CREATE TABLE "KILLTBS"."KILLERTBS2" (
  "A" INT
) ;

INSERT INTO "KILLTBS"."KILLERTBS2"   ("A") VALUES ( 10 );
INSERT INTO "KILLTBS"."KILLERTBS2"   ("A") VALUES ( 11 );

EXPORT TO
  '%DATA_PATH%\KILLTBS_KILLERTBS21006282393.ixf'
  OF IXF 
  SELECT * FROM "KILLTBS"."KILLERTBS2";

DROP TABLE "KILLTBS"."KILLERTBS2";

CREATE TABLE "KILLTBS"."KILLERTBS2" (
  "A" VARCHAR( 50 )
) 
  IN "TBS";

ALTER TABLE "KILLTBS"."KILLERTBS2"
  DATA CAPTURE NONE
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;

ALTER TABLE "KILLTBS"."KILLERTBS2"
  ACTIVATE NOT LOGGED INITIALLY;

COMMIT;

LOAD CLIENT FROM '%DATA_PATH%\KILLTBS_KILLERTBS21006282393.ixf'
  OF IXF 
  INSERT INTO KILLTBS.KILLERTBS2(
    A
    )
 INDEXING MODE REBUILD 
 ALLOW NO ACCESS;

COMMIT;

SQL3168W  The PC/IXF column specified to be loaded into database column "0" is not compatible with the database column.  Nulls will be inserted