| View previous topic :: View next topic |
| Author |
Message |
Shayler Rychlick
Guest
|
 Posted: Thu Jun 26, 2003 5:55 pm Post subject: Using TQuery to Access DB2 File with Members? |
 |
|
I am trying to get data out of a DB2 File (Table) that has different Members
inside the File. Does anyone know how to specify a different member inside
the file?
For examble: " Select * from MyLibrary.MyFile.MyMember where field1 = 1 "
I tried this SQL statement but it does not work.
|
|
| Back to top |
|
 |
Shayler Rychlick
Guest
|
| Posted: Fri Jun 27, 2003 5:55 pm Post subject: Re: Using TQuery to Access DB2 File with Members? |
|
|
I Figured it out. I had to create an alias in DB2 (not in ODBC or BDE) that
stays on the DB2 in a library you specify which points at the library, file,
member that you want and you access it the same way you access a DB2 File.
.......Long Live DB2 ;-)
"Shayler Rychlick" <shaylerr (AT) netzero (DOT) com> wrote
| Quote: | I am trying to get data out of a DB2 File (Table) that has different
Members
inside the File. Does anyone know how to specify a different member
inside
the file?
For examble: " Select * from MyLibrary.MyFile.MyMember where field1 = 1 "
I tried this SQL statement but it does not work.
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
