Skewness in teradata
tom
Currently, I work on a Teradata machine. I understand that Teradata is based on the idea that processes work in parallel with each other. The idea is that data are…
Get data from Oracle
There exist many ways to get data from Oracle. After all, this is the core functionality of Oracle: getting data in and out. A nice possibility is to retrieve data…
The foreign key in Oracle XE
Oracle has introduced a small version of its DBMS that is labelled “XE”. This small version can be downloaded and used for free upon the condition that its usage is…
How many non-nulls per column?
In Oracle, it is quite well possible to display quickly how many non-nulls we have per column in a table. The script reads like: set termout off echo on feed…
How many records in a table?
Recently, I encountered a very nice script that allows us to get an overview of the number of records per table in an Oracle scheme. First the script: set termout…
ASCII or EBCDIC: how to recognise it?
Today, I heard someone complaining that he received a file that contained “unexpected characters”. Later it was discovered that this file was provided in EBCDIC and the receiver tried to…
A set of tables and content
Yesterday, I encountered a small but convenient script that creates and loads a set of tables in an Oracle environment. It was part of an Informatica training, so I have…
A date dimension
Today I had to create a date dimension. This is a dimension that provides us with a list of records that contains the weekdays, the number of a month etc.…
JCL or the stern face of a main frame
I realise that working on a main frame can be very intimidating. Look at the JCL: the job language that you use to get things done. This is the way…
Querying a Db2 database on a mainframe
Recently, I was in a situation where I had to query a Db2 database on a mainframe. I was also in a situation where the knowledge and documentation on that…