Problem solve Get help with specific problems with your technologies, process and projects.

Create a module with /EXEC SQL statement inside

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.


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.

This was last published in July 2002

Dig Deeper on iSeries COBOL programming

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

Use OBJTYPE(*MODULE) in your CRTSQLRPGI command.