A SQL question

Hello, all My environment is IDS7.31 & Solaris2.5. My question is : In sysmaster, there is a fname column in syschunks table. In database dsm, there is also a fname column in fragment table. What I want to do is to find all the fnames which are in dsm.fragment and are not in syamaster.syschunks. It is this possible in one SQL statement? A query like select fname from dsm.fragment where fname not in (select fname from sysmater.syschunks) Harry

I cannot get my VB6 MTS component to open an ADODB connection if the MTS component is marked as "Requiring a transaction" or "Requires a new transaction". The error message I get is "General error". If the component is marked as "Not an MTS component" then I can open a connection, update the database etc. According to the ODBC driver documentation from Informix the version of the driver I am using supports MTS. Is anybody using MTS and Informix who may be able to give me some tips? Regards

Hi Harry, as long as the "dsm" database uses logging, it will work. Otherwise you might use a workaround: database sysmaster; unload to "xx" select distinct fname from syschunks; database dsm; create temp table fnames_temp( fname varchar(240)); load from "xx" insert into fnames_temp; select * from fragment where fname not in (select fname from fnames_temp );!rm -f xx Best regards, Stefan Harry Sheng wrote: > > Hello, all > > My environment is IDS7.31 & Solaris2.5. > My question is : > In sysmaster, there is a fname column in syschunks table. > In database dsm, there is also a fname column in fragment table. > What I want to do is to find all the fnames which are in dsm.fragment > and are not in syamaster.syschunks. > > It is this possible in one SQL statement? > A query like > > select fname from dsm.fragment > where fname not in (select fname from sysmater.syschunks)> > Harry -- Stefan Weideneder Phone: +49 89/3565478-2 --------------- --- Fax: +49 89/3565478-3 ------------- ------ mailto:/stefan@weideneder.de --- -------- http://www.weideneder.de -----