By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.