User 4140faeba5
21-07-2005 07:15:42
Hi.
SQL> select jchem_core_pkg.getenvironment() from dual;
JCHEM_CORE_PKG.GETENVIRONMENT()
--------------------------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
JChem version in the database: 3.0.13
JChem version in the Tomcat server: 3.0.13
java.vm.version: 1.4.2_08-b03
java.vm.vendor: Sun Microsystems Inc.
Apache Tomcat/4.1.31
Attached are two molecules. q.txt and nohit.txt
This is my query
select JCHEMTEST.BVTCIMS.compound_id,JCHEMTEST.BVTCIMS.molfile from JCHEMTEST.BVTCIMS where jc_compareb(JCHEMTEST.BVTCIMS.cd_structure,(select molfile from temp_mol where pkey = 126), 't:e HCountMatching:G doubleBondStereo:M')=1 order by JCHEMTEST.BVTCIMS.compound_id
Using nohit as query mol hits itself and the q.txt with exactIsotopeMatching:n set, and hits only itself with exactIsotopeMatching:y.
But using q.txt as query mol it only hits itself regardless or exactIsotopeMatching setting.
How do I get it to hit its parent also (ie the nohit.txt) ?
/Micke
SQL> select jchem_core_pkg.getenvironment() from dual;
JCHEM_CORE_PKG.GETENVIRONMENT()
--------------------------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
JChem version in the database: 3.0.13
JChem version in the Tomcat server: 3.0.13
java.vm.version: 1.4.2_08-b03
java.vm.vendor: Sun Microsystems Inc.
Apache Tomcat/4.1.31
Attached are two molecules. q.txt and nohit.txt
This is my query
select JCHEMTEST.BVTCIMS.compound_id,JCHEMTEST.BVTCIMS.molfile from JCHEMTEST.BVTCIMS where jc_compareb(JCHEMTEST.BVTCIMS.cd_structure,(select molfile from temp_mol where pkey = 126), 't:e HCountMatching:G doubleBondStereo:M')=1 order by JCHEMTEST.BVTCIMS.compound_id
Using nohit as query mol hits itself and the q.txt with exactIsotopeMatching:n set, and hits only itself with exactIsotopeMatching:y.
But using q.txt as query mol it only hits itself regardless or exactIsotopeMatching setting.
How do I get it to hit its parent also (ie the nohit.txt) ?
/Micke