Joined: 17 Oct 2004 Posts: 191 Location: hyderabad
Hi
the stored procedures are very effective in use & even there are some to tools to generate stored procedures,
these are similar to the cataloged procedures in JCl, but we need to have knowledge on SQLDA for stored procedures,these are a but tricky.you can look into the link below for more details