Can I ask a program source code for native sql stored procedure used in db2 zos. I want to have a pattern for the stored procedure. I can't seem to find one in the internet. I only find books for LUW. If it is too much to ask please include the DECLARE, CASE, CALL, IF ELSE statement.
I really need it badly for I can't see no resources in our office. This is totally new for me and I am clueless.
Thanks a lot in advance.!!! I know that this is too much. I don't know someone who really knows how to use this language
As far as I saw briefly in "DB2 Version 9.1 for z/OS SQL Reference",
there are very few differences in syntax(except option-list)
between external SQL stored procedure(traditional) and native SQL stored procedure(new in DB2 9.1 for z/OS).
One major difference I realized was native SQL stored procedure supports FOR statement.
It wes not supported on DB2 8 for z/OS.