Re: er on ids9.20

From: johnh <john.horton@cognito.co.uk> > >hi >is there any way of defining a replicate for all tables in a database >without actually typing each table name? I tried > >cdr define replicate --conflict=ignore repl1 >"P dba@g_dbserva:informix.*" "select * from *" \\ >"R dba@g_dbservb:informix.*" "select * from *" > >but it didn't work! >please help as i *really* don't wan't to spend the next two days writing >a script containing all the tables in the db. Two days? SELECT "cdr define replicate --conflict=ignore repl1", "P dba@g_dbserva:\\" || TRIM(owner) || "." || TRIM(tabname) || "\\" \\"select * from " || tabname || "\\" \\\\ ", " dba@g_dbservb:\\" || TRIM(owner) || "." || TRIM(tabname) || "\\" \\"select * from " || tabname || "\\"" FROM systables WHERE tabid > 99; Something like that, anyway, I have neither manuals nor a server to hand. :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com