I am trying to use an ODBC DSN I have created, that uses the iSeries Access for Windows Driver, to download data from a file in QUSRSYS, to Excel.
I have to download from QUSRSYS because the file is IBM supplied. Note: QUSRSYS appears in QSYSLIBL system value.
The problem I have is that unless I manually type the SQL statement (which is a pain, as I need about 45 fields)I cannot get the ODBC wizard to use QUSRSYS. In fact, it will not use any library in QSYSLIBL. Instead, it always refers to the libraries in QUSRLIBL.
I have tried changing all the library references and definitions within the DSN but to no avail.
If I change the DSN to use any other, non-QSYSLIBL library, it works fine.
Is there some iSeries/ODBC restriction on the use of QSYSLIBL libraries? Or something I must set on the Server?
Any help would be much appreciated.
October 13, 2005 9:54 AM
November 15, 2009 4:19 AM