Unanswered: Need help in displaying Console messages from stored procedure
I have created an external stored procedure using language SQL. I am running the code in As400. So, I want a way to route messages to QSYSOPR from stored procedure. Like in COBOL OR RPG we have commands to display messages in QSYSOPR, I searched a lot but am not able to find out any code that displays console messages from SQL stored procedure. Since, we are in the process of converting COBOL/RPG codes to stored procedures, I can't use any of these languages to display console messages. PRINT, SPOOL commands are not working here. Please suggest. I will appreciate any help that I get.