Re: Migration DB from 9.2 Unix to NT with Datablade inside
Posted in 2000
Sorry I did a mistake with my example : here is the kind of things whichs 'fails' ( I want to say : DATABLADE won't be recognize by the Engine ) create function "informix".etx_begin_scan(pointer) returns integer with ( not variant ) external name "$INFORMIXDIR/extend/ETX.1.30.UC2/ETX.bld(etx_begin_scan)" language c; And for NT IDS.2000 it should be : external name "$INFORMIXDIR/extend/ETX.1.30.TC2/ETX.bld(etx_begin_scan)" I Tried to make a Shell Script to substitute 1.30.UC2 with 1.30.TC2 but inside UNL files there is also Datablade References. Obnoxio The Clown wrote: > > From: Laurent REVEL <lrevel@reef.com> > > > > Like I need to do this kind of migration 9.20 with DataBlade UNIX -> NT > >or NT -> UNIX, we can find out that DBEXPORT/DBIMPORT can not do this > >automically. > >The SQL/UNL file generated always contains OS specific path like : > > > >create function "informix".sysbldlike(SYSBldSQLText,SYSBldSQLText) > >returns boolean > >external name > >'$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld(SYSBldSQLTextLike)' > >language c; > > > >Does someone know a simplest way to do this, without splitting SQL > >and UNL manually ? > > And are you sure this will fail? Have you actually tried it? (With the > datablades in the same relative path, of course) > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- ----- REVEL Laurent / DBA Engineer ----- REEF - 116, rue du Faubourg St Martin - 75010 PARIS Office Tel: 33 (0)1-55-26-53-53 and ask : 5404