MySQL Forums
Forum List  »  Sybase

Re: Can't connect to Sql Anywhere 12
Posted by: Wayne Gregg
Date: May 02, 2012 04:54PM

The origional db was running on SQL Anywhere 5.5.04

Here are some of the statements in the unload file that was used for the migration to SQL Anywhere 12

CREATE TABLE "DBA"."pbcattbl" (
"pbt_tnam" char(129) NOT NULL
,"pbt_tid" integer NULL
,"pbt_ownr" char(129) NOT NULL
,"pbd_fhgt" smallint NULL
,"pbd_fwgt" smallint NULL
,"pbd_fitl" char(1) NULL
,"pbd_funl" char(1) NULL
,"pbd_fchr" smallint NULL
,"pbd_fptc" smallint NULL
,"pbd_ffce" char(18) NULL
,"pbh_fhgt" smallint NULL
,"pbh_fwgt" smallint NULL
,"pbh_fitl" char(1) NULL
,"pbh_funl" char(1) NULL
,"pbh_fchr" smallint NULL
,"pbh_fptc" smallint NULL
,"pbh_ffce" char(18) NULL
,"pbl_fhgt" smallint NULL
,"pbl_fwgt" smallint NULL
,"pbl_fitl" char(1) NULL
,"pbl_funl" char(1) NULL
,"pbl_fchr" smallint NULL
,"pbl_fptc" smallint NULL
,"pbl_ffce" char(18) NULL
,"pbt_cmnt" varchar(254) NULL
)
go

GRANT SELECT,INSERT,DELETE,UPDATE,ALTER,REFERENCES ON "DBA"."pbcattbl" TO "PUBLIC"
go

CREATE TABLE "DBA"."pbcatcol" (
"pbc_tnam" char(129) NOT NULL
,"pbc_tid" integer NULL
,"pbc_ownr" char(129) NOT NULL
,"pbc_cnam" char(129) NOT NULL
,"pbc_cid" smallint NULL
,"pbc_labl" varchar(254) NULL
,"pbc_lpos" smallint NULL
,"pbc_hdr" varchar(254) NULL
,"pbc_hpos" smallint NULL
,"pbc_jtfy" smallint NULL
,"pbc_mask" varchar(31) NULL
,"pbc_case" smallint NULL
,"pbc_hght" smallint NULL
,"pbc_wdth" smallint NULL
,"pbc_ptrn" varchar(31) NULL
,"pbc_bmap" char(1) NULL
,"pbc_init" varchar(254) NULL
,"pbc_cmnt" varchar(254) NULL
,"pbc_edit" varchar(31) NULL
,"pbc_tag" varchar(254) NULL
)

Options: ReplyQuote


Subject
Views
Written By
Posted
6194
April 29, 2012 12:55PM
2921
April 30, 2012 08:26AM
Re: Can't connect to Sql Anywhere 12
2770
May 02, 2012 04:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.