InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 08:59:03 GMT20http://www.sqlservercentral.com/Forums/Topic636465-338-1.aspxHere's my super awesome cheaty way to do this easily. I wrote an FTP batch filethat FTPs into the AS400 and runs the query with: quote rcmd runqqry qry(lib/qry)The FTP batch file is executed on the SQL 2005 server by use of a storedprocedure containing the line:EXEC master..xp_cmdshell 'ftp -n -s:d:\ftp_scripts\batch.ftp'Then I grab the output like normal through use of the linked servers. And viola!Thu, 15 Jan 2009 08:07:06 GMTandy.gearhttp://www.sqlservercentral.com/Forums/Topic636465-338-1.aspxSo I have the ODBC connection set up and working fine between the SQL server and my AS/400. I can query just fine:[code]select * from LINKED_SERVER.NAME.LIBRARY.FILE[/code]What I would like to do now is:[code]exec LINKED_SERVER.NAME.LIBRARY.QUERY[/code]Wed, 14 Jan 2009 10:48:05 GMTandy.gear