The SQL-statementes behind dbaccess

Hi I am about to write an application that does what dbaccess does. Why ? We can't let the users have the right to use the prompt in our system due to security issus. So I will have to write an NewEra application that does what dbaccess do. Anyone out there that knows what the SQL behind the sceens look like ? It would save me hours of work and thought, an URL or a mail or a respons here ? TIA Jan Nilsson pro IT jan@proitkarlstad.se

Jan Nilsson wrote: > Hi > > I am about to write an application that does what dbaccess does. > Why ? We can't let the users have the right to use the prompt in our > system due to security issus. > So I will have to write an NewEra application that does what dbaccess > do. > Anyone out there that knows what the SQL behind the sceens look like ? > It would save me hours of work and thought, an URL or a mail or a > respons here ? > > TIA > Jan Nilsson > pro IT > jan@proitkarlstad.se Why don't you consider providing users with SQLEditor and other utilities from either Informix's ROM or IECC? ROM is a pretty good tool - unfortunately, I believe that it isn't supported anymore. All the same, it doesn't seem to need any support at all. IECC is a superset of ROM and has tools which the average user would not want (should not get). However, it is supported by Informix. Rudy