Re: execute sql query

U can use JDBC driver to connect to AS400 and then use
normal prepared statement or statement to run the SQL
query.
Or u can write a stored procedure in RPG on AS400 and
call it using callable statement 
for more info visit
http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm?info/rzahh/page1.htm

--- Mihael Knezevic <m.knezevic@xxxxxxxx> wrote:
> hi,
> 
> i wanna execute an sql query on our iSeries. no
> problem with that. but
> how do i code the stuff, if the programm is executed
> directly on our
> iSeries and not on a pc without putting a username
> and a password into
> the sourcecode (without using record level access).
> 
> thanx in advance.
> 
> mk
> 
> _______________________________________________
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/mailman/listinfo.cgi/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 


__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com