How do I call query on linked AS/400?

• andy.gear

  SSC-Addicted

  Points: 493

  More actions

  January 14, 2009 at 10:48 am

  #130061

  So I have the ODBC connection set up and working fine between the SQL server and my AS/400. I can query just fine:

  select * from LINKED_SERVER.NAME.LIBRARY.FILE

  What I would like to do now is:

  exec LINKED_SERVER.NAME.LIBRARY.QUERY

• andy.gear

  SSC-Addicted

  Points: 493

  More actions

  January 15, 2009 at 8:07 am

  #927342

  Here's my super awesome cheaty way to do this easily. I wrote an FTP batch file

  that 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 stored

  procedure 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!