Re: qtemp, with jdbc access

Yes you can, it's probably matter of understanding what QTEMP you use.
QTEMP in question will always be the one contained in server job
supporting your jdbc connection. So you might me shooting for the wrong
one in more complex scenario.

Vanja Jovic,
Canada

thatzenbeler@clinitech.net wrote:

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]

Can I use QTEMP  from a java program...  I tried using the following code,
and it didn't work... I was wonder, if anybody has any ideas..

this one failed....

     stmt.executeUpdate ("CREATE ALIAS QTEMP.FILE1COMPARE FOR
DEVTIMH.QRPGILESRC(CPYTOIFS)");

     ResultSet  rs = stmt.executeQuery ("SELECT * FROM QTEMP.file1compare");


This one worked...

     stmt.executeUpdate ("CREATE ALIAS QGPL.FILE1COMPARE FOR
DEVTIMH.QRPGILESRC(CPYTOIFS)");

     ResultSet  rs = stmt.executeQuery ("SELECT * FROM QGPL.file1compare");

Thanks,  tim


This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.