Re: Java Programs that Access Files created in QTEMP

Yes, you are correct.  I decided to just use the JDBC connection handle and
pass it around in the application.  This way I was able to create files in
QTEMP and read from them using SQL Statements. I can do what I need to do
in SQL and do not have to use CL and RPG.  Thanks.





Andrew_Goodspeed@lbss.com@midrange.com on 07/25/2000 12:00:43 PM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   JAVA400-L@midrange.com
cc:

Subject:  Re: Java Programs that Access Files created in QTEMP




It has been a while since I last played with server-side JDBC, but I am
pretty
sure that it (still) goes through a separate server job for the SQL
requests.
Since the JDBC server job has a different QTEMP than the Java, CL, and RPG
programs, you will not find the file that you want.

Andrew Goodspeed
London Bridge Group
Atlanta (Norcross), GA  USA



>The programs would run on the AS400.  I was thinking about using a Java
>program that called a CL/RPG to create a file in QTEMP.  The file would
>then be used by the Java program to do some processing.  JDBC request
would
>be made by the Java program using the native driver.


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---