Text files in queries

[apattin]

Hi,

I find that I am constantly using IMPORT and LOAD to create temporary
tables to use in queries. It all works fine, but it's time consuming
and boring. Is there a better way? I was reading about federation, but
it was not clear if this was total overkill for what I want to do. For
example, I could set up a local (on my PC) db that somehow manages the
text files and then build multi-server queries. Is any of this
possible?

Thanks,

Alejandrina

[apattin]

Wanted to clarify we're using UDB 8.1.

apattin wrote:

Hi,

I find that I am constantly using IMPORT and LOAD to create temporary
tables to use in queries. It all works fine, but it's time consuming
and boring. Is there a better way? I was reading about federation, but
it was not clear if this was total overkill for what I want to do. For
example, I could set up a local (on my PC) db that somehow manages the
text files and then build multi-server queries. Is any of this
possible?

Thanks,

Alejandrina

[Knut Stolze]

apattin wrote:

Hi,

I find that I am constantly using IMPORT and LOAD to create temporary
tables to use in queries. It all works fine, but it's time consuming
and boring. Is there a better way? I was reading about federation, but
it was not clear if this was total overkill for what I want to do. For
example, I could set up a local (on my PC) db that somehow manages the
text files and then build multi-server queries. Is any of this
possible?

It may be a good idea if you provide more details on what exactly you want
to achieve...

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany