nastacio

#!/bin/bash

set -e
set +x

curdir=`pwd`
scriptdir=`dirname "${0}"`
scriptname=`basename "${0}"`

#

nastacio

--
-- Count of clinical trials for each intervention type
--
select i.intervention_type, count(distinct i.nct_id)
from 
    interventions as i
group by
    i.intervention_type

--

nastacio

        try {
            Hashtable<String, String> env = new Hashtable<>();
            env.put(Context.INITIAL_CONTEXT_FACTORY, "com.sun.jndi.fscontext.RefFSContextFactory");
            env.put(Context.PROVIDER_URL, "file:/Users/nastacio/tmp/jndi");
            InitialContext ctx = new InitialDirContext(env);
            for (Entry<String, DB2SimpleDataSource> ds : dss.entrySet()) {
                String name = ds.getKey();

                CompositeName cn = new CompositeName(name);
                Context subCtx = ctx;