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

DB2 SQL and Members

P: n/a
Hi, Im trying to access some data at an AS/400 db2 server, the tables
have members, i have already accessed them with odbc by creating an
alias to that member and then making the select statements to that
aliase like shown below.
CREATE ALIAS TDADBFV3R0.ALIASNAME FOR TDADBFV3R0.TABLENAME (MEMBER);
SELECT * FROM TDADBFV3R0.ALIASNAME;
Whit this, the data at the table TABLENAME that belong to the menber
MEMBER is shown. But my question is, how can i see all the members of
that table? i have no acces to OVRDBF nor any other AS/400 db2
command, all i have is SQL with ODBC.

Hope you can help, thanks
Rodrigo

Mar 29 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.