RE: [WEB400] Multiple File Instances

["Andrew Borts" <Andrewb@xxxxxxxxxxxxxxxxxxx>]

What version of the OS?

Andrew Borts / Webmaster
Seta Corporation
6400 East Rogers Circle
Boca Raton, FL 33499

E-mail: Andrewb@setacorporation.com
Corporate web site http://www.setacorporation.com
E-Commerce web site http://www.palmbeachjewelry.com
                              http://www.myfreeitems.com
Voice: 561-994-2660 Ext. 2211 / Fax: 561-997-0774

-----Original Message-----
From: Ken Rhodes [mailto:kenr@palecek.com]
Sent: Monday, December 10, 2001 2:34 PM
To: 'web400@midrange.com'
Subject: [WEB400] Multiple File Instances

We are rather new to NetData and our AS/400 HTTPSVR. I setup a macro to
use
the DTW_SQL function to return a query to a web page. After running the
macro a few times, I decided to look at the QHTTPSVR job out of
curiosity. I
noticed that there were several instances of the open data files, the
ones I
used in the FROM clause, still listed as open. They were repeated over
and
over. They stayed this way until I stopped the server.

How do I control this? Specifically, close these files after the macro
finishes running?

Thanks,
Ken Rhodes
kenr@palecek.com
_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/web400
or email: WEB400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.