はじめに
Oracle Analytics Cloudをいろいろ試すために、Autonomous Data Warehouseサービスを作成すると入っているSHスキーマをもとにしてSHJPスキーマを作成します。※本記事ではAutonomous Data Warehouseサービスの作成済みであることを前提としています。
Autonomous Data Warehouseサービスへのアクセス
SHJPスキーマを作成するため、データベース・アクションを使用します。OCI管理コンソールにログインします。作成済のAutonomous Data Warehouseサービスを開きます。
データベース・アクションをクリックします
SQLの実行
SQLをクリックします
下部にある作成用スクリプトの▼アイコンで展開し、
全て選択してコピーし、データベースアクションのSQLに貼り付けます。すごく多いです。
スクリプトの実行をクリックします。
下部にステータスが表示されます。ひたすら待ちます。
以下、結果が出力されると完了です。
※本記事記載の時点では、7、8分かかりました。
ウォレットファイルのダウンロード
Oracle Analytics Cloud(OAC)から接続するのに必要なウォレットファイルをダウンロードしておきます。Autonomous Data WarehouseサービスのDB接続をクリックします。
ウォレットのダウンロードをクリックします。
パスワードを入力します。ダウンロードをクリックします。
<ADBサービス名>_wallet.zipというファイル名でダウンロードされますので保存しておきます。
作成用スクリプト
作成用スクリプトはこちら
shjp.sql
create user shjp identified by Welcome1234##;
grant dwrole to shjp;
alter user shjp quota unlimited on DATA;
-- create table shjp.channels as select * from sh.channels;
-- create table shjp.costs as select * from sh.costs;
-- create table shjp.countries as select * from sh.countries;
-- create table shjp.customers as select * from sh.customers;
-- create table shjp.products as select * from sh.products;
-- create table shjp.promotions as select * from sh.promotions;
-- create table shjp.sales as select * from sh.sales;
-- create table shjp.times as select * from sh.times;
DROP TABLE "SHJP"."TIMES" PURGE;
CREATE TABLE "SHJP"."TIMES"
( "TIME_ID" DATE NOT NULL ,
"DAY_NAME" VARCHAR2(9 BYTE) COLLATE "USING_NLS_COMP" NOT NULL,
"DAY_NUMBER_IN_WEEK" NUMBER(1,0) NOT NULL ,
"DAY_NUMBER_IN_MONTH" NUMBER(2,0) NOT NULL ,
"CALENDAR_WEEK_NUMBER" NUMBER(2,0) NOT NULL ,
"FISCAL_WEEK_NUMBER" NUMBER(2,0) NOT NULL ,
"WEEK_ENDING_DAY" DATE NOT NULL ,
"WEEK_ENDING_DAY_ID" NUMBER NOT NULL ,
"CALENDAR_MONTH_NUMBER" NUMBER(2,0) NOT NULL ,
"FISCAL_MONTH_NUMBER" NUMBER(2,0) NOT NULL ,
"CALENDAR_MONTH_DESC" VARCHAR2(12 BYTE) COLLATE "USING_NLS_COMP" NOT NULL,
"CALENDAR_MONTH_ID" NUMBER NOT NULL ,
"FISCAL_MONTH_DESC" VARCHAR2(12 BYTE) COLLATE "USING_NLS_COMP" NOT NULL,
"FISCAL_MONTH_ID" NUMBER NOT NULL ,
"DAYS_IN_CAL_MONTH" NUMBER NOT NULL ,
"DAYS_IN_FIS_MONTH" NUMBER NOT NULL ,
"END_OF_CAL_MONTH" DATE NOT NULL ,
"END_OF_FIS_MONTH" DATE NOT NULL ,
"CALENDAR_MONTH_NAME" VARCHAR2(9 BYTE) COLLATE "USING_NLS_COMP" NOT NULL,
"FISCAL_MONTH_NAME" VARCHAR2(9 BYTE) COLLATE "USING_NLS_COMP" NOT NULL,
"CALENDAR_QUARTER_DESC" CHAR(7 BYTE) COLLATE "USING_NLS_COMP" NOT NULL,
"CALENDAR_QUARTER_ID" NUMBER NOT NULL ,
"FISCAL_QUARTER_DESC" CHAR(7 BYTE) COLLATE "USING_NLS_COMP" NOT NULL,
"FISCAL_QUARTER_ID" NUMBER NOT NULL ,
"DAYS_IN_CAL_QUARTER" NUMBER NOT NULL ,
"DAYS_IN_FIS_QUARTER" NUMBER NOT NULL ,
"END_OF_CAL_QUARTER" DATE NOT NULL ,
"END_OF_FIS_QUARTER" DATE NOT NULL ,
"CALENDAR_QUARTER_NUMBER" NUMBER(1,0) NOT NULL ,
"FISCAL_QUARTER_NUMBER" NUMBER(1,0) NOT NULL ,
"CALENDAR_YEAR" NUMBER(4,0) NOT NULL ,
"CALENDAR_YEAR_ID" NUMBER NOT NULL ,
"FISCAL_YEAR" NUMBER(4,0) NOT NULL ,
"FISCAL_YEAR_ID" NUMBER NOT NULL ,
"DAYS_IN_CAL_YEAR" NUMBER NOT NULL ,
"DAYS_IN_FIS_YEAR" NUMBER NOT NULL ,
"END_OF_CAL_YEAR" DATE NOT NULL ,
"END_OF_FIS_YEAR" DATE NOT NULL
) DEFAULT COLLATION "USING_NLS_COMP" ;
ALTER TABLE "SHJP"."TIMES" ADD CONSTRAINT "TIMES_PK" PRIMARY KEY ("TIME_ID") RELY DISABLE;
DROP TABLE "SHJP"."CHANNELS" PURGE;
CREATE TABLE "SHJP"."CHANNELS"
( "CHANNEL_ID" NUMBER NOT NULL,
"CHANNEL_DESC" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CHANNEL_CLASS" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CHANNEL_CLASS_ID" NUMBER NOT NULL,
"CHANNEL_TOTAL" VARCHAR2(13 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CHANNEL_TOTAL_ID" NUMBER NOT NULL
) DEFAULT COLLATION "USING_NLS_COMP" ;
ALTER TABLE "SHJP"."CHANNELS" ADD CONSTRAINT "CHANNELS_PK" PRIMARY KEY ("CHANNEL_ID") RELY DISABLE;
DROP TABLE "SHJP"."COUNTRIES" PURGE;
CREATE TABLE "SHJP"."COUNTRIES"
( "COUNTRY_ID" NUMBER NOT NULL,
"COUNTRY_ISO_CODE" CHAR(2 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"COUNTRY_NAME" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"COUNTRY_SUBREGION" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"COUNTRY_SUBREGION_ID" NUMBER NOT NULL,
"COUNTRY_REGION" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"COUNTRY_REGION_ID" NUMBER NOT NULL,
"COUNTRY_TOTAL" VARCHAR2(11 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"COUNTRY_TOTAL_ID" NUMBER NOT NULL,
"COUNTRY_NAME_HIST" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP"
) DEFAULT COLLATION "USING_NLS_COMP" ;
ALTER TABLE "SHJP"."COUNTRIES" ADD CONSTRAINT "COUNTRIES_PK" PRIMARY KEY ("COUNTRY_ID") RELY DISABLE;
DROP TABLE "SHJP"."PRODUCTS" PURGE;
CREATE TABLE "SHJP"."PRODUCTS"
( "PROD_ID" NUMBER(6,0) NOT NULL ,
"PROD_NAME" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROD_DESC" VARCHAR2(4000 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROD_SUBCATEGORY" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROD_SUBCATEGORY_ID" NUMBER NOT NULL ,
"PROD_SUBCATEGORY_DESC" VARCHAR2(2000 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROD_CATEGORY" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROD_CATEGORY_ID" NUMBER NOT NULL ,
"PROD_CATEGORY_DESC" VARCHAR2(2000 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROD_WEIGHT_CLASS" NUMBER(3,0) NOT NULL ,
"PROD_UNIT_OF_MEASURE" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP",
"PROD_PACK_SIZE" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"SUPPLIER_ID" NUMBER(6,0) NOT NULL ,
"PROD_STATUS" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROD_LIST_PRICE" NUMBER(8,2) NOT NULL ,
"PROD_MIN_PRICE" NUMBER(8,2) NOT NULL ,
"PROD_TOTAL" VARCHAR2(13 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROD_TOTAL_ID" NUMBER NOT NULL ,
"PROD_SRC_ID" NUMBER,
"PROD_EFF_FROM" DATE,
"PROD_EFF_TO" DATE,
"PROD_VALID" VARCHAR2(1 BYTE) COLLATE "USING_NLS_COMP"
) DEFAULT COLLATION "USING_NLS_COMP" ;
ALTER TABLE "SHJP"."PRODUCTS" ADD CONSTRAINT "PRODUCTS_PK" PRIMARY KEY ("PROD_ID") RELY DISABLE;
DROP TABLE "SHJP"."CUSTOMERS" PURGE;
CREATE TABLE "SHJP"."CUSTOMERS"
( "CUST_ID" NUMBER NOT NULL ,
"CUST_FIRST_NAME" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_LAST_NAME" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_GENDER" CHAR(1 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_YEAR_OF_BIRTH" NUMBER(4,0) NOT NULL ,
"CUST_MARITAL_STATUS" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP",
"CUST_STREET_ADDRESS" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_POSTAL_CODE" VARCHAR2(10 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_CITY" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_CITY_ID" NUMBER NOT NULL ,
"CUST_STATE_PROVINCE" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_STATE_PROVINCE_ID" NUMBER NOT NULL ,
"COUNTRY_ID" NUMBER NOT NULL ,
"CUST_MAIN_PHONE_NUMBER" VARCHAR2(25 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_INCOME_LEVEL" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP",
"CUST_CREDIT_LIMIT" NUMBER,
"CUST_EMAIL" VARCHAR2(50 BYTE) COLLATE "USING_NLS_COMP",
"CUST_TOTAL" VARCHAR2(14 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"CUST_TOTAL_ID" NUMBER NOT NULL ,
"CUST_SRC_ID" NUMBER,
"CUST_EFF_FROM" DATE,
"CUST_EFF_TO" DATE,
"CUST_VALID" VARCHAR2(1 BYTE) COLLATE "USING_NLS_COMP"
) DEFAULT COLLATION "USING_NLS_COMP" ;
ALTER TABLE "SHJP"."CUSTOMERS" ADD CONSTRAINT "CUSTOMERS_PK" PRIMARY KEY ("CUST_ID") RELY DISABLE;
ALTER TABLE "SHJP"."CUSTOMERS" ADD CONSTRAINT "CUSTOMERS_COUNTRY_FK" FOREIGN KEY ("COUNTRY_ID") REFERENCES "SHJP"."COUNTRIES" ("COUNTRY_ID") RELY DISABLE;
DROP TABLE "SHJP"."PROMOTIONS" PURGE;
CREATE TABLE "SHJP"."PROMOTIONS"
( "PROMO_ID" NUMBER(6,0) NOT NULL ,
"PROMO_NAME" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROMO_SUBCATEGORY" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROMO_SUBCATEGORY_ID" NUMBER NOT NULL ,
"PROMO_CATEGORY" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROMO_CATEGORY_ID" NUMBER NOT NULL ,
"PROMO_COST" NUMBER(10,2) NOT NULL ,
"PROMO_BEGIN_DATE" DATE NOT NULL ,
"PROMO_END_DATE" DATE NOT NULL ,
"PROMO_TOTAL" VARCHAR2(15 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ,
"PROMO_TOTAL_ID" NUMBER NOT NULL
) DEFAULT COLLATION "USING_NLS_COMP" ;
ALTER TABLE "SHJP"."PROMOTIONS" ADD CONSTRAINT "PROMO_PK" PRIMARY KEY ("PROMO_ID") RELY DISABLE;
DROP TABLE "SHJP"."COSTS" PURGE;
CREATE TABLE "SHJP"."COSTS"
( "PROD_ID" NUMBER NOT NULL ,
"TIME_ID" DATE NOT NULL ,
"PROMO_ID" NUMBER NOT NULL ,
"CHANNEL_ID" NUMBER NOT NULL ,
"UNIT_COST" NUMBER(10,2) NOT NULL ,
"UNIT_PRICE" NUMBER(10,2) NOT NULL
) DEFAULT COLLATION "USING_NLS_COMP" ;
ALTER TABLE "SHJP"."COSTS" ADD CONSTRAINT "COSTS_PROMO_FK" FOREIGN KEY ("PROMO_ID") REFERENCES "SHJP"."PROMOTIONS" ("PROMO_ID") RELY DISABLE;
ALTER TABLE "SHJP"."COSTS" ADD CONSTRAINT "COSTS_CHANNEL_FK" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SHJP"."CHANNELS" ("CHANNEL_ID") RELY DISABLE;
ALTER TABLE "SHJP"."COSTS" ADD CONSTRAINT "COSTS_PRODUCT_FK" FOREIGN KEY ("PROD_ID") REFERENCES "SHJP"."PRODUCTS" ("PROD_ID") RELY DISABLE;
ALTER TABLE "SHJP"."COSTS" ADD CONSTRAINT "COSTS_TIME_FK" FOREIGN KEY ("TIME_ID") REFERENCES "SHJP"."TIMES" ("TIME_ID") RELY DISABLE;
DROP TABLE "SHJP"."SALES" PURGE;
CREATE TABLE "SHJP"."SALES"
( "PROD_ID" NUMBER NOT NULL,
"CUST_ID" NUMBER NOT NULL,
"TIME_ID" DATE NOT NULL,
"CHANNEL_ID" NUMBER NOT NULL,
"PROMO_ID" NUMBER NOT NULL,
"QUANTITY_SOLD" NUMBER(10,2) NOT NULL,
"AMOUNT_SOLD" NUMBER(10,2) NOT NULL
) DEFAULT COLLATION "USING_NLS_COMP" ;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_PROMO_FK" FOREIGN KEY ("PROMO_ID") REFERENCES "SHJP"."PROMOTIONS" ("PROMO_ID") RELY DISABLE;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_PRODUCT_FK" FOREIGN KEY ("PROD_ID") REFERENCES "SHJP"."PRODUCTS" ("PROD_ID") RELY DISABLE;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_CUSTOMER_FK" FOREIGN KEY ("CUST_ID") REFERENCES "SHJP"."CUSTOMERS" ("CUST_ID") RELY DISABLE;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_CHANNEL_FK" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SHJP"."CHANNELS" ("CHANNEL_ID") RELY DISABLE;
ALTER TABLE "SHJP"."SALES" ADD CONSTRAINT "SALES_TIME_FK" FOREIGN KEY ("TIME_ID") REFERENCES "SHJP"."TIMES" ("TIME_ID") RELY DISABLE;
-- #################################################
-- # #
-- # From En To Jp #
-- # #
-- #################################################
-- *************************************************
-- CHANNELS
-- *************************************************
INSERT INTO SHJP.CHANNELS SELECT * FROM SH.CHANNELS;
ALTER TABLE SHJP.CHANNELS MODIFY (
CHANNEL_DESC VARCHAR2(30),
CHANNEL_CLASS VARCHAR2(20),
CHANNEL_TOTAL VARCHAR2(20));
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = 'パートナー', CHANNEL_CLASS = 'その他' WHERE CHANNEL_ID = 2;
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = '直営', CHANNEL_CLASS = '直販' WHERE CHANNEL_ID = 3;
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = 'インターネット', CHANNEL_CLASS = '間接' WHERE CHANNEL_ID = 4;
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = 'カタログ', CHANNEL_CLASS = '間接' WHERE CHANNEL_ID = 5;
UPDATE SHJP.CHANNELS SET CHANNEL_DESC = '電話', CHANNEL_CLASS = '直販' WHERE CHANNEL_ID = 9;
UPDATE SHJP.CHANNELS SET CHANNEL_TOTAL = '全チャネル';
COMMIT;
-- *************************************************
-- CUSTOMERS
-- *************************************************
INSERT INTO SHJP.CUSTOMERS SELECT * FROM SH.CUSTOMERS;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子' ,CUST_LAST_NAME ='増岡' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30781;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博規' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 17448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='ひかり' ,CUST_LAST_NAME ='山野' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 24560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義徳' ,CUST_LAST_NAME ='阿川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='岳' ,CUST_LAST_NAME ='愛川' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 17449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博幸' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 24561;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康子' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 37010;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='加奈' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 23677;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='史子' ,CUST_LAST_NAME ='伊集院' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30787;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真季' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 17454;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳平' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 37899;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義弘' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 43239;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美智子' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 37017;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='今日子' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 44127;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='佳美' ,CUST_LAST_NAME ='宍戸' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 23684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='聡美' ,CUST_LAST_NAME ='柴崎' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 29911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='嘉則' ,CUST_LAST_NAME ='酒井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 43244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香菜' ,CUST_LAST_NAME ='秋山' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 36140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='景子' ,CUST_LAST_NAME ='須藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 43251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='剛史' ,CUST_LAST_NAME ='清水' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 47029;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正平' ,CUST_LAST_NAME ='清水' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 15446;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伸子' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 42367;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敬之' ,CUST_LAST_NAME ='浅見' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 46145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸夫' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 8605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真' ,CUST_LAST_NAME ='相澤' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 49247;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気' ,CUST_LAST_NAME ='大崎' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 36557;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子' ,CUST_LAST_NAME ='津村' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 8604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇斗' ,CUST_LAST_NAME ='田才' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 49236;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='努' ,CUST_LAST_NAME ='田村' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 35446;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='紀之' ,CUST_LAST_NAME ='田村' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 14839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='達哉' ,CUST_LAST_NAME ='筒井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 45669;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='直弼' ,CUST_LAST_NAME ='二見' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 46172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義之' ,CUST_LAST_NAME ='尾崎' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 46173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='琢哉' ,CUST_LAST_NAME ='浜田' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 17506;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伊織' ,CUST_LAST_NAME ='富田' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 21062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博' ,CUST_LAST_NAME ='木下' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 8630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='千鶴' ,CUST_LAST_NAME ='龝山' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 43946;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='治朗' ,CUST_LAST_NAME ='愛川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 2409;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='志哲' ,CUST_LAST_NAME ='愛川' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 27297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩樹' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 34409;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩太' ,CUST_LAST_NAME ='岩手' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 43935;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='冬至' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 2408;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博司' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 27296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='純也' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 8629;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐太郎' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 2404;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='司' ,CUST_LAST_NAME ='金井' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 23737;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲菜' ,CUST_LAST_NAME ='桑内' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 27292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='順平' ,CUST_LAST_NAME ='戸川' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 33522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義啓' ,CUST_LAST_NAME ='広瀬' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 43979;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='貴子' ,CUST_LAST_NAME ='荒井' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 14856;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伸子' ,CUST_LAST_NAME ='嵯峨' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 13987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='千恵' ,CUST_LAST_NAME ='山本' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 21098;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='明充' ,CUST_LAST_NAME ='小沢' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 27320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='慎吾' ,CUST_LAST_NAME ='小林' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 14861;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='菜穂子' ,CUST_LAST_NAME ='松井' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 21086;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美紀' ,CUST_LAST_NAME ='成田' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 13989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義之' ,CUST_LAST_NAME ='西田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 1531;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='結城' ,CUST_LAST_NAME ='西田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 45139;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩二' ,CUST_LAST_NAME ='青山' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 48918;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美貴' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 48938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='桂' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 32683;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆司' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 38906;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伸一' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 17803;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='太陽' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 38911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='まなみ' ,CUST_LAST_NAME ='赤羽' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 18125;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='薫' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 49826;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健二' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 17604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由実' ,CUST_LAST_NAME ='谷口' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 26449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信吾' ,CUST_LAST_NAME ='藤井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 33560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季' ,CUST_LAST_NAME ='栃尾' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕樹' ,CUST_LAST_NAME ='平野' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39787;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='知恵' ,CUST_LAST_NAME ='野間' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 14860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由紀' ,CUST_LAST_NAME ='和田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 27319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信二' ,CUST_LAST_NAME ='龝山' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 26444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘美' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 33555;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康子' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39777;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武雄' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39752;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恭司' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 14864;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='史郎' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 5145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆司' ,CUST_LAST_NAME ='岩橋' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 13986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由希子' ,CUST_LAST_NAME ='菊地' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 21097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='夕子' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='F' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 40638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='次郎' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 1528;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由佳' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 8638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩介' ,CUST_LAST_NAME ='近森' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 33527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='誠司' ,CUST_LAST_NAME ='柴田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 20220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='多香子' ,CUST_LAST_NAME ='小林' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 18136;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤' ,CUST_LAST_NAME ='松井' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 17605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='聡史' ,CUST_LAST_NAME ='松永' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 48939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香' ,CUST_LAST_NAME ='松倉' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 1527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲菜' ,CUST_LAST_NAME ='新藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 8637;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博美' ,CUST_LAST_NAME ='西川' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 33526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='卓也' ,CUST_LAST_NAME ='西脇' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 27322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='慎吾' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 8633;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恒' ,CUST_LAST_NAME ='石原' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 20222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美貴' ,CUST_LAST_NAME ='石野' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 32676;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子' ,CUST_LAST_NAME ='相澤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 33553;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐太郎' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39775;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='三郎' ,CUST_LAST_NAME ='村西' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 26448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='沙織' ,CUST_LAST_NAME ='村尾' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 33559;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公子' ,CUST_LAST_NAME ='大場' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39781;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子' ,CUST_LAST_NAME ='大場' ,CUST_GENDER ='F' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 44524;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美子' ,CUST_LAST_NAME ='大塚' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 48911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真季子' ,CUST_LAST_NAME ='大迫' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 40666;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵美子' ,CUST_LAST_NAME ='丹下' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 23861;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='明良' ,CUST_LAST_NAME ='池田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 42527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='明俊' ,CUST_LAST_NAME ='天童' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 10527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公雄' ,CUST_LAST_NAME ='田巻' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 17638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香' ,CUST_LAST_NAME ='田口' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝司' ,CUST_LAST_NAME ='田畑' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 9369;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雄介' ,CUST_LAST_NAME ='道下' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 42544;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩一' ,CUST_LAST_NAME ='尾崎' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 26505;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武子' ,CUST_LAST_NAME ='富田' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美穂' ,CUST_LAST_NAME ='富田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 36319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='治朗' ,CUST_LAST_NAME ='福島' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 41676;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='平祐' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 42559;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='夕美' ,CUST_LAST_NAME ='愛甲' ,CUST_GENDER ='F' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 46337;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='昌二郎' ,CUST_LAST_NAME ='愛川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 42555;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 35444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 35449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='広喜' ,CUST_LAST_NAME ='伊沢' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 22986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='貴子' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30098;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='賢治' ,CUST_LAST_NAME ='園田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 36320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='平治' ,CUST_LAST_NAME ='横倉' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 50838;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤' ,CUST_LAST_NAME ='近森' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀樹' ,CUST_LAST_NAME ='金子' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 14172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄' ,CUST_LAST_NAME ='高岡' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 1684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇夫' ,CUST_LAST_NAME ='阪谷' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 7911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博隆' ,CUST_LAST_NAME ='鹿野' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 22988;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝信' ,CUST_LAST_NAME ='篠原' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 23860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博' ,CUST_LAST_NAME ='小川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 23864;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大' ,CUST_LAST_NAME ='小林' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 30974;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宣雄' ,CUST_LAST_NAME ='松村' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 48070;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健之' ,CUST_LAST_NAME ='新井' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 45455;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='学' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 4300;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美樹' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 11395;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='多嘉子' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 35450;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由紀' ,CUST_LAST_NAME ='赤羽' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 17630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳司' ,CUST_LAST_NAME ='前田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 9358;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='基弘' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 17629;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 36297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正樹' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 17625;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敏也' ,CUST_LAST_NAME ='谷川' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 36292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='聡美' ,CUST_LAST_NAME ='中山' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 5173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='剛史' ,CUST_LAST_NAME ='中村' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 4297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='次朗' ,CUST_LAST_NAME ='中村' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 11408;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博司' ,CUST_LAST_NAME ='津村' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 22985;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博己' ,CUST_LAST_NAME ='島田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智則' ,CUST_LAST_NAME ='島田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 36322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='久義' ,CUST_LAST_NAME ='藤木' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 11403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆司' ,CUST_LAST_NAME ='内野' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 10530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恭司' ,CUST_LAST_NAME ='龍野' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 23856;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由実' ,CUST_LAST_NAME ='阿川' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 42522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博己' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 17633;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆夫' ,CUST_LAST_NAME ='愛光' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 42526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='賢治' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30086;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香菜' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 24745;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公子' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 10526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公子' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 17637;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和彦' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 5172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='悠太' ,CUST_LAST_NAME ='越智' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 36296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='草子' ,CUST_LAST_NAME ='紀藤' ,CUST_GENDER ='F' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 43407;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美保' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 4296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正路' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 11407;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勲' ,CUST_LAST_NAME ='鯉沼' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 29220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省吾' ,CUST_LAST_NAME ='荒井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 42553;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='志哲' ,CUST_LAST_NAME ='佐々原' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 37025;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='竜也' ,CUST_LAST_NAME ='佐藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 1717;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸人' ,CUST_LAST_NAME ='山崎' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 7938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亮太' ,CUST_LAST_NAME ='山田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 45291;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美智子' ,CUST_LAST_NAME ='小松田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 20403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季' ,CUST_LAST_NAME ='照屋' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 27514;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='深雪' ,CUST_LAST_NAME ='新田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 7939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳司' ,CUST_LAST_NAME ='進藤' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 37014;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気' ,CUST_LAST_NAME ='杉崎' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 1716;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊太' ,CUST_LAST_NAME ='成田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 44444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄' ,CUST_LAST_NAME ='西山' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 26630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義男' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 45295;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀樹' ,CUST_LAST_NAME ='川野' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 13297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='誠司' ,CUST_LAST_NAME ='大崎' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 20407;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='結城' ,CUST_LAST_NAME ='大塚' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 26606;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良子' ,CUST_LAST_NAME ='中口' ,CUST_GENDER ='F' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 33716;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝司' ,CUST_LAST_NAME ='中森' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 48222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='茂' ,CUST_LAST_NAME ='中川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 32855;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正子' ,CUST_LAST_NAME ='田口' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 45319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香里' ,CUST_LAST_NAME ='田村' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 32859;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='ゆかり' ,CUST_LAST_NAME ='田村' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 31988;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀人' ,CUST_LAST_NAME ='田畑' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 45321;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勲' ,CUST_LAST_NAME ='杜' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 2425;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美' ,CUST_LAST_NAME ='藤田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 48256;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和彦' ,CUST_LAST_NAME ='平尾' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 23144;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='北野' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 44449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真美' ,CUST_LAST_NAME ='阿川' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 39062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆夫' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 14173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝幸' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 21284;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博夫' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 50839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='夏実' ,CUST_LAST_NAME ='松村' ,CUST_GENDER ='F' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 10584;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='重徳' ,CUST_LAST_NAME ='菅' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 14140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐子' ,CUST_LAST_NAME ='村上' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義男' ,CUST_LAST_NAME ='田川' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 19724;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='直樹' ,CUST_LAST_NAME ='木内' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 19526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='泰子' ,CUST_LAST_NAME ='澤藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 26638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='琢哉' ,CUST_LAST_NAME ='阿川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 26626;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='山信' ,CUST_LAST_NAME ='愛甲' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 32860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊之' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 13298;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大樹' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 26605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='仁' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 14145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='菜穂子' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 21256;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='朋美' ,CUST_LAST_NAME ='伊澤' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 31986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆裕' ,CUST_LAST_NAME ='井上' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 19530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='静江' ,CUST_LAST_NAME ='宇津木' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 13301;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由香里' ,CUST_LAST_NAME ='横田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 20395;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博己' ,CUST_LAST_NAME ='近森' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 44442;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩太' ,CUST_LAST_NAME ='古橋' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 48220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季' ,CUST_LAST_NAME ='佐竹' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 10868;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健治' ,CUST_LAST_NAME ='山下' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 39975;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美弥子' ,CUST_LAST_NAME ='山田' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 25753;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那' ,CUST_LAST_NAME ='山田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 32863;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='公子' ,CUST_LAST_NAME ='松雄' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 31985;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由起子' ,CUST_LAST_NAME ='新場' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 26634;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳子' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 33744;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大輔' ,CUST_LAST_NAME ='石原' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 45479;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='さやか' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 20394;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='洋二' ,CUST_LAST_NAME ='浅見' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 38220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 7070;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐未' ,CUST_LAST_NAME ='相沢' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 45318;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和' ,CUST_LAST_NAME ='大場' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 19527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='岳都' ,CUST_LAST_NAME ='大林' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 26631;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='瑞穂' ,CUST_LAST_NAME ='中谷' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 39086;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亮一' ,CUST_LAST_NAME ='中嶋' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 19522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良規' ,CUST_LAST_NAME ='中野' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 22292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩美' ,CUST_LAST_NAME ='堤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 29403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐太郎' ,CUST_LAST_NAME ='田口' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 3606;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='圭生' ,CUST_LAST_NAME ='藤井' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 28527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香里' ,CUST_LAST_NAME ='藤澤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 16938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気' ,CUST_LAST_NAME ='福島' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 4474;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵介' ,CUST_LAST_NAME ='平塚' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 41859;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='結美' ,CUST_LAST_NAME ='木村' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 10716;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='夕美' ,CUST_LAST_NAME ='鈴木' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 35606;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由紀' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 22296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='圭生' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 7222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信二' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 14333;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美樹' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='F' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 9893;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆史' ,CUST_LAST_NAME ='愛甲' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 13449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='安重' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 11136;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='有三' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 16070;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='慎吾' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 9839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健之' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 50893;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智人' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 4450;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美子' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 16939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='晴美' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 35631;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝司' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 4455;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤夫' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 11565;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 29394;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵一' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 49133;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康則' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 16911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利明' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 23171;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 30283;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敏弘' ,CUST_LAST_NAME ='宇木' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 41852;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='景子' ,CUST_LAST_NAME ='加藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 11191;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='昌美' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 9838;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='吉春' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 42715;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信吾' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 3605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕太' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 10715;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='佐知子' ,CUST_LAST_NAME ='橋本' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 10683;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康一郎' ,CUST_LAST_NAME ='近藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 35626;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='梓' ,CUST_LAST_NAME ='近藤' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 36514;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='なつみ' ,CUST_LAST_NAME ='金井' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 28526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='静香' ,CUST_LAST_NAME ='金子' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 48251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇樹' ,CUST_LAST_NAME ='月森' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 23139;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='後藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 4479;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亜由美' ,CUST_LAST_NAME ='高橋' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 35630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='るり子' ,CUST_LAST_NAME ='高田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 29395;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利子' ,CUST_LAST_NAME ='佐藤' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 22297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正樹' ,CUST_LAST_NAME ='佐藤' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 28522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='広美' ,CUST_LAST_NAME ='笹塚' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 35634;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='好子' ,CUST_LAST_NAME ='三室' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 41855;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省太' ,CUST_LAST_NAME ='山下' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 48244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正義' ,CUST_LAST_NAME ='山口' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 44448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='憲次' ,CUST_LAST_NAME ='山口' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 48226;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='知子' ,CUST_LAST_NAME ='山田' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 16062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='陽介' ,CUST_LAST_NAME ='鹿野' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 23172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='佳美' ,CUST_LAST_NAME ='守村' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 30284;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀樹' ,CUST_LAST_NAME ='守村' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 35605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊一' ,CUST_LAST_NAME ='手塚' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 47431;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信夫' ,CUST_LAST_NAME ='勝山' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 50986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義彦' ,CUST_LAST_NAME ='小松田' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 38367;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆史' ,CUST_LAST_NAME ='小松田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 50988;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='達也' ,CUST_LAST_NAME ='新場' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 7251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='達哉' ,CUST_LAST_NAME ='新藤' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 14363;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='岳' ,CUST_LAST_NAME ='森' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 38792;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由起子' ,CUST_LAST_NAME ='森本' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 13479;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伊織' ,CUST_LAST_NAME ='進藤' ,CUST_GENDER ='F' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 34812;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄' ,CUST_LAST_NAME ='西田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 32140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博美' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 30147;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由紀子' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 13474;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敬一' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 44625;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='英二' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 4180;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博幸' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 25062;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亜衣' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 32173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='赤羽' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 40986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和彦' ,CUST_LAST_NAME ='赤羽' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 38847;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='洋' ,CUST_LAST_NAME ='赤星' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 7244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='山信' ,CUST_LAST_NAME ='浅見' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 12605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='薫' ,CUST_LAST_NAME ='浅見' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 19715;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='仁' ,CUST_LAST_NAME ='浅見' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 41863;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕大' ,CUST_LAST_NAME ='浅見' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 34753;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='紀夫' ,CUST_LAST_NAME ='浅野' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 50145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='節子' ,CUST_LAST_NAME ='前田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 138;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美樹' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 38914;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美津子' ,CUST_LAST_NAME ='相沢' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 19683;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美子' ,CUST_LAST_NAME ='相澤' ,CUST_GENDER ='F' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 26795;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 38613;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='涼太' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 7220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='吉春' ,CUST_LAST_NAME ='大場' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 41860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='竜太' ,CUST_LAST_NAME ='谷口' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 40988;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='静江' ,CUST_LAST_NAME ='池田' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 13450;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='哲郎' ,CUST_LAST_NAME ='池田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 30080;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義教' ,CUST_LAST_NAME ='中村' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 193;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義弘' ,CUST_LAST_NAME ='中谷' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 8133;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='ひろみ' ,CUST_LAST_NAME ='中島' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 25938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季' ,CUST_LAST_NAME ='津村' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 44604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜' ,CUST_LAST_NAME ='田村' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 13455;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敏弘' ,CUST_LAST_NAME ='田中' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 25911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲子' ,CUST_LAST_NAME ='田中' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 40985;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由起子' ,CUST_LAST_NAME ='田島' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 12606;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='静江' ,CUST_LAST_NAME ='杜' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 25939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='航' ,CUST_LAST_NAME ='湯浅' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 31296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='輝久' ,CUST_LAST_NAME ='藤井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47555;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='岳朗' ,CUST_LAST_NAME ='藤田' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 30680;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕彦' ,CUST_LAST_NAME ='藤田' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='純一' ,CUST_LAST_NAME ='迫田' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 28676;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利明' ,CUST_LAST_NAME ='迫田' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 6430;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='富田' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 9986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='環' ,CUST_LAST_NAME ='平岡' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47559;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='穂波' ,CUST_LAST_NAME ='平岡' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 22448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='平河' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 34061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真' ,CUST_LAST_NAME ='堀' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 41161;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='修一' ,CUST_LAST_NAME ='木村' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 18839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='るり子' ,CUST_LAST_NAME ='野間' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 38394;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美' ,CUST_LAST_NAME ='野澤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 4202;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏' ,CUST_LAST_NAME ='蓮見' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 41140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏' ,CUST_LAST_NAME ='和田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 9140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='知子' ,CUST_LAST_NAME ='龝山' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 16251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='平治' ,CUST_LAST_NAME ='阿川' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 23363;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲菜' ,CUST_LAST_NAME ='愛光' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 44630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良平' ,CUST_LAST_NAME ='愛甲' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3947;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇喜' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 9987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康平' ,CUST_LAST_NAME ='安藤' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 4672;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雄二' ,CUST_LAST_NAME ='伊沢' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 22449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇斗' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 43752;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正樹' ,CUST_LAST_NAME ='伊澤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 47530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐子' ,CUST_LAST_NAME ='鵜木' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 45514;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘治' ,CUST_LAST_NAME ='園田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3788;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄' ,CUST_LAST_NAME ='岸本' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 4313;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='崇行' ,CUST_LAST_NAME ='古田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 16222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真二' ,CUST_LAST_NAME ='高橋' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47553;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅人' ,CUST_LAST_NAME ='佐々木' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 37526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='るり子' ,CUST_LAST_NAME ='佐々木' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 13091;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和枝' ,CUST_LAST_NAME ='佐藤' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 9989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='貴子' ,CUST_LAST_NAME ='山口' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 38395;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='慶徳' ,CUST_LAST_NAME ='山崎' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 16244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真季' ,CUST_LAST_NAME ='若島' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 2918;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大助' ,CUST_LAST_NAME ='守村' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='治雄' ,CUST_LAST_NAME ='小林' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 10017;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='速夫' ,CUST_LAST_NAME ='松田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 31297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜' ,CUST_LAST_NAME ='森' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='結美' ,CUST_LAST_NAME ='森本' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 37527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博' ,CUST_LAST_NAME ='瀬戸' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 46684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='平治' ,CUST_LAST_NAME ='清水' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3795;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='未歩' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 28683;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤夫' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 22473;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='冴子' ,CUST_LAST_NAME ='石原' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 38403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博美' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 31292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='瑞貴' ,CUST_LAST_NAME ='石野' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 39283;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博英' ,CUST_LAST_NAME ='赤羽' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 25061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳司' ,CUST_LAST_NAME ='赤羽' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 32172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子' ,CUST_LAST_NAME ='仙道' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 44629;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='伸子' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3936;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 4291;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健二' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 16220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='F' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 25121;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良人' ,CUST_LAST_NAME ='中森' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 37522;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宣雄' ,CUST_LAST_NAME ='中村' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 44633;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正巳' ,CUST_LAST_NAME ='田村' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 3980;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='喜美雄' ,CUST_LAST_NAME ='田嶋' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3783;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮' ,CUST_LAST_NAME ='渡辺' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 2911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮' ,CUST_LAST_NAME ='藤井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 10022;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香奈' ,CUST_LAST_NAME ='尾崎' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 34911;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='深雪' ,CUST_LAST_NAME ='武石' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 50300;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆之' ,CUST_LAST_NAME ='平塚' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 7411;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大' ,CUST_LAST_NAME ='北川' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 18986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆久' ,CUST_LAST_NAME ='矢田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 50320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='典子' ,CUST_LAST_NAME ='鈴木' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 34060;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='啓太' ,CUST_LAST_NAME ='龝山' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 6555;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='啓二' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 27889;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博史' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 31444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='茂子' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 23226;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 23237;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='祐樹' ,CUST_LAST_NAME ='宇木' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 6530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='啓祐' ,CUST_LAST_NAME ='岡山' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 28700;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='紀子' ,CUST_LAST_NAME ='海老坂' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 12783;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子' ,CUST_LAST_NAME ='丸山' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 18145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由美' ,CUST_LAST_NAME ='岩崎' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 37701;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝子' ,CUST_LAST_NAME ='吉澤' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 5684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香奈' ,CUST_LAST_NAME ='近藤' ,CUST_GENDER ='F' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 40350;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='仁子' ,CUST_LAST_NAME ='金子' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 43905;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良典' ,CUST_LAST_NAME ='原' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 19017;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='啓之' ,CUST_LAST_NAME ='高岡' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 43910;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武' ,CUST_LAST_NAME ='坂田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 11910;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='三重' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 19022;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='直子' ,CUST_LAST_NAME ='山崎' ,CUST_GENDER ='F' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 13642;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雄二' ,CUST_LAST_NAME ='手塚' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 23179;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇斗' ,CUST_LAST_NAME ='深津' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 50331;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇次' ,CUST_LAST_NAME ='須藤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 25220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆夫' ,CUST_LAST_NAME ='瀬戸' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 32331;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='光輝' ,CUST_LAST_NAME ='清水' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 21605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='実菜子' ,CUST_LAST_NAME ='清水' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 50322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健吾' ,CUST_LAST_NAME ='西田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 22478;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='赤羽' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 50297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美由紀' ,CUST_LAST_NAME ='千田' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 40297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='英二' ,CUST_LAST_NAME ='川鍋' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 50319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='泰子' ,CUST_LAST_NAME ='泉' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 12782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='基樹' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 6560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='寛之' ,CUST_LAST_NAME ='相澤' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 13671;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真' ,CUST_LAST_NAME ='相澤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 31448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省太' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 41173;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 9145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='靖夫' ,CUST_LAST_NAME ='滝川' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 40292;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='希' ,CUST_LAST_NAME ='中田' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 31669;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵一' ,CUST_LAST_NAME ='田原' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 6526;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆平' ,CUST_LAST_NAME ='渡辺' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 31957;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸弘' ,CUST_LAST_NAME ='島' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 1210;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='今日子' ,CUST_LAST_NAME ='内田' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 18987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄' ,CUST_LAST_NAME ='波多野' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 23201;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='めぐみ' ,CUST_LAST_NAME ='馬場' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 34939;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀人' ,CUST_LAST_NAME ='平河' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 49449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気' ,CUST_LAST_NAME ='龝山' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 6561;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸男' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 13672;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='幸男' ,CUST_LAST_NAME ='安藤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 31449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='照子' ,CUST_LAST_NAME ='安藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 6553;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武志' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 50296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='道徳' ,CUST_LAST_NAME ='臼井' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 40296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆人' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 6527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='景子' ,CUST_LAST_NAME ='桑内' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 41172;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美貴' ,CUST_LAST_NAME ='古橋' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 34938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='香織' ,CUST_LAST_NAME ='今田' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 21604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='多美子' ,CUST_LAST_NAME ='佐竹' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 31946;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='英敏' ,CUST_LAST_NAME ='佐竹' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 31979;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='佐藤' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 18989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='友里' ,CUST_LAST_NAME ='佐藤' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 3070;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳一' ,CUST_LAST_NAME ='坂田' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 10181;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利子' ,CUST_LAST_NAME ='山岸' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 15527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真美子' ,CUST_LAST_NAME ='山崎' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 30605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮' ,CUST_LAST_NAME ='山田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 15531;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮' ,CUST_LAST_NAME ='山本' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47391;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮' ,CUST_LAST_NAME ='寺西' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 9300;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮' ,CUST_LAST_NAME ='柴崎' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47347;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正路' ,CUST_LAST_NAME ='秋山' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 6158;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏樹' ,CUST_LAST_NAME ='所' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 9296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏樹' ,CUST_LAST_NAME ='西脇' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 35100;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝信' ,CUST_LAST_NAME ='青山' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 34238;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良太' ,CUST_LAST_NAME ='青森' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 28017;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='竜也' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 34243;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='由衣' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 2221;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真幸' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 9331;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雄一郎' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 34219;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='千輔' ,CUST_LAST_NAME ='石野' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 15554;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亮子' ,CUST_LAST_NAME ='石野' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 19010;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='政美' ,CUST_LAST_NAME ='石野' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 37677;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='桂' ,CUST_LAST_NAME ='赤羽' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 12788;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵美' ,CUST_LAST_NAME ='仙道' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 46861;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='拓哉' ,CUST_LAST_NAME ='仙道' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 47750;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕子' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 38589;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵子' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 31478;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='理麻' ,CUST_LAST_NAME ='大塚' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 31473;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊' ,CUST_LAST_NAME ='池田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 15528;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宗一' ,CUST_LAST_NAME ='中森' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47358;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='多嘉子' ,CUST_LAST_NAME ='長谷川' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47269;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良知' ,CUST_LAST_NAME ='渡辺' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 6169;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='直樹' ,CUST_LAST_NAME ='藤村' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 43061;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義則' ,CUST_LAST_NAME ='八代' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 46840;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='学' ,CUST_LAST_NAME ='富田' ,CUST_GENDER ='M' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 3951;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智成' ,CUST_LAST_NAME ='武岡' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 46860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='久' ,CUST_LAST_NAME ='武藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47280;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵理' ,CUST_LAST_NAME ='伏見' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47313;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵子' ,CUST_LAST_NAME ='本郷' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 30604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊太郎' ,CUST_LAST_NAME ='木ノ内' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 43937;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='愛川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 46864;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳正' ,CUST_LAST_NAME ='安部' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 25244;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='武志' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 49454;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='実菜子' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47014;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='奈美' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 47749;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='行夫' ,CUST_LAST_NAME ='井上' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 18140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信広' ,CUST_LAST_NAME ='岐阜' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 25251;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='千代' ,CUST_LAST_NAME ='境' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 43938;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信広' ,CUST_LAST_NAME ='戸川' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 47025;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義徳' ,CUST_LAST_NAME ='鯉沼' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 9297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅人' ,CUST_LAST_NAME ='江尻' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 43060;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良平' ,CUST_LAST_NAME ='高田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 46839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那' ,CUST_LAST_NAME ='佐藤' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 27140;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那' ,CUST_LAST_NAME ='秋葉' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 34250;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩一' ,CUST_LAST_NAME ='須藤' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 39604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘樹' ,CUST_LAST_NAME ='石井' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='憲一' ,CUST_LAST_NAME ='川久保' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 2227;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='川鍋' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 5840;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇気' ,CUST_LAST_NAME ='大崎' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 27197;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義則' ,CUST_LAST_NAME ='大坪' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30752;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='明貴' ,CUST_LAST_NAME ='丹下' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 48763;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信雄' ,CUST_LAST_NAME ='田村' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 4987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤志' ,CUST_LAST_NAME ='浜田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 12097;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子' ,CUST_LAST_NAME ='野澤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 49633;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='春都' ,CUST_LAST_NAME ='鈴木' ,CUST_GENDER ='M' ,CUST_CITY ='東京' ,CUST_STATE_PROVINCE ='東京' WHERE CUST_ID = 20966;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和弘' ,CUST_LAST_NAME ='澤藤' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 24523;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘樹' ,CUST_LAST_NAME ='龝山' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 16236;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='薫' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 49637;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='和弘' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 6749;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正子' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 24527;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩子' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 21782;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美穂子' ,CUST_LAST_NAME ='安西' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 40448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良一' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 10208;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅人' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 27986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘治' ,CUST_LAST_NAME ='安達' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 49604;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='玲菜' ,CUST_LAST_NAME ='安藤' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 49605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='まどか' ,CUST_LAST_NAME ='安藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 28010;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大亮' ,CUST_LAST_NAME ='伊集院' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 9322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='伊東' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 20910;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='拓也' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 28022;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='まどか' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 21777;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美保' ,CUST_LAST_NAME ='奥村' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 21787;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳江' ,CUST_LAST_NAME ='横沢' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 28899;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='信治' ,CUST_LAST_NAME ='亀貝' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 14684;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='吉春' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 40473;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='辰也' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 9319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕子' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 9320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省吾' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 45987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='義啓' ,CUST_LAST_NAME ='近藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3098;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇樹' ,CUST_LAST_NAME ='見学' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 10209;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='紀之' ,CUST_LAST_NAME ='高岡' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 27987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='大助' ,CUST_LAST_NAME ='佐々原' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 45989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='鉄也' ,CUST_LAST_NAME ='佐々木' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 3100;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅音' ,CUST_LAST_NAME ='斎藤' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 8448;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美那' ,CUST_LAST_NAME ='細田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 15560;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='みのり' ,CUST_LAST_NAME ='三重' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 22670;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正直' ,CUST_LAST_NAME ='山岸' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 21781;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳正' ,CUST_LAST_NAME ='山口' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 40449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敦子' ,CUST_LAST_NAME ='篠原' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 8449;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='芳正' ,CUST_LAST_NAME ='小松田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 15561;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敏也' ,CUST_LAST_NAME ='松井' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 27989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='俊雄' ,CUST_LAST_NAME ='新井' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 39605;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恭司' ,CUST_LAST_NAME ='進藤' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 27145;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='聡史' ,CUST_LAST_NAME ='須藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 40478;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美由紀' ,CUST_LAST_NAME ='須藤' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 33367;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='久美子' ,CUST_LAST_NAME ='青山' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 8454;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='みのり' ,CUST_LAST_NAME ='青山' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 2223;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美里' ,CUST_LAST_NAME ='青木' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 40444;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美季' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 15556;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 5839;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亜由美' ,CUST_LAST_NAME ='石川' ,CUST_GENDER ='F' ,CUST_CITY ='北九州' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 12950;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智亜子' ,CUST_LAST_NAME ='石野' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 49629;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='裕子' ,CUST_LAST_NAME ='石野' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 1065;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='省吾' ,CUST_LAST_NAME ='千田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 4989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正樹' ,CUST_LAST_NAME ='川鍋' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 12099;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀人' ,CUST_LAST_NAME ='川野' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 12069;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智人' ,CUST_LAST_NAME ='浅見' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 30777;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='篤子' ,CUST_LAST_NAME ='浅見' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 11222;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='優大' ,CUST_LAST_NAME ='浅野' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 31;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='利子' ,CUST_LAST_NAME ='相場' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 24528;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝久' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 24556;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='康平' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 31666;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宏' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 253;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='薫' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 1018;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美樹' ,CUST_LAST_NAME ='村上' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 49630;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='孝之' ,CUST_LAST_NAME ='大場' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 36987;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀人' ,CUST_LAST_NAME ='沢藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 24554;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='秀樹' ,CUST_LAST_NAME ='池田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 394;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恵子' ,CUST_LAST_NAME ='池田' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 101624;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美菜子' ,CUST_LAST_NAME ='池田' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 102351;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='まどか' ,CUST_LAST_NAME ='中川' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 100579;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='宅磨' ,CUST_LAST_NAME ='津村' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 103585;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='頼次' ,CUST_LAST_NAME ='佃' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 103505;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='茂子' ,CUST_LAST_NAME ='田中' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 100771;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真季' ,CUST_LAST_NAME ='田中' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 311;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='今日子' ,CUST_LAST_NAME ='田中' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 1093;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='重敏' ,CUST_LAST_NAME ='田中' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 865;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='重敏' ,CUST_LAST_NAME ='湯浅' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 756;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='弘樹' ,CUST_LAST_NAME ='八田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 278;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='良成' ,CUST_LAST_NAME ='平岡' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 25047;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敦子' ,CUST_LAST_NAME ='平岡' ,CUST_GENDER ='F' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 50518;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝信' ,CUST_LAST_NAME ='北川' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 18296;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='靖夫' ,CUST_LAST_NAME ='箕浦' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 18320;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='剛史' ,CUST_LAST_NAME ='木下' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 530;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='清次' ,CUST_LAST_NAME ='野澤' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 925;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='晴美' ,CUST_LAST_NAME ='鈴木' ,CUST_GENDER ='F' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 11220;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄' ,CUST_LAST_NAME ='鈴木' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 143;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='尚美' ,CUST_LAST_NAME ='龝山' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 481;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='正人' ,CUST_LAST_NAME ='阿部' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 803;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅之' ,CUST_LAST_NAME ='愛川' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 25003;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='順子' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='F' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 1035;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='亮子' ,CUST_LAST_NAME ='伊藤' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 5860;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='久美子' ,CUST_LAST_NAME ='井上' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 25058;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='歩' ,CUST_LAST_NAME ='河内' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 18319;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='真澄' ,CUST_LAST_NAME ='丸山' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 36986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='美奈' ,CUST_LAST_NAME ='岸本' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 5861;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敬男' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 16247;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅史' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 49638;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智弘' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 18297;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='達哉' ,CUST_LAST_NAME ='吉田' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 16280;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博' ,CUST_LAST_NAME ='橋本' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 5864;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='隆之' ,CUST_LAST_NAME ='戸田' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 403;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='洋二' ,CUST_LAST_NAME ='佐竹' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 88;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='誉之' ,CUST_LAST_NAME ='三露' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 425;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='智慧次' ,CUST_LAST_NAME ='篠原' ,CUST_GENDER ='M' ,CUST_CITY ='名古屋' ,CUST_STATE_PROVINCE ='愛知' WHERE CUST_ID = 4986;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='淳一' ,CUST_LAST_NAME ='篠塚' ,CUST_GENDER ='M' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 12096;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='敬之' ,CUST_LAST_NAME ='秋山' ,CUST_GENDER ='M' ,CUST_CITY ='福岡' ,CUST_STATE_PROVINCE ='福岡' WHERE CUST_ID = 19208;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='ゆり子' ,CUST_LAST_NAME ='小杉' ,CUST_GENDER ='F' ,CUST_CITY ='横浜' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 18322;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勇樹' ,CUST_LAST_NAME ='石野' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 36989;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='健司' ,CUST_LAST_NAME ='赤星' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 197;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='浩子' ,CUST_LAST_NAME ='折田' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 168;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='勝次' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 614;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='雅音' ,CUST_LAST_NAME ='相川' ,CUST_GENDER ='M' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 410;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='博隆' ,CUST_LAST_NAME ='相沢' ,CUST_GENDER ='M' ,CUST_CITY ='京都' ,CUST_STATE_PROVINCE ='京都' WHERE CUST_ID = 978;
UPDATE SHJP.CUSTOMERS SET CUST_FIRST_NAME ='恭子' ,CUST_LAST_NAME ='足立' ,CUST_GENDER ='F' ,CUST_CITY ='川崎' ,CUST_STATE_PROVINCE ='神奈川' WHERE CUST_ID = 684;
UPDATE SHJP.CUSTOMERS SET CUST_MARITAL_STATUS = '既婚' WHERE CUST_MARITAL_STATUS = 'married';
UPDATE SHJP.CUSTOMERS SET CUST_MARITAL_STATUS = '独身' WHERE CUST_MARITAL_STATUS = 'single';
UPDATE SHJP.CUSTOMERS SET CUST_TOTAL = '全顧客';
COMMIT;
-- *************************************************
-- COUNTIRES
-- *************************************************
INSERT INTO SHJP.COUNTRIES SELECT * FROM SH.COUNTRIES;
COMMIT;
-- *************************************************
-- PRODUCTS
-- *************************************************
INSERT INTO SHJP.PRODUCTS SELECT * FROM SH.PRODUCTS;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '5メガ・ピクセル デジタルカメラ', PROD_DESC = '5メガ・ピクセル デジタルカメラ' WHERE PROD_ID = 13;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'TVチューナー付き17インチ液晶ディスプレイ', PROD_DESC = 'TVチューナー付き17インチ液晶ディスプレイ' WHERE PROD_ID = 14;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'Envoy 256MB - 40GB', PROD_DESC = 'Envoy 256MB - 40GB' WHERE PROD_ID = 15;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'Y Box', PROD_DESC = 'Y Box' WHERE PROD_ID = 16;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '3.5インチ デジタルビデオ・レコーダー', PROD_DESC = '3.5インチ デジタルビデオ・レコーダー' WHERE PROD_ID = 17;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'Envoy Ambassador', PROD_DESC = 'Envoy Ambassador' WHERE PROD_ID = 18;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'ノートPCキャリーケース', PROD_DESC = 'ノートPCキャリーケース' WHERE PROD_ID = 19;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD AVプレイヤー ホームシアター・パッケージ', PROD_DESC = 'DVD AVプレイヤー ホームシアター・パッケージ' WHERE PROD_ID = 20;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '18インチ フラットパネル・モニタ', PROD_DESC = '18インチ フラットパネル・モニタ' WHERE PROD_ID = 21;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付けキーボード', PROD_DESC = '外付けキーボード' WHERE PROD_ID = 22;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付け106キーボード', PROD_DESC = '外付け106キーボード' WHERE PROD_ID = 23;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'PCMCIA データ通信カード', PROD_DESC = 'PCMCIA データ通信カード' WHERE PROD_ID = 24;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '128MB USB メモリ', PROD_DESC = '128MB USB メモリ' WHERE PROD_ID = 25;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '256MB USB メモリ', PROD_DESC = '256MB USB メモリ' WHERE PROD_ID = 26;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'マルチメディア・スピーカー', PROD_DESC = 'マルチメディア・スピーカー' WHERE PROD_ID = 27;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'Unix/Windows 1ユーザー・パック', PROD_DESC = 'Unix/Windows 1ユーザー・パック' WHERE PROD_ID = 28;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '5.2ch サラウンド・スピーカー・システム', PROD_DESC = '5.2ch サラウンド・スピーカー・システム' WHERE PROD_ID = 29;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'マウス・パッド', PROD_DESC = 'マウス・パッド' WHERE PROD_ID = 30;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付けDVDディスク・ドライブ', PROD_DESC = '外付けDVDディスク・ドライブ' WHERE PROD_ID = 31;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'マルチメディア・スピーカー 5コーン', PROD_DESC = 'マルチメディア・スピーカー 5コーン' WHERE PROD_ID = 32;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'USB データ通信カード', PROD_DESC = 'USB データ通信カード' WHERE PROD_ID = 33;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付け6倍速CD-ROMドライブ', PROD_DESC = '外付け6倍速CD-ROMドライブ' WHERE PROD_ID = 34;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '外付け8倍速CD-ROMドライブ', PROD_DESC = '外付け8倍速CD-ROMドライブ' WHERE PROD_ID = 35;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '携帯用外付け6倍速CD-ROMドライブ', PROD_DESC = '携帯用外付け6倍速CD-ROMドライブ' WHERE PROD_ID = 36;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '携帯用外付け8倍速CD-ROMドライブ', PROD_DESC = '携帯用外付け8倍速CD-ROMドライブ' WHERE PROD_ID = 37;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '内蔵6倍速CD-ROMドライブ', PROD_DESC = '内蔵6倍速CD-ROMドライブ' WHERE PROD_ID = 38;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '内蔵8倍速CD-ROMドライブ', PROD_DESC = '内蔵8倍速CD-ROMドライブ' WHERE PROD_ID = 39;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OS英語マニュアル', PROD_DESC = 'OS英語マニュアル' WHERE PROD_ID = 40;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OSドイツ語マニュアル', PROD_DESC = 'OSドイツ語マニュアル' WHERE PROD_ID = 41;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OSフランス語マニュアル', PROD_DESC = 'OSフランス語マニュアル' WHERE PROD_ID = 42;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OSスペイン語マニュアル', PROD_DESC = 'OSスペイン語マニュアル' WHERE PROD_ID = 43;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OSイタリア語マニュアル', PROD_DESC = 'OSイタリア語マニュアル' WHERE PROD_ID = 44;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'OS日本語マニュアル', PROD_DESC = 'OS日本語マニュアル' WHERE PROD_ID = 45;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '標準マウス', PROD_DESC = '標準マウス' WHERE PROD_ID = 46;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '光学式マウス', PROD_DESC = '光学式マウス' WHERE PROD_ID = 47;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'キーボード・レスト', PROD_DESC = 'キーボード・レスト' WHERE PROD_ID = 48;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-Rディスク（ケース付き）', PROD_DESC = 'CD-Rディスク（ケース付き）5枚パック' WHERE PROD_ID = 113;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '音楽用CD-R', PROD_DESC = '音楽用CD-R30枚パック' WHERE PROD_ID = 114;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-RW', PROD_DESC = '倍速対応CD-RW 10枚パック' WHERE PROD_ID = 115;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-RW', PROD_DESC = '倍速対応CD-RW 5枚パック' WHERE PROD_ID = 116;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-R', PROD_DESC = '高品質CD-R 5枚パック' WHERE PROD_ID = 117;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '音楽用CD-R', PROD_DESC = '音楽用CD-R10枚パック' WHERE PROD_ID = 118;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-Rディスク（ケース付き）', PROD_DESC = 'CD-Rディスク（ケース付き）12枚パック' WHERE PROD_ID = 119;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CD-Rディスク（ケース付き）', PROD_DESC = 'CD-Rディスク（ケース付き）片面一層' WHERE PROD_ID = 120;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD-RAMディスク（ケース付き）', PROD_DESC = 'DVD-RAMディスク（ケース付き）片面二層' WHERE PROD_ID = 121;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD-Rディスク', PROD_DESC = 'DVD-Rディスク5枚パック' WHERE PROD_ID = 122;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD-Rディスク', PROD_DESC = 'DVD-Rディスク5枚パック（高品質）' WHERE PROD_ID = 123;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'DVD-RWディスク', PROD_DESC = 'DVD-RWディスク3枚パック' WHERE PROD_ID = 124;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CDケース50枚収納ボックス', PROD_DESC = 'CDケース50枚収納ボックス' WHERE PROD_ID = 125;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'CDケース100枚収納ボックス', PROD_DESC = 'CDケース100枚収納ボックス' WHERE PROD_ID = 126;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル CD13272 インク・カートリッジ（３色）', PROD_DESC = 'モデル CD13272 インク・カートリッジ（３色）' WHERE PROD_ID = 127;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル SM26273 インク・カートリッジ（黒）', PROD_DESC = 'モデル SM26273 インク・カートリッジ（黒）' WHERE PROD_ID = 128;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル NM500X インク・カートリッジ（黄）', PROD_DESC = 'モデル NM500X インク・カートリッジ（黄）' WHERE PROD_ID = 129;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル A3827H インク・カートリッジ（青）', PROD_DESC = 'モデル A3827H インク・カートリッジ（青）' WHERE PROD_ID = 130;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル K3822L 携帯電話バッテリ', PROD_DESC = 'モデル K3822L 携帯電話バッテリ' WHERE PROD_ID = 131;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル C9827B 携帯電話バッテリ', PROD_DESC = 'モデル C9827B 携帯電話バッテリ' WHERE PROD_ID = 132;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル K8822S 携帯電話バッテリ', PROD_DESC = 'モデル K8822S 携帯電話バッテリ' WHERE PROD_ID = 133;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'モデル C93822D 携帯電話バッテリ', PROD_DESC = 'モデル C93822D 携帯電話バッテリ' WHERE PROD_ID = 134;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'S27273M 緊急用携帯電話バッテリ', PROD_DESC = 'S27274M 緊急用携帯電話バッテリ' WHERE PROD_ID = 135;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '64MB SDメモリ・カード', PROD_DESC = '64MB SDメモリ・カード' WHERE PROD_ID = 136;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '128MB SDメモリ・カード', PROD_DESC = '128MB SDメモリ・カード' WHERE PROD_ID = 137;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '256MB SDメモリ・カード', PROD_DESC = '256MB SDメモリ・カード' WHERE PROD_ID = 138;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '無線LAN中継ステーション', PROD_DESC = '無線LAN中継ステーション' WHERE PROD_ID = 139;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '8時間耐久レース・ゲーム', PROD_DESC = '9時間耐久レース・ゲーム' WHERE PROD_ID = 140;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'スマッシュ・ボクシング', PROD_DESC = 'スマッシュ・ボクシング' WHERE PROD_ID = 141;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'マーシャル・アーツ・チャンピオン', PROD_DESC = 'マーシャル・アーツ・チャンピオン' WHERE PROD_ID = 142;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'アメコミ・ヒーローズ', PROD_DESC = 'アメコミ・ヒーローズ' WHERE PROD_ID = 143;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'フライ・フィッシング', PROD_DESC = 'フライ・フィッシング' WHERE PROD_ID = 144;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'コイン探し', PROD_DESC = 'コイン探し' WHERE PROD_ID = 145;
UPDATE SHJP.PRODUCTS SET PROD_NAME = 'ナンバー・アドベンチャー', PROD_DESC = 'ナンバー・アドベンチャー' WHERE PROD_ID = 146;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '追加ケーブル', PROD_DESC = '追加ケーブル' WHERE PROD_ID = 147;
UPDATE SHJP.PRODUCTS SET PROD_NAME = '追加メモリ', PROD_DESC = '追加メモリ' WHERE PROD_ID = 148;
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'ゲーム機' WHERE PROD_SUBCATEGORY = 'Game Consoles';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = '家庭用オーディオ' WHERE PROD_SUBCATEGORY = 'Home Audio';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'Y Box アクセサリ' WHERE PROD_SUBCATEGORY = 'Y Box Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'Y Box ゲーム' WHERE PROD_SUBCATEGORY = 'Y Box Games';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'デスクトップPC' WHERE PROD_SUBCATEGORY = 'Desktop PCs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'ノートPC' WHERE PROD_SUBCATEGORY = 'Portable PCs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'アクセサリ' WHERE PROD_SUBCATEGORY = 'Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'CD-ROM' WHERE PROD_SUBCATEGORY = 'CD-ROM';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'メモリ' WHERE PROD_SUBCATEGORY = 'Memory';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'モデム/FAX' WHERE PROD_SUBCATEGORY = 'Modems/Fax';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'モニタ' WHERE PROD_SUBCATEGORY = 'Monitors';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'プリンタ・サプライ' WHERE PROD_SUBCATEGORY = 'Printer Supplies';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'ビデオカメラ' WHERE PROD_SUBCATEGORY = 'Camcorders';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'カメラ・バッテリ' WHERE PROD_SUBCATEGORY = 'Camera Batteries';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'カメラ・メディア' WHERE PROD_SUBCATEGORY = 'Camera Media';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'カメラ' WHERE PROD_SUBCATEGORY = 'Cameras';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'アクセサリ' WHERE PROD_SUBCATEGORY = 'Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'OS' WHERE PROD_SUBCATEGORY = 'Operating Systems';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'バルク・ディスク' WHERE PROD_SUBCATEGORY = 'Bulk Pack Diskettes';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'マニュアル' WHERE PROD_SUBCATEGORY = 'Documentation';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'CD-R' WHERE PROD_SUBCATEGORY = 'Recordable CDs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY_DESC = 'DVD-R' WHERE PROD_SUBCATEGORY = 'Recordable DVD Discs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'ゲーム機' WHERE PROD_SUBCATEGORY = 'Game Consoles';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = '家庭用オーディオ' WHERE PROD_SUBCATEGORY = 'Home Audio';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'Y Box アクセサリ' WHERE PROD_SUBCATEGORY = 'Y Box Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'Y Box ゲーム' WHERE PROD_SUBCATEGORY = 'Y Box Games';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'デスクトップPC' WHERE PROD_SUBCATEGORY = 'Desktop PCs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'ノートPC' WHERE PROD_SUBCATEGORY = 'Portable PCs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'アクセサリ' WHERE PROD_SUBCATEGORY = 'Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'CD-ROM' WHERE PROD_SUBCATEGORY = 'CD-ROM';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'メモリ' WHERE PROD_SUBCATEGORY = 'Memory';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'モデム/FAX' WHERE PROD_SUBCATEGORY = 'Modems/Fax';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'モニタ' WHERE PROD_SUBCATEGORY = 'Monitors';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'プリンタ・サプライ' WHERE PROD_SUBCATEGORY = 'Printer Supplies';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'ビデオカメラ' WHERE PROD_SUBCATEGORY = 'Camcorders';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'カメラ・バッテリ' WHERE PROD_SUBCATEGORY = 'Camera Batteries';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'カメラ・メディア' WHERE PROD_SUBCATEGORY = 'Camera Media';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'カメラ' WHERE PROD_SUBCATEGORY = 'Cameras';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'アクセサリ' WHERE PROD_SUBCATEGORY = 'Accessories';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'OS' WHERE PROD_SUBCATEGORY = 'Operating Systems';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'バルク・ディスク' WHERE PROD_SUBCATEGORY = 'Bulk Pack Diskettes';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'マニュアル' WHERE PROD_SUBCATEGORY = 'Documentation';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'CD-R' WHERE PROD_SUBCATEGORY = 'Recordable CDs';
UPDATE SHJP.PRODUCTS SET PROD_SUBCATEGORY = 'DVD-R' WHERE PROD_SUBCATEGORY = 'Recordable DVD Discs';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = '家電' WHERE PROD_CATEGORY = 'Electronics';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = 'ハードウェア' WHERE PROD_CATEGORY = 'Hardware';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = '周辺機器・アクセサリ' WHERE PROD_CATEGORY = 'Peripherals and Accessories';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = '写真' WHERE PROD_CATEGORY = 'Photo';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY_DESC = 'ソフトウェア・その他' WHERE PROD_CATEGORY = 'Software/Other';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = '家電' WHERE PROD_CATEGORY = 'Electronics';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = 'ハードウェア' WHERE PROD_CATEGORY = 'Hardware';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = '周辺機器・アクセサリ' WHERE PROD_CATEGORY = 'Peripherals and Accessories';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = '写真' WHERE PROD_CATEGORY = 'Photo';
UPDATE SHJP.PRODUCTS SET PROD_CATEGORY = 'ソフトウェア・その他' WHERE PROD_CATEGORY = 'Software/Other';
UPDATE SHJP.PRODUCTS SET PROD_TOTAL = '全製品';
COMMIT;
-- *************************************************
-- PROMOTIONS
-- *************************************************
INSERT INTO SHJP.PROMOTIONS SELECT * FROM SH.PROMOTIONS;
ALTER TABLE SHJP.PROMOTIONS MODIFY (
PROMO_NAME VARCHAR2(40),
PROMO_TOTAL VARCHAR2(30),
PROMO_SUBCATEGORY VARCHAR2(40)
);
set serveroutput on size 2000
declare
p1 number;
p2 varchar2(30);
p3 varchar2(30);
cursor cu is
select promo_id p1,
regexp_replace(promo_name, ' *#.*', '') p2,
regexp_substr(promo_name, '#.*') p3
from shjp.promotions;
cu_rec cu%rowtype;
begin
open cu;
loop
EXIT WHEN cu%NOTFOUND;
FETCH cu into cu_rec;
p1:=cu_rec.p1;
p2:=cu_rec.p2;
p3:=cu_rec.p3;
/** begin loop **/
if p2 = 'NO PROMOTION' then
update shjp.promotions set promo_name = 'プロモーションなし '||p3 where promo_id = p1;
elsif p2 = 'TV promotion' then
update shjp.promotions set promo_name = 'TVプロモーション '||p3 where promo_id = p1;
elsif p2 = 'blowout sale' then
update shjp.promotions set promo_name = '大安売り '||p3 where promo_id = p1;
elsif p2 = 'everyday low price' then
update shjp.promotions set promo_name = 'エブリィディ・ロープライス '||p3 where promo_id = p1;
elsif p2 = 'flyer promotion' then
update shjp.promotions set promo_name = 'ちらし '||p3 where promo_id = p1;
elsif p2 = 'internet promotion' then
update shjp.promotions set promo_name = 'インターネット '||p3 where promo_id = p1;
elsif p2 = 'magazine promotion' then
update shjp.promotions set promo_name = '雑誌 '||p3 where promo_id = p1;
elsif p2 = 'newspaper promotion' then
update shjp.promotions set promo_name = '新聞 '||p3 where promo_id = p1;
elsif p2 = 'post promotion' then
update shjp.promotions set promo_name = '郵便 '||p3 where promo_id = p1;
elsif p2 = 'radio promotion' then
update shjp.promotions set promo_name = 'ラジオ '||p3 where promo_id = p1;
else
dbms_output.put_line ('PROMO_ID:='||p1||p2||p3||'ERROR!!');
end if;
/** end loop **/
end loop;
end;
/
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'プロモーションなし' WHERE PROMO_SUBCATEGORY = 'NO RPOMOTION';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'TVコマーシャル' WHERE PROMO_SUBCATEGORY = 'TV commercial';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'TV番組スポンサー' WHERE PROMO_SUBCATEGORY = 'TV program sponsorship';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '広告' WHERE PROMO_SUBCATEGORY = 'ad';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '雑誌広告' WHERE PROMO_SUBCATEGORY = 'ad magazine';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '新聞広告' WHERE PROMO_SUBCATEGORY = 'ad news';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '看板' WHERE PROMO_SUBCATEGORY = 'billboard';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '雑誌クーポン' WHERE PROMO_SUBCATEGORY = 'coupon magazine';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '新聞クーポン' WHERE PROMO_SUBCATEGORY = 'coupon news';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'ダウンタウンの看板' WHERE PROMO_SUBCATEGORY = 'downtown billboard';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '高速道路看板' WHERE PROMO_SUBCATEGORY = 'freeway billboard';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'ちらし' WHERE PROMO_SUBCATEGORY = 'general flyer';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '病院のちらし' WHERE PROMO_SUBCATEGORY = 'hospital flyer';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '家庭向けちらし' WHERE PROMO_SUBCATEGORY = 'household flyer';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '特別顧客向け割引' WHERE PROMO_SUBCATEGORY = 'loyal customer discount';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '工場労働者向け雑誌' WHERE PROMO_SUBCATEGORY = 'manufacture rebate magazine';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '工場労働者向け新聞' WHERE PROMO_SUBCATEGORY = 'manufacture rebate news';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = '新聞' WHERE PROMO_SUBCATEGORY = 'newspaper';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'オンライン割引' WHERE PROMO_SUBCATEGORY = 'online discount';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'プロモーション・ムービー' WHERE PROMO_SUBCATEGORY = 'promotion movie';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'ラジオ・コマーシャル' WHERE PROMO_SUBCATEGORY = 'radio commercial';
UPDATE SHJP.PROMOTIONS SET PROMO_SUBCATEGORY = 'ラジオ番組スポンサー' WHERE PROMO_SUBCATEGORY = 'radio program sponsorship';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'プロモーションなし' WHERE PROMO_CATEGORY = 'NO PROMOTION';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'TV' WHERE PROMO_CATEGORY = 'TV';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = '広告新聞' WHERE PROMO_CATEGORY = 'ad news';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'ちらし' WHERE PROMO_CATEGORY = 'flyer';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'インターネット' WHERE PROMO_CATEGORY = 'internet';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = '雑誌' WHERE PROMO_CATEGORY = 'magazine';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = '新聞' WHERE PROMO_CATEGORY = 'newspaper';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = '郵便' WHERE PROMO_CATEGORY = 'post';
UPDATE SHJP.PROMOTIONS SET PROMO_CATEGORY = 'ラジオ' WHERE PROMO_CATEGORY = 'radio';
UPDATE SHJP.PROMOTIONS SET PROMO_TOTAL = '全プロモーション';
COMMIT;
-- *************************************************
-- TIMES
-- *************************************************
INSERT INTO SHJP.TIMES SELECT * FROM SH.TIMES;
UPDATE SHJP.TIMES SET DAY_NAME = '月曜日' WHERE DAY_NAME = 'Monday';
UPDATE SHJP.TIMES SET DAY_NAME = '火曜日' WHERE DAY_NAME = 'Tuesday';
UPDATE SHJP.TIMES SET DAY_NAME = '水曜日' WHERE DAY_NAME = 'Wednesday';
UPDATE SHJP.TIMES SET DAY_NAME = '木曜日' WHERE DAY_NAME = 'Thursday';
UPDATE SHJP.TIMES SET DAY_NAME = '金曜日' WHERE DAY_NAME = 'Friday';
UPDATE SHJP.TIMES SET DAY_NAME = '土曜日' WHERE DAY_NAME = 'Saturday';
UPDATE SHJP.TIMES SET DAY_NAME = '日曜日' WHERE DAY_NAME = 'Sunday';
COMMIT;
INSERT INTO SHJP.SALES SELECT * FROM SH.SALES;
INSERT INTO SHJP.COSTS SELECT * FROM SH.COSTS;
COMMIT;
update shjp.sales set amount_sold=amount_sold*100;
update shjp.costs set unit_cost=unit_cost*100;
update shjp.costs set unit_price=unit_price*100;
update shjp.products set prod_list_price=prod_list_price*100;
COMMIT;
SELECT 'CHANNELS' as TNAME,count(*) from SHJP.CHANNELS union
SELECT 'COSTS' as TNAME,count(*) from SHJP.COSTS union
SELECT 'COUNTRIES' as TNAME,count(*) from SHJP.COUNTRIES union
SELECT 'CUSTOMERS' as TNAME,count(*) from SHJP.CUSTOMERS union
SELECT 'PRODUCTS' as TNAME,count(*) from SHJP.PRODUCTS union
SELECT 'PROMOTIONS' as TNAME,count(*) from SHJP.PROMOTIONS union
SELECT 'SALES' as TNAME,count(*) from SHJP.SALES union
SELECT 'TIMES' as TNAME,count(*) from SHJP.TIMES ;
----------------------------
-- UPDATE TIMES.TIME_ID --
-- UPDATE SALES.TIME_ID --
-- UPDATE COSTS.TIME_ID --
----------------------------
spool c:\UpdateSH.log;
-- 1. FKを無効化
ALTER TABLE SHJP.SALES DISABLE CONSTRAINT SALES_TIME_FK;
ALTER TABLE SHJP.COSTS DISABLE CONSTRAINT COSTS_TIME_FK;
-- 2. TIMES.TIME_IDを現在まで増やす
UPDATE SHJP.TIMES SET TIME_ID = TIME_ID + (to_date('20191231','yyyymmdd')-to_date('20011231','yyyymmdd'));
-- 3. TIMESのTIME_ID以外のカラムをTIME_IDに合わせる
UPDATE SHJP.TIMES set
DAY_NAME = to_char(time_id,'DY')
,DAY_NUMBER_IN_WEEK = MOD(TO_CHAR(time_id,'D')+6,7)
,DAY_NUMBER_IN_MONTH = to_char(time_id,'DD')
,CALENDAR_WEEK_NUMBER = to_char(time_id,'IW')
,WEEK_ENDING_DAY = trunc(time_id+7,'IW')-1
,WEEK_ENDING_DAY_ID = to_char(trunc(time_id+7,'IW')-1,'YYYYMMDD')
,CALENDAR_MONTH_NUMBER = to_char(time_id,'MM')
,CALENDAR_MONTH_DESC = to_char(time_id,'YY-MONTH')
,CALENDAR_MONTH_ID = to_char(time_id,'YYYYMM')
,DAYS_IN_CAL_MONTH = to_char(last_Day(time_id),'DD')
,END_OF_CAL_MONTH = last_Day(time_id)
,CALENDAR_MONTH_NAME = to_char(time_id,'MONTH')
,CALENDAR_QUARTER_DESC = to_char(time_id,'YYYY-Q')
,CALENDAR_QUARTER_ID = to_char(time_id,'YYYYQ')
,DAYS_IN_CAL_QUARTER = last_day(add_months(trunc(time_id,'Q'),2))-trunc(time_id,'Q')+1
,END_OF_CAL_QUARTER = last_day(add_months(trunc(time_id,'Q'),2))
,CALENDAR_QUARTER_NUMBER = to_char(time_id,'Q')
,CALENDAR_YEAR = to_char(time_id,'YYYY')
,CALENDAR_YEAR_ID = to_char(time_id,'YYYY')
,DAYS_IN_CAL_YEAR = 1+LAST_DAY(ADD_MONTHS(TRUNC(time_id,'YEAR'),11))-TRUNC(time_id,'YEAR')
,END_OF_CAL_YEAR = LAST_DAY(ADD_MONTHS(TRUNC(time_id,'YEAR'),11))
;
commit;
-- 4. SH.SALESをTRUNCATE
DROP TABLE SHJP.SALES_TMP PURGE;
CREATE TABLE SHJP.SALES_TMP AS SELECT * FROM SHJP.SALES;
TRUNCATE TABLE SHJP.SALES;
-- 6. SALESの日付データをUPDATE
INSERT INTO SHJP.SALES
SELECT
PROD_ID
,CUST_ID
,TIME_ID + (to_date('20191231','yyyymmdd')-to_date('20011231','yyyymmdd'))
,CHANNEL_ID
,PROMO_ID
,QUANTITY_SOLD
,AMOUNT_SOLD
FROM SHJP.SALES_TMP
;
DROP TABLE SHJP.SALES_TMP CASCADE CONSTRAINT PURGE;
-- 7. FKを有効化
-- ALTER TABLE SHJP.SALES ENABLE NOVALIDATE CONSTRAINT SHJP.SALES_TIME_FK;
-- COMMIT;
------ COSTSの更新 ------
-- COSTSをTRUNCATE
DROP TABLE SHJP.COSTS_TMP PURGE;
CREATE TABLE SHJP.COSTS_TMP AS SELECT * FROM SHJP.COSTS;
TRUNCATE TABLE SHJP.COSTS;
-- COSTSの日付データをUPDATE。
INSERT INTO SHJP.COSTS
SELECT
PROD_ID
,TIME_ID + (to_date('20191231','yyyymmdd')-to_date('20011231','yyyymmdd'))
,PROMO_ID
,CHANNEL_ID
,UNIT_COST
,UNIT_PRICE
FROM SHJP.COSTS_TMP
;
DROP TABLE SHJP.COSTS_TMP CASCADE CONSTRAINT PURGE;
-- FKを有効化
-- ALTER TABLE SHJP.COSTS ENABLE NOVALIDATE CONSTRAINT COSTS_TIME_FK;
-- COMMIT;
-- ↓ Error
alter session set NLS_DATE_LANGUAGE='JAPANESE';
update shjp.times set
DAY_NAME = substr(to_char(time_id,'DAY'),1,1)
,DAY_NUMBER_IN_WEEK = to_char(time_id,'D')-1
,DAY_NUMBER_IN_MONTH = to_char(time_id,'DD')
,CALENDAR_WEEK_NUMBER = to_char(time_id,'WW')
,FISCAL_WEEK_NUMBER = FISCAL_WEEK_NUMBER
,WEEK_ENDING_DAY = next_day(time_id-1,'日曜日')
,WEEK_ENDING_DAY_ID = to_char(next_day(time_id-1,'日曜日'),'yyyymmdd')
,CALENDAR_MONTH_NUMBER = to_char(time_id, 'MM')
,FISCAL_MONTH_NUMBER = to_char(time_id, 'MM')
,CALENDAR_MONTH_DESC = to_char(time_id,'yyyy-mm')
,CALENDAR_MONTH_ID = to_char(time_id,'yyyymm')
,FISCAL_MONTH_DESC = case
when to_char(time_id,'mm')<=3 then to_char(add_months(time_id,-12),'yyyy-mm')
else to_char(time_id,'yyyy-mm')
end
,FISCAL_MONTH_ID = case
when to_char(time_id,'mm')<=3 then to_char(time_id,'yyyymm')
when to_char(time_id,'mm')> 3 then to_char(time_id,'yyyymm')
end
,DAYS_IN_CAL_MONTH = to_char(last_day(time_id),'dd')
,DAYS_IN_FIS_MONTH = to_char(last_day(time_id),'dd')
,END_OF_CAL_MONTH = last_day(time_id)
,END_OF_FIS_MONTH = last_day(time_id)
,CALENDAR_MONTH_NAME = rtrim(to_char(time_id,'month'))
,FISCAL_MONTH_NAME = rtrim(to_char(time_id,'month'))
,CALENDAR_QUARTER_DESC = to_char(time_id,'"Q"q')
,CALENDAR_QUARTER_ID = to_char(time_id,'yyyyq')
,FISCAL_QUARTER_DESC = to_char(add_months(time_id,-3),'"Q"q')
,FISCAL_QUARTER_ID = to_char(add_months(time_id,-3),'yyyyq')
,DAYS_IN_CAL_QUARTER = trunc(add_months(time_id,3),'q')-trunc(time_id,'q')
,DAYS_IN_FIS_QUARTER = trunc(add_months(time_id,3),'q')-trunc(time_id,'q')
,END_OF_CAL_QUARTER = trunc(add_months(time_id,3),'q')-1
,END_OF_FIS_QUARTER = trunc(add_months(time_id,3),'q')-1
,CALENDAR_QUARTER_NUMBER = to_char(time_id,'q')
,FISCAL_QUARTER_NUMBER = to_char(add_months(time_id,-3),'q')
,CALENDAR_YEAR = to_char(time_id,'yyyy')
,CALENDAR_YEAR_ID = to_char(time_id,'yyyy')
,FISCAL_YEAR = to_char(add_months(time_id,-3),'yyyy')
,FISCAL_YEAR_ID = to_char(add_months(time_id,-3),'yyyy')
,DAYS_IN_CAL_YEAR = to_char(to_date(to_char(time_id,'yyyy')||'1231','yyyymmdd'),'ddd')
,DAYS_IN_FIS_YEAR = to_date(to_char(add_months(time_id,9),'yyyy')||'0331','yyyymmdd') -
to_date(to_char(add_months(time_id,-3),'yyyy')||'0331','yyyymmdd')
,END_OF_CAL_YEAR = to_date(to_char(time_id,'yyyy')||'1231','yyyymmdd')
,END_OF_FIS_YEAR = to_date(to_char(add_months(time_id,9),'yyyy')||'0331','yyyymmdd')
;
update times set DAY_NUMBER_IN_WEEK = 7 where DAY_NUMBER_IN_WEEK = 0;
commit;
SELECT 'CHANNELS' as TNAME,count(*) from SHJP.CHANNELS union
SELECT 'COSTS' as TNAME,count(*) from SHJP.COSTS union
SELECT 'COUNTRIES' as TNAME,count(*) from SHJP.COUNTRIES union
SELECT 'CUSTOMERS' as TNAME,count(*) from SHJP.CUSTOMERS union
SELECT 'PRODUCTS' as TNAME,count(*) from SHJP.PRODUCTS union
SELECT 'PROMOTIONS' as TNAME,count(*) from SHJP.PROMOTIONS union
SELECT 'SALES' as TNAME,count(*) from SHJP.SALES union
SELECT 'TIMES' as TNAME,count(*) from SHJP.TIMES ;