Copy: [email protected] (Informix-List)

On 20 Mar 2017, at 15:09, Clive Eisen <[email protected]> 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)