UNDEFINED or UNUSABLE HOST VARIABLE

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.

dbzTHEdinosauer · Posted: Thu Oct 02, 2008 1:31 pm Post subject:

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

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"

dick scherrer · Posted: Thu Oct 02, 2008 8:15 pm Post subject:

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.