Thanks for the reply Sushanth Bobby - that is the route I have started going down. With a bit of tweaking it should get me just what i'm looking for!

Hi,

I'm after some help with a view I am trying to create, but Im not sure if I am going about it correctly

I have hundreds of log tables, can be any number created within a month. I need to identify the last 3 months worth and union them together into one view.

I can get the log table created date/time from syscat tables which helps me identify which tables I need look at but I am unsure how to incorpoate...