An example of one table in the script:
drop table HTMLEXTRACT
go
create table HTMLEXTRACT (
"doc_id" numeric(32) identity not null,
"parent_id" numeric(32) not null,
"doc_type" varchar(10) not null,
"pid" numeric(16) not null,
"doc_time" datetime default getdate(),
"doc_path" varchar(512) not null,
"status" smallint not null,
"html_body" image null
)
with max_rows_per_page=1, identity_gap=100 on data
go
create index HYMLEXTRACT_PK1 on HTMLEXTRACT("doc_id","status") with max_rows_per_page=1 on indices
go
sp_bindcache htmlExtractCache, S3, HTMLEXTRACT, HTMLEXTRACT_PK1
go
sp_bindcache htmlExtractDataCache, S3, HTMLEXTRACT
go
sp_placeobject imgData, "HTMLEXTRACT.tHTMLEXTRACT"
go
sp_bindcache imgDataCache, S3, HTMLEXTRACT, "text only"
go
My problem is that when I run the script all the tables and indices are created and place on the segments indicated. The last four commands for each table however silently fail. Then I have to go back and run each one on the isql command line. They succeed. Both cases are run under the same account and priviledges.
How do I avoid the extra work?
Jim
drop table HTMLEXTRACT
go
create table HTMLEXTRACT (
"doc_id" numeric(32) identity not null,
"parent_id" numeric(32) not null,
"doc_type" varchar(10) not null,
"pid" numeric(16) not null,
"doc_time" datetime default getdate(),
"doc_path" varchar(512) not null,
"status" smallint not null,
"html_body" image null
)
with max_rows_per_page=1, identity_gap=100 on data
go
create index HYMLEXTRACT_PK1 on HTMLEXTRACT("doc_id","status") with max_rows_per_page=1 on indices
go
sp_bindcache htmlExtractCache, S3, HTMLEXTRACT, HTMLEXTRACT_PK1
go
sp_bindcache htmlExtractDataCache, S3, HTMLEXTRACT
go
sp_placeobject imgData, "HTMLEXTRACT.tHTMLEXTRACT"
go
sp_bindcache imgDataCache, S3, HTMLEXTRACT, "text only"
go
My problem is that when I run the script all the tables and indices are created and place on the segments indicated. The last four commands for each table however silently fail. Then I have to go back and run each one on the isql command line. They succeed. Both cases are run under the same account and priviledges.
How do I avoid the extra work?
Jim