"spool" file? Is it simply a "flat" file (i.e. - text file)? If yes, then just FTP it down to your web server or better yet a "file" server.<BR><BR>Now as for what to "read" it with, well that really depends on what it contains and what you are trying to do with it. Also, how big the file is MAY make a difference. ; )<BR><BR>Pete
If it is being dynamically generated on the as400 you may have read permission problem if the file is being written to.<BR>How often is it updated? If not often then you might want to FTP to your server and read it locally or update a DB table. If you are using SQL or Oracle there are tools to grab that data and insert it .
I pass an invoice# to the as400 which generates this file. It takes about 15 secs to generate. I have a process that checks if the file is there every 5 secs.I then read and display the data on the web. I was hoping i could read it directly without using Ftp as this would save time. Updating a Db or sql table is not an option.
flag appears in the database, why not just FTP it to your server and read it?<BR><BR>Or better yet, setup a trigger on the AS400 side of things to automatically FTP the file when the "flag" appears. <BR><BR>Or the best option since it sounds like you have an AS400 DB2 database is to just create a database table for these requests and load it with this info. You could then simply query this database table with ASP/ADO just like you would any other data source.<BR><BR>I think you may need to re-think this one a little.<BR><BR>Pete