In Version 8 Relational Connect and other have been replaced by DB2 Information Integrator for Data.
What you need are the relational wrappers, included in the the IIRW component.
For the SQLServer access: which SQL Server are you talking about?
For Sybase I would suggest you install the sybase client on your machine, and create a sybase wrapper.
(I guess in earlier times when there was only one SQL Server that would even have worked with MS)
For Microsoft, and I guess that is what you want to do, that is not too simple. They do have
- an JDBC driver
- XML and HTTP (Webservices)
- DBLibrary - some kind of client software
For federation you probably can do the XML Stuff (but you will need an HTTP server), I am not sure whether the DBibrary supports something like ODBC, but this is very well possible. I have no experience with that.
Where to get AIX ODBC Connect you should find in the AIX Supplements, i never had to do that myself.