View previous topic :: View next topic
|
Author |
Message |
parag manilal chheda
New User
Joined: 02 Oct 2008 Posts: 2 Location: mumbai
|
|
|
|
hi
i m getting the error DSNH3121 SAYING "UNDEFINED OR UNUSABLE HOST VARIABLE".
THE VARIABLE NAMES AND THE DATA TYPES ARE SAME IN THE PROGRAM & DECLGEN FILE.
CAN ANYBODY TELL WHAT IS THE PROBLEM.
THANKYOU. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 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
|
|
Back to top |
|
|
parag manilal chheda
New User
Joined: 02 Oct 2008 Posts: 2 Location: mumbai
|
|
|
|
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" |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 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. |
|
Back to top |
|
|
|