ίϝϯτͷ ॻ͖ํʹ͍ͭͯ ͪΐͬͱݴ͍͍ͨ 13೥9݄19೔໦༵೔ 

όον܈Λ Ҡ২ͯ͠Δ࣌ʹ ࢥͬͨࣄ 13೥9݄19೔໦༵೔ 

ҙຯͷແ͍ ίϝϯτ͕ଟ͍ 13೥9݄19೔໦༵೔ 

hoge.sql ---------------------------------------------- -- SCHEMA1 SET INSERT ---------------------------------------------- insert into schema1.table select … 13೥9݄19೔໦༵೔ 

insertͯ͠Δͷ͸ݟΓΌΘ͔Δɻ ͱ͍͏͔ɺSETͯԿʁ ஌Γ͍ͨͷ͸ɺ SCHEMA1.tableʹ Ͳ͏͍͏σʔλΛೖΕ͍ͨͷ͔ 13೥9݄19೔໦༵೔ 

hoge.sql -- 20070222 HOGE YUUSEN LOAD DATA INFILE ‘hoge.csv’ INTO TABLE schema.table; LOAD DATA INFILE ‘web_hoge.csv’ IGNORE INTO TABLE schema.table; LOAD DATA INFILE ‘mob_hoge.csv’ IGNORE INTO TABLE schema.table; 13೥9݄19೔໦༵೔ 

஌Γ͍ͨͷ͸ɺͳͥ”hoge.csv”Λ ༏ઌͯ͠load͢Δඞཁ͕͋Δͷ͔ 13೥9݄19೔໦༵೔ 

hoge.sh DB_NAME=hoge # db2 connect db2 connect to ${DB_NAME} 13೥9݄19೔໦༵೔ 

ݟΓΌΘ͔Δ… 13೥9݄19೔໦༵೔ 

hoge.sh # 2013-09-11 add john doe start … # 2013-09-11 add john doe end 13೥9݄19೔໦༵೔ 

όʔδϣϯ؅ཧγεςϜ࢖͑ʂ 13೥9݄19೔໦༵೔ 

13೥9݄19೔໦༵೔ 

ҙຯͷ͋Δ ίϝϯτͷ ॻ͖ํͱ͸ʁ 13೥9݄19೔໦༵೔ 

1.ίʔυͷҙਤΛॻ͘ 13೥9݄19೔໦༵೔ 

ίϝϯτͱ͸ɺίʔυΛॻ͍͍ͯΔ࣌ʹ ߟ͍͑ͯͨࣄΛಡΈखʹ఻͑Δ ͨΊͷ΋ͷ 13೥9݄19೔໦༵೔ 

ίʔυͷಈ࡞Λͦͷ··ॻ͍͍ͯΔ ͚ͩͰ͸ҙຯ͕ແ͍ 13೥9݄19೔໦༵೔ 

hoge.sql -- 20070222 HOGE YUUSEN LOAD DATA INFILE ‘hoge.csv’ INTO TABLE schema.table; LOAD DATA INFILE ‘web_hoge.csv’ IGNORE INTO TABLE schema.table; LOAD DATA INFILE ‘mob_hoge.csv’ IGNORE INTO TABLE schema.table; 13೥9݄19೔໦༵೔ 

hoge.sql /* * AॲཧޙͷσʔλΛਖ਼ͱͯ͠ѻ͍͍ͨͨΊɺ * hoge.csvΛઌʹload͠ɺAॲཧલͷσʔλͱͯ͠औಘ͞ΕΔ * webɺmobͷσʔλ͸ϩʔυ͠ͳ͍Α͏ʹ͓ͯ͘͠ */ LOAD DATA INFILE ‘hoge.csv’ INTO TABLE schema.table; LOAD DATA INFILE ‘web_hoge.csv’ IGNORE INTO TABLE schema.table; LOAD DATA INFILE ‘mob_hoge.csv’ IGNORE INTO TABLE schema.table; 13೥9݄19೔໦༵೔ 

hoge.sql ---------------------------------------------- -- SCHEMA1 SET INSERT ---------------------------------------------- insert into schema1.table select … 13೥9݄19೔໦༵೔ 

hoge.sql -- Aॲཧલͷड஫৘ใΛऔಘ͢Δ insert into schema1.table select … 13೥9݄19೔໦༵೔ 

Ⅱ.ίʔυ͔Β͙͢ʹ ෼͔Δࣄ͸ॻ͔ͳ͍ 13೥9݄19೔໦༵೔ 

hoge.sh DB_NAME=hoge # db2 connect db2 connect to ${DB_NAME} 13೥9݄19೔໦༵೔ 

Ⅲ.ࣗ෼ͷߟ͑Λ ه࿥͢Δ 13೥9݄19೔໦༵೔ 

# ͜ͷΫϥε͸Ԛ͘ͳ͖ͬͯͯΔ # αϒΫϥε࢖ͬͯ੔ཧͨ͠΄͏͕Αͦ͞͏ 13೥9݄19೔໦༵೔ 

# TODO: john doe # jpgҎ֎ͷϑΥʔϚοτʹ΋ରԠ͢Δ 13೥9݄19೔໦༵೔ 

ίπɿ Կ͕͍ͨ͠ͷ͔Λॻ͘ 13೥9݄19೔໦༵೔ 

ࢀߟɿ Ϧʔμϒϧίʔυ http://www.oreilly.co.jp/ books/9784873115658/ 13೥9݄19೔໦༵೔