By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

SELECT of Members

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.