Re: SPL conversion to DB2

ackerbau@us.ibm.com wrote: > I'm not really converting Informix stored procedures to DB2, but I *am* > trying to learn DB2. One would think I could ask any number of people here > at New Blue, but I'm trying to approach it from my Informix background, and > there's only about 3 people in the continental U.S. who have dual expertise > (and they don't advertise). > > My questions are many, but for starters to any DB2/Informix dual experts: > > Can you point me to some readable documentation for how to create DB2 > stored procedures? (i.e. readable syntax; vanilla sample code welcome) > Can I execute DB2 stored procedures from the command line (i.e., pipe an > execute statement to the "db2" command, a la dbaccess)? If so, what is the > syntax? > > Any and all RTFM pointers (read, show me the URL) are greatly appreciated. > > -mka > > Michael Ackerbauer > SP Platform Evaluation Test MIchael my team and i were involved in the use of as/400, this plataform use db2 as his main database well so in this link www.news400.com you can find some information and in this http://www.news400.com/communities/sqldb/indexNEW.cfm , you are going to find a specific information. Now if you want information from the guy's in blue you can point at http://www.redbooks.ibm.com/, in this web site you can find any red book that IBM use , for example if you want to know about the POSIX implementation for AS/400 , you can find the reedbook here, this reedbook's are a collection of examples, and i find what you are looking for in this site this is the name of the reedbook in this site Developing Cross-Platform DB2 Stored Procedures: SQL Procedures and the DB2 Stored Procedure Builder, SG24-5485-00 Published 16-Dec-1999. You are going to find this link inthis place good luck and see'ya