200 MySQL to DB2 Conversion Guide
LOAD FROM "/opt/ibm/IBMDataMovementTool/migr/data/admin_severity.txt" OF DEL MODIFIED BY
CODEPAGE=1208 COLDEL~ ANYORDER USEDEFAULTS CHARDEL"" DELPRIORITYCHAR NOROWWARNINGS METHOD P
(1,2,3,4,5) MESSAGES "/opt/ibm/IBMDataMovementTool/migr/msg/admin_severity.txt" REPLACE INTO
"ADMIN"."SEVERITY" ( "ID", "TITLE", "NOTES", "ESTDAYS", "AVGDAYS" ) NONRECOVERABLE INDEXING MODE
AUTOSELECT
Number of rows read = 5
Number of rows skipped = 0
Number of rows loaded = 5
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 5
LOAD FROM "/opt/ibm/IBMDataMovementTool/migr/data/admin_owners.txt" OF DEL MODIFIED BY
CODEPAGE=1208 COLDEL~ ANYORDER USEDEFAULTS CHARDEL"" DELPRIORITYCHAR NOROWWARNINGS METHOD P
(1,2,3,4,5,6,7,8,9,10,11) MESSAGES "/opt/ibm/IBMDataMovementTool/migr/msg/admin_owners.txt" REPLACE
INTO "ADMIN"."OWNERS" ( "ID", "FIRSTNAME", "LASTNAME", "EMAIL", "LOCID", "CUBENUM", "PHONENUM",
"LOGINNAME", "PASSWORD", "FAXNUM", "GROUPS" ) NONRECOVERABLE INDEXING MODE AUTOSELECT
Number of rows read = 504
Number of rows skipped = 0
Number of rows loaded = 502
Number of rows rejected = 2
Number of rows deleted = 0
Number of rows committed = 504
SQL3107W There is at least one warning message in the message file.
LOAD FROM "/opt/ibm/IBMDataMovementTool/migr/data/admin_inventory.txt" OF DEL MODIFIED BY
CODEPAGE=1208 COLDEL~ ANYORDER USEDEFAULTS CHARDEL"" DELPRIORITYCHAR NOROWWARNINGS METHOD P
(1,2,3,4,5,6,7,8) MESSAGES "/opt/ibm/IBMDataMovementTool/migr/msg/admin_inventory.txt" REPLACE INTO
"ADMIN"."INVENTORY" ( "ID", "ITEMNAME", "MANUFACTURER", "MODEL", "YEAR", "SERIAL", "LOCID", "OWNERID"
) NONRECOVERABLE INDEXING MODE AUTOSELECT
Number of rows read = 703
Number of rows skipped = 0
Number of rows loaded = 703
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 703
SQL3107W There is at least one warning message in the message file.
LOAD FROM "/opt/ibm/IBMDataMovementTool/migr/data/admin_services.txt" OF DEL MODIFIED BY
CODEPAGE=1208 COLDEL~ ANYORDER USEDEFAULTS CHARDEL"" DELPRIORITYCHAR NOROWWARNINGS METHOD P
(1,2,3,4,5,6,7,8,9) MESSAGES "/opt/ibm/IBMDataMovementTool/migr/msg/admin_services.txt" REPLACE INTO
"ADMIN"."SERVICES" ( "ID", "INVENTID", "DESCRIPTION", "SEVERITY", "SERVICEOWNER", "OPENDATE",
"CLOSEDATE", "TARGETCLOSEDATE", "STATUS" ) NONRECOVERABLE INDEXING MODE AUTOSELECT
Number of rows read = 808
Number of rows skipped = 0
Number of rows loaded = 808
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 808
LOAD FROM "/opt/ibm/IBMDataMovementTool/migr/data/admin_status.txt" OF DEL MODIFIED BY
CODEPAGE=1208 COLDEL~ ANYORDER USEDEFAULTS CHARDEL"" DELPRIORITYCHAR NOROWWARNINGS METHOD P
(1,2,3) MESSAGES "/opt/ibm/IBMDataMovementTool/migr/msg/admin_status.txt" REPLACE INTO
"ADMIN"."STATUS" ( "ID", "TITLE", "NOTES" ) NONRECOVERABLE INDEXING MODE AUTOSELECT
Number of rows read = 7
Number of rows skipped = 0
Number of rows loaded = 7