How can I execute SQL(in AS400 Environment) in DOS command??
Printable View
How can I execute SQL(in AS400 Environment) in DOS command??
"Sphenix" <Sphenixs@gmail.com> writes:
[color=blue]
> How can I execute SQL(in AS400 Environment) in DOS command??[/color]
You may want to use sQL Navigator (java, requires JRE) with the
JDBC-driver in the java toolbox for as400 (search for jtopen).
--
Thorbjørn Ravn Andersen
SQL Navigator ??
wat program is that??freeware??
"Sphenix" <Sphenixs@gmail.com> writes:
[color=blue]
> SQL Navigator ??
> wat program is that??freeware??[/color]
Sorry, I remembered incorrectly.
The name of the product I was thinking about is DbVisualizer, and is
freely available from
[url]http://www.minq.se/products/dbvis/[/url]
The Free version just requires registration. I have used it with
Oracle and DB2/400.
--
Thorbjørn Ravn Andersen
Actually I dont want any 3rd party tools involve, is there any tools in
"C:\Program Files\IBM\Client Access" can be execute SQL in DOS command??
Write a VB program that can be called with a command line.
Then have it execute your SQL commands. This can be done with minimal code
using the CA/400 ODBC driver or .Net driver.
Regards,
Richard Schoen
RJS Software Systems Inc.
"Providing Your....iNFORMATION NOW!"
Email: [email]richard@rjssoftware.com[/email]
Web Site: [url]http://www.rjssoftware.com[/url]
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
"Sphenix" <Sphenixs@gmail.com> wrote in message
news:1162371629.008418.241930@i42g2000cwa.googlegroups.com...[color=blue]
> How can I execute SQL(in AS400 Environment) in DOS command??
>[/color]