467,113 Members | 1,315 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,113 developers. It's quick & easy.

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

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
  • viewed: 5681
Share:
3 Replies
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
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Matthew Wells | last post: by
13 posts views Thread by Sehboo | last post: by
6 posts views Thread by Clive Dixon | last post: by
reply views Thread by =?UTF-8?B?0JTQsNC80ZjQsNC9INCT0LXQvtGA0LPQuNC10LLR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.