471,897 Members | 1,913 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,897 software developers and data experts.

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 1084
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.