|
Please google translate the following |
|
Somehow the V12 dbunload produced a corrupt CREATE TABLE statement containing "varchar(10) NOT NULL INLINE 100 PREFIX 8" (see below) Run dbunload to unload the schema and data, then edit reload.sql to remove the "INLINE 100 PREFIX 8", then run dbinit to create a new database, then run the reload.sql through dbisql to load the database. Could not execute statement.
Illegal column definition: Column 'customer_id' inline value '100' is
invalid
SQLCODE=-1046, ODBC 3 State="42000"
Line 17189, column 1
You can continue executing or stop.
CREATE TABLE "DBA"."customer_fx" (
"customer_id" varchar(10) NOT NULL INLINE 100 PREFIX 8
,"short_name" varchar(100) NULL
,"full_name" varchar(100) NULL
,"principal" varchar(50) NULL
,"linkman" varchar(50) NULL
,"telephone" varchar(30) NULL
,"facsimile" varchar(30) NULL
,"city" varchar(50) NULL
,"state" varchar(50) NULL
,"zipcode" varchar(15) NULL
,"country" varchar(50) NULL
,"e_mail" varchar(100) NULL
,"utl" varchar(100) NULL
,"customer_code" varchar(6) NOT NULL
,"credit_limit" numeric(16,6) NULL
,"bank_no" varchar(30) NULL
,"mob_no" varchar(16) NULL
,"cust_add" varchar(200) NULL
,"bank" varchar(60) NULL
,"salesman" varchar(10) NULL
,"quote_mode" varchar(6) NULL
,"open_date" date NULL
,"first_business_date" date NULL
,"lately_business_date" date NULL
,"capital" int NULL
,"annual_turnover" int NULL
,"stuff_qty" int NULL
,"sell_code" varchar(1) NULL
,"credit_code" varchar(1) NULL
,"ar_account_id" varchar(25) NULL
,"price_term" varchar(50) NULL
,"primary_currency" varchar(10) NULL
,"payment_term" varchar(50) NULL
,"transfer_mode" varchar(30) NULL
,"invoice_age" int NULL
,"credit_status" varchar(1) NULL
,"carrier_id" varchar(30) NULL
,"monthly_reckoning" date NULL
,"remark" long varchar NULL
,"estimated_gathering" date NULL
,"total_open_orders" numeric(16,6) NULL
,"total_open_recv" numeric(16,6) NULL
,"open_order_count" int NULL
,"open_recv_count" int NULL
,"foreign_customer" varchar(30) NULL
,"user_1" varchar(30) NULL
,"user_2" varchar(30) NULL
,"user_3" varchar(100) NULL
,"user_4" varchar(30) NULL
,"user_5" varchar(30) NULL
,"user_6" numeric(16,6) NULL
,"user_7" numeric(16,6) NULL
,"user_8" numeric(16,6) NULL
,"user_9" numeric(16,6) NULL
,"user_10" numeric(16,6) NULL
,"business_no" varchar(30) NULL
,"artifical_person" varchar(10) NULL
,"tax_register" varchar(30) NULL
,"create_time" timestamp NULL DEFAULT current timestamp
,"edit_time" timestamp NULL DEFAULT timestamp
,"pre_accept_amt" numeric(16,6) NULL
,"should_accept_amt" numeric(16,6) NULL
,"owe_accept_amt" numeric(16,6) NULL
,"grade" varchar(10) NULL
,"card_id" varchar(10) NULL
,"card_no" varchar(15) NULL
,"tax_id" varchar(10) NULL
,"region_id" varchar(10) NULL
,"sell_grade" varchar(10) NULL
,"lately_follow_date" date NULL
,"receivable_acct_id" varchar(30) NULL
,"precash_acct_id" varchar(30) NULL
,"vendor_id" varchar(10) NULL
,"discount_id" varchar(10) NULL
,"integral" decimal(16,6) NULL
,"acount_date" int NULL
,"locked" varchar(1) NULL
,"lock_man" varchar(10) NULL
,"lock_time" timestamp NULL
,"upper_cust_id" varchar(10) NULL
,"salesdept" varchar(10) NULL
,"cust_name_of_invoice" varchar(100) NULL
,"cust_addr_of_invoice" varchar(200) NULL
,"cust_tel_of_invoice" varchar(30) NULL
,"cust_fax_of_invoice" varchar(30) NULL
,"protocol_no" varchar(30) NULL
,"invoicedays" int NULL
,"post_of_invoice" varchar(15) NULL
,"man_of_invoice" varchar(10) NULL
,"post_addr_of_invoice" varchar(200) NULL
,"goods_with_invoice" varchar(1) NULL
,"others_of_invoice" varchar(200) NULL
,"user_11" varchar(50) NULL
,"user_12" varchar(50) NULL
,"user_13" varchar(50) NULL
,"user_14" varchar(50) NULL
,"user_15" varchar(50) NULL
,"qq_number" varchar(30) NULL
,"rec_other" varchar(30) NULL
,"progress_status" varchar(10) NULL
,"mob_no2" varchar(16) NULL
,"first_contact_date" date NULL
,"service_start_date" date NULL
,"service_end_date" date NULL
,"service_price" decimal(16,6) NULL
,"abandon_reason" varchar(400) NULL
,"if_abandon" varchar(1) NULL
,"salesman2" varchar(10) NULL
,"serve_man1" varchar(10) NULL
,"serve_man2" varchar(10) NULL
,"location_id" char(15) NULL
,"deliver_man" char(30) NULL
,"driver" char(30) NULL
,"car_no" char(30) NULL
,"channel_id" varchar(10) NULL
,"web_id" varchar(50) NULL
,"sum_ensemble" char(1) NULL
,"if_inside_custvend" char(1) NULL
,"rec_sign" char(30) NULL
,"if_local" char(1) NULL
,PRIMARY KEY ("customer_id")
)
|
Run dbunload -n, then search reload.sql for all the CREATE TABLE statements that contain customer_id and show them to us.
breck dot carter gmail
Please check your email. Thank you.
Nothing yet. If you attached a file, rename it from .sql to .txt
...and still nothing
E-mail has been sent successfully