469,572 Members | 1,447 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,572 developers. It's quick & easy.

Text files in queries

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

Dec 8 '06 #1
2 1061
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
Dec 8 '06 #2
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
Dec 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Brian | last post: by
4 posts views Thread by Mark | last post: by
1 post views Thread by JosAH | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.