jc_compare and standardization

User 247a2c5018

09-10-2013 16:42:56

Hello,


 


with this query, i search if my structure is already in the database : 


 


$sqlstruid=OCIParse($link, "select stru_id, cd_id from sysadmin.sub_structure where jc_compare(cd_structure,:molfile1,'t:d')=1");


$blob_0=OCINewDescriptor($link, OCI_D_LOB);


OCIBindByName($sqlstruid, ':molfile1', $blob_0, -1, OCI_B_BLOB);


$blob_0->writetemporary($molfile1, OCI_TEMP_BLOB);


OCIExecute($sqlstruid);


                ocifetchstatement($sqlstruid, $ligstruid, 0, 1,OCI_FETCHSTATEMENT_BY_ROW);


ocicommit($link);


                $blob_0->close();


                $blob_0->free();


                OCIFreeStatement($sqlstruid);


 


I would like to know if my structure represented in the query by ":molfile1" is automatically standardized to compare with the cd_structure field?


 


When I create the structure table with JchemManager, I downloaded a custom xml file for standardization.


 


 


 

ChemAxon aa7c50abf8

10-10-2013 10:07:36

Hello,


The query structure is always Standardized using the same Standardizer configuration as was set/configured for the JCB-table/JChem-index to standardize the inserted structures (targets) with.


Peter