Changes between Version 3 and Version 4 of i2b2 HowTo Create an Ontology

Timestamp:

10/03/13 10:00:34 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create an Ontology

@@ -126 +126 @@
                 @DataDatabaseName VARCHAR(50) -- The name of the Data Database in which to create the Ontology, e.g. 'i2b2_b1_data'
                 
-SET @OntologyName = 'Test CiviCRM'
+SET @OntologyName = 'TestCiviCRM' -- Must not contain spaces
 SET @Prefix = 'TestGenCV'
 SET @OntologyDescription = 'TestGenvasc Study Details from CiviCRM'
@@ -214 +214 @@
 SET @OntologyID = SCOPE_IDENTITY();
 
-SELECT @OntologyID;
-
 -- Create the ontology base code
 
@@ -259 +257 @@
       ,[VALUETYPE_CD]
   FROM [i2b2ClinDataIntegration].[dbo].[i2b2Ontology]
-  WHERE OntologyID = ' + @OntologyID;
+  WHERE OntologyID = ' + CONVERT(VARCHAR(10), @OntologyID);
    
 EXEC (@TCreateBaseInOntologyTable);
@@ -280 +278 @@
       ,[UPLOAD_ID]
   FROM [i2b2ClinDataIntegration].[dbo].[i2b2OntologyConceptCodes]
-  WHERE OntologyID = ' + @OntologyID
+  WHERE OntologyID = ' +  + CONVERT(VARCHAR(10), @OntologyID);
    
 EXEC (@TCreateBaseConceptTable);
@@ -288 +286 @@
 ----------------------------------------------------------------
 
-
-}}}
+}}}