SQL SERVER Connection via JDBC

Hello everyone,

I was finally able to make the jdbc connection to SQL server from our Cloverleaf version 6.0.  This wasn’t difficult as I had thought.  I was able to connect to the SQL SERVER / table via database configuration, and then using the protocol database inbound or outbound.  I read the contents of a small tbl and sent the output to a file using an xlate to map in the routing.  This was easy.

Does anyone have some sample tcl scripts where I can insert or update a table in SQL server ?  Also, examples of code snippets in the xlate (inbound DB schema to outbound hl7 format?  Even preproc / post proc in a routing.

I just want to play and get a bit familiar with this.

Thank you,

Femina