Copy:
informix-list@iiug.org (Informix-List)
On 20 Mar 2017, at 15:09, Clive Eisen <clive@hildebrand.co.uk> wrote:
I have been trying to import a dbschema as above - which includes timeseries ;-(
I dont have and can’t get 11.70 for the target machine so I cant try an in-place upgrade
After a lot of faffing as the TS version is included in the blade name
I am down to
1) Virtual table creation seems to have changed the number of params - but that’s OK as I can re-create
but
2) The following both fail with
9793: User Defined Routine (tsbinload_inscontainercache) module load failed.
create trigger "informix".tscontainerins insert on "informix”.tscontainertable
referencing new as new
for each row
(
execute procedure "informix".tsbinload_inscontainercache(new.subtype
,new.name ,new.flags ,"informix".getpartitiondesc(new.partitiondesc
)));
create trigger "informix".tscontainerupdpf update of partitiondesc,
flags on "informix".tscontainertable referencing new as new
for each row
(
execute procedure "informix".tsbinload_inscontainercache(new.subtype
,new.name ,new.flags ,"informix".getpartitiondesc(new.partitiondesc
)));
Where is the create procedure statement for tsbinload_inscontainercache?
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)