How can I create a module with /EXEC SQL statement inside? The command CRTRPGMOD does not recognize the /EXEC SQL statement and CRTSQLRPGI does not create module.
The host language SQL book can be found here. The limitations that I found do not indicate that you cannot create a module, which would indicate that it is a syntax problem. Some limitations include use of variables that begin with 'SQ', 'SQL', 'RDI', or 'DSN' as these are reserved prefixes. In addition, you must prefix all host variable with ":" and cannot use UDATE type fields, multiple dimension arrays, pointers and a whole host of other variables.
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.