Using stage DB Tcl API from hcitcl

[Jim Kosloskey]

CL 2209, Windows

I have been playing around with the DTC Protocol and now I would like to construct some utilities to ‘see’ into and manage the stage db. I am told it is an SQLite DB but 2 tools I have for viewing SQLite DBs reject it as an SQLite DB. I note in the Documentation there are a set of commands for interacting with the stage DB and one of those is ‘stageinit’ which the documentation indicates needs to be executed first if using hcitcl.

So, I started hcitcl and typed in ‘stageinit’ (there is supposed to be a process name as an argument) and that returned :

Error: invalid command name “stageinit”

I suspect these commands are in a file not in my pathing but I have no idea what file and where it is.

Has anyone successfully executed the stage DB Tcl API commands and if so, what did you do to get them recognized by hcitcl?

Thanks

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

Topic

[John Mercogliano]

Hi Jim,

The stage db is encrypted by default using the site name but I have successfully poked around.  In 20.1, I found that stageinit and stagegetkeys are not defined.  But if you use stageset it will create the stage database if it does not exist so the commands appear to be available with or with out a dtc connection in the site.  I’ve only found a need to use the DTC tcl api calls in my one project I’ve done so far.  Also, under the root tclprocs directory you will find a dtc.tcl that has the dtc api which are just wrappers for the stageget and set commands.  Once I figured it out, I did like how the dtc protocol worked.

• This reply was modified 6 days, 11 hours ago by John Mercogliano.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[Jim Kosloskey]

John,

Thanks for the info. I will investigate. If I have any additional questions, would you be willing to commiserate off-line? If so, just send me an email.

 

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

[Jim Kosloskey]

John,

Upon investigation and in keeping with your observation, it appears like the Stage DB Tcl API (stageinit and stagegetkeys for example) is not provided even though it is documented.

In reality the protocol fairly cries for a Gui tool to browse the Stage DB (like for SMAT DB or the DB Admin). I was hoping to use the documented Stage DB Tcl API commands to provide a command line utility or set of utilities to expose the Stage DB for analysis and debugging.

Apparently, that is not possible in a release as late as 2209. Maybe 2205 has provided the API that is documented.

I too like the DTC protocol and have used it once. I feel it needs to be polished however and have made suggestions. Time will tell if it gets more polished.

In my opinion, it has some real limitations for usability for message enrichment in all potential scenarios. But to truly make orchestration and enrichment fully functional I think the Xlate will need to be modified as well to allow the definition of multiple IB messages to accomplish a merge function.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

[Author]

Replies