This is source code that has the input of mixed SPL source and m4 macros to produce
SPL source for the GetRank stored procedure.

Download Zip File

Input files:
StdMacros.m4 : m4 macros that are useful for writing other packages of m4 macros
SqlDtaTypeMacros.m4 : m4 macros for SQL data types
SqlPrcMacros.m4 : m4 macros that are useful fro writing SPL stored procedures
GetRank.sqlm4 : Mix of SPL and m4 macros to define the GetRank stored procedure

Output file:
GetRank.sql : SPL source to create the GetRank stored procedure.

Produced by:
Paul Conte
pconte@picante-soft.com

More info:
"Boost SQL Code Reuse with Macros"
iSeries NEWS nagazine
June 2006
http://www.systeminetwork.com/