I'm new to SQL 7 and I have a problem viewing logical files from the AS400. When I try to import data into SQL using DTS from the AS400 it sees all the physical files fine but just can't see the logicals which are in the same library. I am using a Client Accesss ODBC Driver (version 5) for the data source and when I use the same data source to import details from the AS400 into Cognos or Crystal Reports I CAN see logical files aswell as physicals. I thought you could see tables and views from the AS400 in SQL.
I there anywhere I can tell it to retrieve not only physical files but also logicals or system tables etc.
Any help would be greatly appreciated.