I was under the impression that stored procedures on the AS400 had to be written in cobal, C, or RPG, but that it does not support sql. I notice, however, the SPB (IBM's Stored Procedure Builder) claims it supports the AS400, but it only lets you write stored procedures in SQL and Java. So does the AS400 actually support SQL stored procedures, or does SPB translate it into a format the AS400 does understand?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Does as400 support sql stored procedures 1
- Thread starter ddiamond
- Start date
-
1
- #2
Sure you can:
Dic mihi solum facta, domina.
Dic mihi solum facta, domina.
- Thread starter
- #3
- Thread starter
- #5
I don't know how to do it using .dtt files, but it is fairly easy to create a table on the as400 based on an excel spread sheet using MS ACCESS and ODBC. Simply link to, or import your excel spreadsheet into access. Then export to the AS400 using iSeries ODBC drivers.
- Status