Hello,

I'm attempting to use LOAD as an on-the-job training task. It's my
first work with DB2, but I've worked with MySQL, so I didn't expect it
to be too different.

I have found some clues about what's not working, but I'm stuck as to
what I should do about it next.

Thanks for your time,

Mark

Here's what I'm trying:

$ db2 -tplrsvz

CONNECT TO DbName USER UserName USING PassWord
;
  Database Connection Information

Database server        = DB2/LINUX 8.2.0
SQL authorization ID   = UserName
Local database alias   = DbName

CREATE TABLE SHAKLEE4.DROPME02 (
 zip_code VARCHAR(5) NOT NULL
, city_name VARCHAR(64) NOT NULL
, area_code CHAR(3) NOT NULL
, time_zone VARCHAR(16) NOT NULL
, utc DECIMAL(3, 1) NOT NULL
, TIME_STAMP varchar(32) NOT NULL
);

DB20000I  The SQL command completed successfully.

CREATE TABLE DROPME02_ET (
 zip_code VARCHAR(5) NOT NULL
, city_name VARCHAR(64) NOT NULL
, area_code CHAR(3) NOT NULL
, time_zone VARCHAR(16) NOT NULL
, utc DECIMAL(3, 1) NOT NULL
, TIME_STAMP varchar(32) NOT NULL
, STAMP_ET TIMESTAMP
, CLOB_ET CLOB(32K)
);

DB20000I  The SQL command completed successfully.

LOAD CLIENT
 FROM "/home/devetl/mark.stafford/zip_codes01-100.tab" OF DEL
 MESSAGES "/home/devetl/mark.stafford/zip_codes01-100.tab.log"
 INSERT INTO DROPME02
 FOR EXCEPTION DROPME02_ET
 NONRECOVERABLE
 INDEXING
 MODE AUTOSELECT
;

SQL3015N  An SQL error "-206" occurred during processing.

CONNECT RESET;
QUIT;

-- zip_codes01-100.tab.log
SQL3015N  An SQL error "-206" occurred during processing.

SQL0206N  "PROTECTIONGRANULARITY" is not valid in the context where it
is
used.  SQLSTATE=42703

-- new entry in db2diag.log
2007-04-21-17.34.22.776571-360 I456441G455        LEVEL: Severe
PID     : 1932                 TID  : 16384       PROC : db2bp
INSTANCE: db2inst1             NODE : 000
APPID   : GA96132B.PEB5.070421232857
FUNCTION: <0>, <0>, <0>, probe:1180
MESSAGE : SQL0206N  "PROTECTIONGRANULARITY" is not valid in the
context where
         it is used.
DATA #1 : String, 12 bytes
sqlucktb.SQC
DATA #2 : String, 44 bytes
Error from Import/Export or Load Processing.

-- sample from tab-delimited zip_codes01-100.tab
00501    Holtsville    631    Eastern -5.0    2006-11-29 00:00:00
00544    Holtsville    631    Eastern -5.0    2006-11-29 00:00:00
00601    Adjuntas    787    Atlantic    -4.0    2006-11-29 00:00:00
00602    Aguada  787    Atlantic    -4.0    2006-11-29 00:00:00
00603    Aguadilla    787    Atlantic    -4.0    2006-11-29 00:00:00
00604    Aguadilla    787    Atlantic    -4.0    2006-11-29 00:00:00
00605    Aguadilla    787    Atlantic    -4.0    2006-11-29 00:00:00
00606    Maricao 787    Atlantic    -4.0    2006-11-29 00:00:00
00610    Anasco  787    Atlantic    -4.0    2006-11-29 00:00:00
00611    Angeles 787    Atlantic    -4.0    2006-11-29 00:00:00