Please google translate the following

SQL Anywhere 卸载实用程序 版本 12.0.1.3457
正在连接并初始化
正在卸载用户和组定义
正在卸载表定义
正在卸载实例化视图定义
正在卸载索引定义
正在卸载函数
正在卸载视图定义
正在卸载过程
正在卸载触发器
正在卸载 SQL 远程定义
正在卸载 MobiLink 定义
正在创建新数据库
***** SQL 错误: 非法的列定义: 列 'customer_id' 的内置值 '100' 无效

asked 17 May '15, 01:28

mfkpie8's gravatar image

mfkpie8
86424751
accept rate: 10%

edited 17 May '15, 01:30

Connecting and initialize
...
Uninstalling SQL remote definition
Uninstalling MobiLink definitions
We are creating a new database
***** SQL error: Illegal column definition: Column 'customer_id' built-in value '100' is not valid

Run dbunload -n, then search reload.sql for all the CREATE TABLE statements that contain customer_id and show them to us.

(17 May '15, 07:57) Breck Carter
Replies hidden
Comment Text Removed

breck dot carter gmail

(17 May '15, 16:01) Breck Carter

Please check your email. Thank you.

(18 May '15, 07:17) mfkpie8
Replies hidden

Nothing yet. If you attached a file, rename it from .sql to .txt

(18 May '15, 07:21) Breck Carter

...and still nothing

(18 May '15, 13:38) Breck Carter
Comment Text Removed
Comment Text Removed

E-mail has been sent successfully

(18 May '15, 21:43) mfkpie8
showing 3 of 6 show all flat view

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") 
)
permanent link

answered 19 May '15, 07:47

Breck%20Carter's gravatar image

Breck Carter
27.3k424585836
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×53

question asked: 17 May '15, 01:28

question was seen: 685 times

last updated: 19 May '15, 07:47