Re: mysql drawback - stored procedure default parameters not allowed

Tim suggested:

"...maybe a workaround might be to use a single JSON object
parameter which contains your actual parameters and then
pull them out of that?"

This is the approach I take to SQL stored procedures on the IBMi. I have two optional (default null) parameters: one is for JSON passed in by the calling program, and the other is for JSON returned to the calling program. I use the SQL JSON functions delivered with DB2 for i for all JSON processing.

I know you're on an earlier version of MySQL, but MySQL 8 has JSON functions.
https://dev.mysql.com/doc/refman/8.0/en/json-functions.html

Thanks,

Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
217-773-4486 ext. 12676
www.dotfoods.com<http://www.dotfoods.com/>
.