Joined: 20 Oct 2006 Posts: 6970 Location: porcelain throne
look at your precompiler listing.
If the copybook that contains the host variables has been expanded (via an SQL INCLUDE),
and you can find them in the listing,
you have either bad host variable definitions- data types are non-compatible
you did not use the :HOST-VAR syntax. that is colon - : - host variable reference
I haven't used the copybook, & the data types are also compatible.
The error coming is " An EXEC SQL INCLUDE stmt was found but SQL compiler was not in effect"
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Hello,
You need to check with you dba or whoever supports the standard compile/link jcl. It sounds like you may be using the wrong jcl and they can tell you which jcl you should use.
When you post error information, you should post more completely and make sure you include the message id that came with the message text.