468,242 Members | 1,496 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

SELECT of Members

Hi,

I just wondered how I can do a SQL SELECT on a table that has more than one
member and I want do specify the name of the member. I tried
select * from filename(member)
and
select * from filename.member
Both didn't work. Any ideas?

Michael
Aug 1 '07 #1
3 10100
On Aug 1, 7:58 am, Michael Roppel <m.rop...@kapsgmbh.dewrote:
Hi,

I just wondered how I can do a SQL SELECT on a table that has more than one
member and I want do specify the name of the member. I tried
select * from filename(member)
and
select * from filename.member
Both didn't work. Any ideas?

Michael
Hello, I am not sure I understand your question but if you mean that
"filename" is the name of the table and "member" is a column in the
table and you would just like to list that column then you would just
need to do:

select member from filename
or
select * form filename where member = 'somename'

or are you wanting to just list all the columns of the table?? In that
case :

db2 describe table filename

Aug 1 '07 #2
Michael Roppel wrote:
Hi,

I just wondered how I can do a SQL SELECT on a table that has more than
one member and I want do specify the name of the member. I tried
select * from filename(member)
and
select * from filename.member
Both didn't work. Any ideas?
If you are using DB2 for i5/OS (System i, iSeries, AS/400) you could
create an alias:
http://publib.boulder.ibm.com/infoce...atingalias.htm

--
Karl Hanson
Aug 1 '07 #3
Thanks, that is what I wantet to know!
Michael

Karl Hanson schrieb:
Michael Roppel wrote:
>Hi,

I just wondered how I can do a SQL SELECT on a table that has more
than one member and I want do specify the name of the member. I tried
select * from filename(member)
and
select * from filename.member
Both didn't work. Any ideas?

If you are using DB2 for i5/OS (System i, iSeries, AS/400) you could
create an alias:
http://publib.boulder.ibm.com/infoce...atingalias.htm
--
Karl Hanson
Aug 2 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by callmebill | last post: by
14 posts views Thread by Jos? | last post: by
4 posts views Thread by wizard_chef | last post: by
4 posts views Thread by jmDesktop | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.