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.…
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.…
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…
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…
Once you are on a mainframe, the most important command is: =3.4. This command is issued on the command line of the so-called ISPF screens. See: If you are in…
When I entered the world of the mainframe, I realised that this is a world on it own; it has their own rules and newbies are not easily accepted here.…
With SAS, I see SAS DI Studio being more and more employed to write data loading jobs. It is understandable to see this development. Within a data warehouse environment we…
I now work with a mainframe. I realised once more that numeric variables have different formats on a mainframe. As we do not always have a clear description, we should…
I recently encountered a situation whereby surrogate keys were used as primary keys. It looks as a reasonable choice; since the so-called SCD2 mechanism was also used to store historic…