Let the job create the QTEMP file normally. Use a simple JDBC access to read or write to the file in QTEMP.
JDBC is dynamic and can pick up newly generated tables. Use the JDBC driver in the Java toolkit for testing for example.
It is in the jt400.jar file IBM distributes with the toolkit on the iSeries. Check for program 5722-WDS or 5769-JC1 installed on your iSeries. A typical URL for the toolkit driver might look like:
String URL = "jdbc:as400:myserver/Qtemp";
A select statement string like:
String SQL = "SELECT * FROM MYTABLE";
For my, see the JDBC Faqs in the Java toolkit. You could also use the local iSeries JDBC driver if the application runs on the iSeries server.
================================== MORE INFORMATION ON THIS TOPIC ==================================
Ask your Web development questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: tips, tutorials and more.
Check out this live Q&A with Dave Slater and Jim Mason, How to best get started with WebSphere Development Tools.
This was first published in October 2002