Infrastructure at your Service

All posts by Cesare Cervini

Cesare Cervini



Cesare Cervini

A password() function for dmgawk

By | Entreprise content management | No Comments

A few days ago, as I was preparing a dmawk script for a presentation, I stumbled against another unexpected error. The script was attempting to connect to a docbase by providing a docbase name, a user name and a password. But before that, it tested whether a password was provided as a command-line parameter (I know, this is not very secure but it was for demonstration purpose only); if not, it prompted for one using…

 
Read More
Cesare Cervini

An awk filter to truncate or wrap around tabular output

By | Entreprise content management | No Comments

In my previous blog “idql and its column output”, see link here, I provided a small awk filter to reflow the idql output’s columns by wrapping their content around. Later I came of thinking that it could be useful to be able to truncate the columns instead, in order to have an even compacter output. A shorter, denser table can certainly help is some cases, such as when a quick overview of a query’s result is…

 
Read More
Cesare Cervini

Adding a Documentum Extension to gawk, part II

By | Entreprise content management | No Comments

This is part II of the article “Adding a Documentum Extension to gawk”. You can find Part I here Before we can test the extension, we need a test program and some helper functions for comfort. Let’s prepare them. o  Move back to the dmgawk directory and edit DctmAPI.awk, the wrapper functions; $ cd ../../.. $ pwd /home/dmadmin/gawk $ vi DctmAPI.awk o  Cut and paste the lines below: @load “dctm” # provides high-level function to do Documentum…

 
Read More
Cesare Cervini

Adding a Documentum Extension to gawk, part I

By | Entreprise content management | No Comments

Recently, I was searching my NAS for some files which, to end this intolerable suspense, I did not find but on the other hand I did stumbled across a couple of interesting dmawk scripts I wrote for on customer more than 20 years ago. Some statements looked a bit odd, e.g. access to elements from multi-dimensional arrays such as “a[i1][i2]”, or “delete A” to empty an array (instead of the well-known awk idiom split(“”, A))….

 
Read More
Cesare Cervini

Adding a Documentum extension into python

By | Entreprise content management | No Comments

Many years ago, out of frustration by the poorness of scripting tools in Documentum, I realized a Documentum binding for python using the distutils and I remember how easy and straightforward it had been, even for someone not really into these things on a daily basis. Recently, I wanted to reuse that work but couldn’t find the source files, not that they were many, but I did not want to do it over again. Finally,…

 
Read More
Cesare Cervini

idql and its column output

By | Entreprise content management | No Comments

idql and its column output A few days ago, I was reading an interesting blog from distinguished colleague Clemens Bleile with the title “sqlplus and its column output” (link here https://blog.dbi-services.com/sqlplus-and-its-column-output/) and I said to myself: the lucky Oracle administrators and developers have sqlplus, a rather good, out of the box command-line tool to talk to their databases. What equivalent tool do we have with Documentum ? Well, we have mainly idql, which, to put…

 
Read More
Cesare Cervini

Another surprising journey in Documentum-land

By | Entreprise content management | No Comments

The journey begins In a VM Oracle VirtualBox with Centos Linux 7.0, you install Documentum v7.3 and create a docbase dmtest with its schema in a database on another VM running Oracle Linux. You start the newly created docbase and successfully connect locally to it from within iapi or idql. You smile with satisfaction and go on. It’ll be a walk in the park, you think. In another VM, a client, running under Ubuntu 16.0.3 (you…

 
Read More