Re: qtemp, with jdbc access

[Vanja Jovic <vanjajovic@xxxxxxxxxxxx>]

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.