Re: Can C-ISAM be updated by SE?

> > Hello all! > > I have a client that has a C-ISAM database. They'd like to be > able to slowly migrate their C-ISAM applications to embedded SQL > while some C-ISAM programs remain intact. I know that standard > engine can be used to update the files created/maintained by > C-ISAM. But, I also know that there are pitfalls. So far, my > questions are: > > 1. What can I look for to see if SE will cause the ISAM files > problems? (Non-standard datatypes, etc.) Suggestion :- You can check for the versions of SE regarding its compatibility to C-ISAM files. > > 2. What about locking? Will the SE locks cause any problems > with the C-ISAM locks? By my experience :- No locking problems . > > 3. Has anyone done this and what tips do you have? By my experience :- * TABLES / C_ISAM files under transaction :- If a particular transaction involves both "Pure" C-ISAM file (Having not referred in SE table) and TABLE under SE then A separate transaction for the C-ISAM file and SE TABLE is required to be handled.Under such circumstances, the C-ISAM transaction by default gets committed whereas the SE TABLE's transaction gets rolled back. This situation of handling "pure" C-ISAM file and TABLE under SE should be avoided to the maximum possible extent.It is better to convert all C-ISAM files to SE tables, particularly the C-ISAM files that is falling under transaction within SE - TABLES. If any more clarifications please do e-mail me. __________________________________________ HARINATH VENKATASUBBIAH, PSI DATA SYSTEMS LTD., BANGALORE , INDIA e-mail : hari@psi.ernet.in __________________________________________