SQL Tools for AS400/DB2?? What are you using?

Russ

My company is running DB2 on AS400 iSeries V5R3 and making a strong
push to move from RPG/External stored procs to SQL stored procs. My
background is Oracle/SQL Server and am used to using some "SQL Tool" to
assist in creating and modifing stored procs. We are currently limping
along using the SQL editor that comes with iSeries Navigator and
quickly realizing that it's not very user friendly. Especially for
someone without AS400 "green screen" experience.

What tools are other companies using to develop DB2/400 stored procs?

Thanks!
Russ

May 3 '06 #1

Kiran Nair

If your company uses DB2 Connect, you can use DB2 development
center(v8) or eclipse based DB2 Developer Workbench (v9,v8) .
Regards,
Kiran Nair

May 3 '06 #2

Kent Milligan

In addition to DB2 Development Center/Workbench, you can use any ODBC or
JDBC-based tool. A couple customers said they were using Squirrel.

Kiran Nair wrote:

If your company uses DB2 Connect, you can use DB2 development
center(v8) or eclipse based DB2 Developer Workbench (v9,v8) .
Regards,
Kiran Nair

--
Kent Milligan
ISV Enablement - System i
km***@us.eye-bee-m.com (spam trick) GO HAWKEYES!!

ibm.com/iseires/db2

(opinions stated are not necessarily those of my employer)

May 4 '06 #3

Jack Miller

Russ,

Try WinSQL http://synametrics.com/winsql

Thanx,
Jack
Russ wrote:

My company is running DB2 on AS400 iSeries V5R3 and making a strong
push to move from RPG/External stored procs to SQL stored procs. My
background is Oracle/SQL Server and am used to using some "SQL Tool" to
assist in creating and modifing stored procs. We are currently limping
along using the SQL editor that comes with iSeries Navigator and
quickly realizing that it's not very user friendly. Especially for
someone without AS400 "green screen" experience.

What tools are other companies using to develop DB2/400 stored procs?

Thanks!
Russ

May 10 '06 #4