I raised a case with IBM when I tracked down our crash to a file not converting properly when we moved from AIX to W2K3. This file had a trigger, which we had removed, but even so it did not convert completely. The result was an unpredictable crash of the session which took a long time to track down. I am advised by IBM support that currently there is not a way to move UniVerse files, with Triggers, to another Machine Class as fnuxi does not support SQL tables. They do not regard this as being a bug. The application of a Trigger to a standard UniVerse file turns this into a pseudo SQL Table with a SICA block within the file's header, to store the trigger information. The CREATE/DROP TRIGGER commands are updating the uv/SQL/CATALOG/UV_TABLES and UV_USERS files. They have provided me with a workaround to clear the sica pointer from the file header, which will allow me to make the changes when moving between machine classes. I am going to request an enhancement to make this available to other users without them needing to write additional hacks to get around this situation. This is the second time we have had to move between machine classes within 3 years. It happens - we need to be able to handle it simply without the aggravation it has caused us. At the very minimum IBM need to cover this in their documentation. If they have I didn't find it. UniVerse 10.1 on Windows 2003 Sara Burns Sara Burns (SEB) Development Team Leader
Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 < <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED]> Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
