Re: Online 5.0 Apps Deployment on Online WGS

* * We all know that if the applications use rowid in them, then deploying them * on the DSA can cause problems due to table fragmentation as each fragment * would have its own set of rowids. * * But in Online WorkGroupServer PDQ and table fragmentation features are not * part of the product. Hence would any one know if the 4GL application written * using rowids for Online 5.0 would have to go through any changes to be * deployed on the Online WGS. I don't know why everyone is mislead on this rowid thing. It's not that there will be non-unique rowids due to fragments. It's that there will be NO LONGER rowids accessible to programs/tools for fragmented tables, unless you specifically build the table WITH ROWIDS. Then, you will have the uniqueness as you did back in previous versions. Of course, now with some minor overhead. Try it. It's rather simple to test. Build a table and fragment it. Notice, no rowids are available. Now, alter the table adding WITH ROWIDS. You should not find a non-unique rowid throughout the table. Any help with this one, Mr. Leffler? Thanks, ----------------------------------------------------------------------------- Robert Minter Data Systems Support Senior Software Engineer A Client Technologies Company E-Mail: rob@dssmktg.com Tel: 714.771.0454 Fax: 714.771.3028 #include <std_disclaimer.h> http://www.dssny.com